The capitalize formula in this formula works when the first condition is false, but breaks when it’s true. Bug?
First condition false - OK
First condition true - Breaks
What is the value of bank_pmt_failed in this condition. That will tell your more info.
@jared Its a boolean variable. In the first scenario where the formula works, value is false. In second scenario where formula breaks, its true.
what’s the value of the variable in the capitalize formula? Probably when the if condition is true that variable is not a string and you get that error.
Remember that the if formula is not a if/else statement, it’s a function. All the parameters are evaluated.
Sometimes it’s easier to switch to javascript and use a real if/else statement. You can still use the other formulas.
As an alternative add a default value for the capitalize formula. Something like capitalize( yourvariable || '')
3 Likes
You were right again @dorilama. In that scenario the variable in the capitalize formula was empty, so there was nothing to capitalize. I added a default value per your suggestion and that worked. Thanks!
1 Like