Crow Canyon Software Forum
Execute a Custom Action when a column value changes on a form.
Quote from pf-amalin on July 31, 2024, 6:34 pmWe 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.
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.
Quote from supportTeam on August 13, 2024, 2:18 pmHi - 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]]
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:
Quote from lnbryant on October 6, 2024, 10:43 amHi, Just wondering what other parameters are available in addition to [[Any]] in the expression afterchange:[[Any]]. Can you please advise? Thank so much!
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 supportTeam on October 7, 2024, 7:21 amQuote from lnbryant on October 6, 2024, 10:43 amHi, 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
Quote from lnbryant on October 6, 2024, 10:43 amHi, 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