We have a text field, but tucked away in a drawer. To alert the user to its presence, if it has contents, we are trying to use a UI only formula field that renders as a checkbox.
For the formula, we are using
if({{field_name}},1,0)
However, the error “1. Invalid syntax for field formula: {{field_name}}. ReferenceError: Test is not defined” occurs.
If we change the formula result to render as text and do
if({{field_name}},“a”,“b”)
then it renders ‘a’ and ‘b’ as we expect.
How do we set the checkbox state as a result of an “is the text field empty” query?
Thanks!
greg
Question
Checkbox UI only field set from formula result?
This topic has been closed for replies.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
