A few improvements for ui-only formula fields

Some quick ideas:

  • Add basic text functions, like RIGHT(), LEFT(), MIDDLE(), TEXT(), etc.
  • Support more operators, like ‘contains’, &, etc.
  • (Potentially) allow a default value to be set by a formula, and then allow the user to edit the field from there.
  • (Advanced) – allow ‘testing’ of a formula in the builder by processing the formula for the first row of the model and displaying the result (or even better, walking through the formula process steps) on the builder side.

Thanks Matt.  These are all good ideas. We absolutely have formula testing on the radar for UI only fields.  As well as adding different kinds of function support.

Some kind of switch/case statement would be helpful as well. I’m finding myself with lots of nested IFs.