Set Field Value

This action will let you build an expression, and then save the results of that expression into the field you specify on one or many records.

Explanation

Set field value actions are probably the most common actions used in WorkXpress. Use field save actions to automatically save the result of an expression into a field.

Example: On a page about a Contact there exists a First Name field and a Last Name field. Most likely, though, a builder will want a field (Contact Name) automatically set with the Contact's full name in the form Last Name, First Name. This is done by attaching a set field value action to an automation trigger on the table, and building the expression ${Contact - Last Name}, ${Contact - First Name} and saving the result in the Contact Name field.

Settings

What field do you want to set?

Query a record (or set of records), and choose a field on those records that you wish to set.

What value do you want to set in the selected field?

The result of this expression will be set into the field you chose above. If your query finds more than one record, the value will be set into the selected field on each record.

Disable associated field actions

Check this box to disable all actions associated with the field the value is getting saved in.

Describe this action

Useful as a comment, this description will overwrite the automatically generated description in the Action Manager.

Queue this action and children

When an action is queued, the subsequent actions continue to process without it. Meanwhile, the queued action and its children process separately. Queue actions that you don't want a user to wait for.

action type - set field value.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024