Change values of multiple fields
The action sets (overwrites) several form field values by assigning column values from a chosen data source to them.
If the data source has been specified, a query is made with connection parameters specified in the data source definition.
1. Data source
A data source from which or in the context of which values will be downloaded.
2. SQL query
Used to choose a particular table from a selected data source.
3. Fields mapping
A table with names of form fields whose values are to be replaced with values from the appropriate data source columns.
4. Get columns
Downloads a list of columns according to the current SQL query.
For more information, see The "Change value of single field" and "Change values of multiple fields" actions on our technical blog.