VAL

The VAL formula is intended for use when a dynamic dependency would lead to circular reference issues

Syntax

VAL('dataname')

Example

IF(ISBLANK({{oneField}}), VAL('otherField'), {{oneField}})

Notes

This formula will evaluate once when the form loads and thereafter will only ever re-evaluate when the value of 'oneField' changes. This formula is not dynamically dependent on 'otherField' in any way since it does not contain a dynamic reference {{otherField}}. When the value of 'otherField' changes, this formula will not re-evaluate.

It is not dynamic when used alone, returning the value of the field referenced, 'dataname'