Crow Canyon Software Forum

Forum Navigation
Please or Register to create posts and topics.

Execute a Custom Action when a column value changes on a form.

We have a list of IT Assets, some of which are associated with a vehicle, and we would like to create a history record whenever the asset is assigned or unassigned to a vehicle. Currently the user clicks a button on the form, which calls a Custom Action that creates the history record, and we'd like to eliminate the buttons.

The question is this: Can the Custom Action be called when the value in the vehicle column changes? Perhaps a script in Form Event Actions can execute a Custom Action? Or can a workflow detect when that particular field has changed and either call the Custom Action, or create the history record itself?

Any ideas or assistance would be greatly appreciated!
Thanks.

Hi - We can use NITRO Workflows to create history record whenever the "Vehicle" column value is modified.

Please configure a workflow similar to the Custom Action that creates the history record and then configure after change condition for the vehicle column at workflow level as shown below.

Syntax: afterchange:[[Any]]

 

Uploaded files:
  • WFConditions.png

Thank you for the info, it was exactly what I needed.

 

Hi, Just wondering what other parameters are available in addition to [[Any]] in the expression afterchange:[[Any]]. Can you please advise? Thank so much!

Quote from lnbryant on October 6, 2024, 10:43 am

Hi, Just wondering what other parameters are available in addition to [[Any]] in the expression afterchange:[[Any]]. Can you please advise? Thank so much!

Hi,

'afterchange' is used in conditions to check if the value of a column has been changed as part of the current update process.

The possible values are:
1. afterchange:Fixed value
2. afterchange:[Column Display Name|Column Internal Name]
3. afterchange:[[Any]]
4. afterchange:[[None]]

These details can be found in the article Syntax for Expressions in NITRO Workflows - Crow Canyon Software Support under the section 'Placeholders and examples'.

Regards,

Crow Canyon Support

pf-amalin and lnbryant have reacted to this post.
pf-amalinlnbryant

This is exactly what I was looking for- thank you!