...
Formula
Choose this mode to specify a formula using foreign key constraints between record type membersprogrammatically set constraints. Simple math, string, and date operations using JavaScript syntax are supported. You can also use the ready-made aggregate functions in your formulas (e.g., SUM, COUNT, etc.).
See Consuming the Data in Tools for information on the syntax for referencing other record type members.
About Formula Variables
- Variables start with "
${" (dollar sign and open curly brace) and end with "}" (closed curly brace). - You can point to a member within the same record type using the
${member}syntax. - If the variable references the same member for which the mask/generate settings are being applied, the original value will be used in the formula.
- In simple and hierarchical data sets, you can point to a member within a specified record type using the
${recordType.member}syntax. - You can point to a key within a specified data set using the
${dataSet:ds.key}syntax.
...
Examples
The following formula computes a subtotal price.
SUM(${cart_item.price})*${sales_tax.rate})
The following formula generates an email address:
CONCAT(${FIRSTNAME},"_",${LASTNAME},"@parabank.com")
From Seed
Choose this mode to generate data using values from an existing repository. This mode requires additional settings to be configured.
...