A few improvements for ui-only formula fields

  • 5
  • Idea
  • Updated 3 years ago
  • Under Consideration
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.
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb

Posted 3 years ago

  • 5
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
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.
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Some kind of switch/case statement would be helpful as well. I'm finding myself with lots of nested IFs.