Hi all,

I have spent all day stuck on this script. I am trying to "retrofit" this script by using JSON to pass multiple parameters into the script. I have attached two screenshots.

SCREENSHOT NAME: script_with_variable_not_working.png

This screenshot shows all script steps, PLUS, I commented in the beginning of the script the JSON I am using as Optional Script Parameters. This screenshot also shows an overlay of the dataviewer showing the incorrect results of the variable "$_container_field_name".

SCREENSHOT NAME: script_set_field_by_name_not_working.png

This screenshot shows line 16 throws the error message in red at the bottom: [102] Field is missing

I strongly suspect the problem lies is me trying to pass the field name of a CONTAINER type field using JSON. As a test, I tried switching to a TEXT type field and I was able to pass that as a variable.

GOAL:

1. To remove a PICTURE or FILE from a container field, without deleting the record.
2. To "parameterize" and use "variables" in this script so I can consolidate my scripts ( I need to stop making basically the same script over and over.)

APPROACH:

I wanted to pass two parameters using JSON so I can use:

• one parameter for the FILENAME in the Custom Dialog presented to User when deleting the container data;
• the second parameter to use as the field in which to use the Set Field script step to clear the content of the container.

Any help is appreciated, thanks.

 

12 hours ago, dmontano said:

I strongly suspect the problem lies is me trying to pass the field name of a CONTAINER type field using JSON.

From what I can see the problem is that you are passing the container field's value instead of its name.

Try defining the script parameter along the lines of =

JSONSetElement ( "" ;
[ "container_field_name" ; GetFieldName ( document::document_file ) ; JSONString ] ;
[ "container_file_name" ; document::document_filename ; JSONString ]
)

You could also get by with:

JSONSetElement ( "" ;
[ "container_field_name" ; "document::document_file" ; JSONString ] ;
[ "container_file_name" ; document::document_filename ; JSONString ]
)

but this would break if you renamed the container field.

 

 

Edited June 25, 2025Jun 25 by comment

On 6/25/2025 at 12:38 AM, comment said:

Try defining the script parameter along the lines of =

JSONSetElement ( "" ;
[ "container_field_name" ; GetFieldName ( document::document_file ) ; JSONString ] ;
[ "container_file_name" ; document::document_filename ; JSONString ]
)

Hi Comment - this was exactly the solution.

I appreciate your time and effort - thank you.