Set expression for formula field

1. Open the form builder.
2. Select the required formula field.
3. Navigate to the Field Properties pane on the right.
4. Click the input box below Expression. The Calculate Expression pop-up window will appear.
5. Set the required Expression:
   • You can include fields in the expression by either selecting them (from the Refer Fields column) or typing their field link names in the Expression box. You can include all field types except add notes and section.
   • You can include Deluge System Variables by typing them
   • You can use built-in functions by typing them
6. Click Insert conditional formula to define one. Learn how

   

7. Upon setting the required Expression, click Done. The expression you set will then appear in the input box below Field Properties > Expression.​

   

Set a conditional expression

1. Open the form builder.
2. Select the required formula field.
3. Navigate to the Field Properties on the right.
4. Click the input box below Expression. The Calculate Expression pop-up window will appear.
5. Click Insert conditional formula.
6. Set the Condition: 
   • It must be a boolean expression — an expression which evaluates to true if it is logically correct, else false
   • You can refer to the fields by typing their field link names
   • You can use logical functions by typing them
7. Set Value1 and Value2:
   • ​These can either be static values or expressions
   • The formula field is assigned with Value1 when the specified Condition evaluates to true
   • The formula field is assigned with Value2 when the specified Condition evaluates to false

   

8. Click Insert. The conditional expression will appear in the Calculate Expression pop-up window.

   

9. Click Done. The expression will then appear in the input box below Field Properties > Expression.​