Add new values to select list or other table from row input

Hi folks,

Just a quick note to let you know that we just completed the first phase of support for this request.

We handle two classes of source values:

  • Simple list of values - this class of formula is already well supported in the existing config UX as a simple comma-separated list of values. Adding a new value from the drop down magically updates the source values for you.
  • Linked tables where the display column value is non-calculated. When the add value option is selected, a row is created in the target with the display column value set to the display text.

To reduce the likelihood a user could inadvertently add a value, we add speed bump in the UX; hitting ENTER will select the “add value option” and ENTER again adds it. You can also directly click the add option or cursor down and hit ENTER to add it.

I’m currently in the process of working on a few other extensions for table based formulas too. Hoping to get that wrapped within the next week.

Hope you all enjoy it! Please keep the suggestions and feedback coming.

Nigel.

7 Likes