/
col.xyz.formula

col.xyz.formula

Owned by svitlana (Deactivated)
Last updated: Oct 18, 2023 by Dam

Use the formula property to calculate the content of a column. String, math and conditional expressions are supported

Class

Column

Property

col.xyz.formula

Formal specification

col.xyz.formula = expression

Required

no

Default

yes

Version

1.10

Comment

  • A column with a formula is read only 

  • When the column containing the formula is a string, values are trimmed to 254 chars

Example



col.label.formula = {company} + + {shipaddress} + + {contactperson} + + {weight} + lbs col.linetotal.formula={weight} * {shipprice} * 1.10



Reference

Formula - Examples 
Formula - formal syntax specifications



Related content