Alternate column calculations for ingredients

The Formula, Item, Project and Specification forms have pre-defined columns named Attribute. These columns have no contents and can be customized.

The system administrator can configure the Attribute columns and associate script hooks and VB.NET scripts with them. When the value for one column changes, a calculation can be run to adjust the value in another column in the formula.

  • You can use event script hooks with DataRowCurrent and DataRowProposed functions. This enables you to retrieve current or changed values to calculate values for other columns.
  • The FormulaIngr.TotalColumns profile attribute can also be used to total the column’s values at the bottom of the column.