Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Background:
In prepare recipe I created an "if, then, else statement", inside this statement, one of the "then" condition is to set a field to a formula, where this formula itself is another "if statement" that references to a global variable.
Here is the syntax:
Field_A = (formula): if(${global_var} == 1, 'Y','Nxxxxxxx'), where this global_var is currently assigned to an integer value of 0.
Formula is shown as valid inside the "if, then, else statement", however an error message popped out when I tried to save the entire recipe.
Here is the error message:
Operating system used: win 11
Operating system used: win 11
I also tried double quotes and got the same error.
Hi,
The error message appears when the global variable global_var is missing.
Can you please check if the global variables is correctly set up?
Your formula works fine when global_var is defined in Administration > Settings > Global variables:
โ
โ
yes the global variable is there otherwise the formula wouldn't be valid.
I ended up enclosing global_var with double quotes and it worked:
if("${global_var}" == 1, 'Y','Nxxxxxxx')