Data field

When Spreadsheet or Table section is bound to data, designer can decide that modified data will be saved to database by Save to database workflow action step.

Data field option maps cells to Data objects and columns.

Data field has to be in the following format: ObjectName.ColumnName

Examples:

Product.ID

Product.Price

SysUser.Email

SysUser.Name

When the designer drags a column from the data onto a cell, the field is automatically filled. 

Saving to Multiple Tables/Lists

If you want to save data to more than one table or list, simply provide values separated by commas in the "Data Field". You need to specify the table name and the column name. In this case, there is no need to specify the table or list name in the action step, as they are defined in the "Data Field".

Example:

When data field/column is dragged on section cell, Data field is automatically filled.

Data Field:

Products_price.price, Products_suppliers.price

In this case, data from the section will be saved to the price column in both the Products_price table and the Products_suppliers table.