Run script if field has been modified

[lgaray]

Hello:

How can I make a script run if and only if a certain field has been modifiedi in a particular record?

Thanks for your help!

[Chuck]

You can use a plug-in like ScriptScheduler or you can use global fields for your data entry. The second way requires that a global field exist for each field you want to offer the user for entry. When the user needs to edit a record, you first copy all of the entry fields to these global fields, take the user to a layout with the global fields and then have them click a button to save the changes. This buttons is linked to a script that checks to see if the field you want has been changed and if so does whatever you want to happen.

Another way is to make a field not allow entry in the field format. Create a global field and make the normal field a button on the layout that has the following script:

Set Field [gYour_Field, Your_Field]

Go to Field [Your_Field]

Loop

[Chuck]

pcourterelle,

Assuming that the popup field will have only one value, either a value in the value list or a single value (in other words, when the user selects "Other" they enter one line of information, then it's pretty easy to find out if they have made a selection in Other.

Create a calculation field or use the If script step with the following calculation:

PatternCount( ValueListItems(Status(CurrentFileName), "Your_Value_List"), Pop_Up_Field )

This returns a 1 if the value in Pop_Up_Field is a value list item and 0 if it isn't.

You could even automate the process, placing the value into a separate field yourself instead of requiring the user to do it.

Show All Records

Go to Record/Request/Page [ First ]

Loop

[pcourterelle]

Hi...similar question on a similar process...I have a pop up field with several options in a value list, including the option "Other". The options in the value list are fixed and cannot be edited by the user. What I'm working on is to have a script that runs automatically if and only if the Other option is selected. The script will bring up a dialogue box that asks the user to enter the "Other" information in a separate field.

Thoughts?

pc

[ June 13, 2001: Message edited by: pcourterelle ]