- Excel Desktop Client new !
When one of several visible data entry objects change, VALUE CHANGED creates a reference to the changed object and then triggers an EVENT.
One or more objects are listed in Objects: and if one of them changes: the Event Source: references the object that has changed and an subsequent EVENT is triggered with corresponding ACTION's.
If no objects are specified, VALUE CHANGED will behave globally: if any value in the EASAP changes, the ACTION's associated with the VALUE CHANGED EVENT will take place.
|Objects:||Select one or more visible data entry objects. If left empty, it will be triggered by the change of any value in the EASAP. (Warning: If a FILE CHOICE is used here, a subseqent WRITE EXCEL ACTION will introduce a 'race condition' between the two and should be avoided)|
|Event Source:||Enter a new of a new object that will contain the value of the object in Objects: whose value has changed.|
To trigger SET STYLE ACTION from a VALUE CHANGED EVENT:
changedBox's value is the particular input that changed.
The name changedBox is declared in Event Source: above.
So now in our example: if input2 changes, only its USER INTERFACE STYLE will be updated: in this case red text on a blue background.
Screenshots showing the VALUE CHANGED and SET STYLE ACTION configuration below: