Bookshelf v7.5: On Field Update Set n

This user property allows you to set the value of a field in the business component when another field is updated.


Parent Object Type	Business Component
Syntax	The value for On Field Update Set consists of three quoted parameters separated by a comma and a space, as follows: "`[FieldToCheck]`"`,` "`[FieldToSet]`"`,` "`[Value]`" [FieldToSet] is set to [Value] when [FieldToCheck] is updated. If the Value parameter is not defined, [FieldToSet] is set to the value of [FieldToCheck]. An expression can optionally be used for the Value parameter. In the following example, the Done field is set using the expression when the Done Flag field is updated. "Done Flag", "Done", "IIF ([Done Flag] = ""Y"", Today (), """")" Additionally, if you use an expression, you can include a fourth parameter that defines a condition. NOTE: If you use an expression, it must evaluate to the data type of the targeted field. In the following example, the ToChar function is used to convert the date to a string before concatenating with another string and setting value of the field. "Agreement Start Date", "Name", "ToChar([Agreement Start Date]) + [Agreement Type]"
Usage	You can create additional instances of this user property as needed. If you have more than one instance of this user property for a business component, they are executed sequentially by number (for example, On Field Update Set 1, then On Field Update Set 2, and so on). If there is only one such user property, then no number is required.
Functional Area	CSSBCBase