I have same formula on the same button. When I load the page, the formula is showing a result, and therefore the button is “disabled” or “ghost”, but when I change the variable (Select Folder-value), it doesn’t manage to calculate it, so there is no result and it is not showing correctly the button.
I have a workflow on the Select Folder-value, that fetches all the collections and changes the all the variables.
Has someone an idea how to fix this?
Hi @tcc ,
Could your question be redefined into: how to provide a default value in case of a formula error?
If so, that’s also what I keep struggling with.
Regarding your specific case failing to produce one object as a result: you can best diagnose/fix that in the workflow that you trigger with the button. Perhaps its easier to chop your function into multiple steps (with a combination of returning a result and true/false-split) - so you can run your tests and exactly see where your formula fails.