I’m creating a few calculated fields on modules (where Field value expression is ticked) but I’m running into problems quite often. The only way to know an expression is bad is to try to create a record and get an uninformative error: “Could not update record: check error messages on the form”. There are no messages anywhere on the form. I know this is caused by the expression because when I remove it the record saves successfully.
Is there a way to validate these expressions while writing them and get meaningful errors? Without this the process involves a lot of guess-work and is super slow.
We’ve avoided using field expressions for calculated values, and prefer using a workflow to set values, which helps with error checking and more complex record management. If you need to use the calculated value before the record is created or updated, a field expression won’t work.