I use variables to use in my Flow() trickers. I set the variables based on textinput and comboboxes.
I would like to use the Coalesce() formula here, but when my controls are not set then this function returns a blank() value. Issue is that I can't pass nulls to Flow(), so I have to use a large quantity of If() formulas.
What I want is a default value for the Coalesce() formula, so it could always return a value when the inputs are blank(). So Current formula:
Coalesce(Input1, Input2, ...) // Returns a Blank() if inputs don't return a value
Coalesce(Input1, Input2, ..., Default) // Returns the default if inputs don't return a value.
By the way:
It should be possible for the 'default' to be a string or a number
I also posted a thread on adding a IsNull() formula, see link IDEA: IsNull But I prefer a default for the Coalesce() formula over this thread, because we check do multipe inputs.
This takes all the programmers a lot of time, so I hope you can address this issue soon.