This shows you the differences between two versions of the page.

Link to this comparison view

action type - set field value [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Set Field Value ======
 +This action will let you [[Expression Builder|build an expression]],​ and then save the results of that expression into the field you specify on one or many [[Record|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 Builder|expression]] into a [[Field|field]].
 +Example: On a [[Form Type - Page|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|automation trigger]] on the [[Table|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.
 +{{ ::​action_field_save_field.png?​direct |}}
 +==== 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.
 +{{ ::​action_field_save_expression.png?​direct |}}
 +==== 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|Action Manager]].
 +==== Queue this action and children ====
 +When an action is [[Action Queue|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 14:19 (external edit)
Copyright WorkXpress, 2020