Field Keys

Field keys are the way each field from a table is identified when performing a function. For example, say we wanted to set the value of the field Box Price based on an Item’s price (from the Price field) times the number of items in the box (from the Units per Box field). We could do this by applying the following formula to Box Price:

MATH ( {Price} * {Units per Box} )

This function MATH is used for performing mathematical calculations, the result of which will be printed out in the corresponding field.

Formulas work in a similar way to how the equivalent functionality does in an Excel spreadsheet. Each field contains the formula which is then used to "create" the value it will eventually contain. Any field key variables used for the calculations are defined between curly brackets {}:

{field}            =  how we define a variable which is an actual filed.

{table.field}  =  how we define the name of a field associated with a linked table.

Tip: For data output using channels, we can also use the same logic to directly set the values of a field using the keyword: VALUE.