Expand my Community achievements bar.

Advanced Display Logic

Avatar

Employee

12/18/20

When entering expenses and filling out the expense form, customers have a long list of Vendors that a person can choose from. However, not all vendors are valid selections for all of their subsidiaries, which is a field earlier on the form. The solution today is to build out multiple shortened vendor fields; one for each subsidiary. An example is attached in the screenshot. There are two problems with this solution:

  1. This solution doesn’t work well for inline entry of objects, which this customer uses. To allow for inline entry/editing it’s just not scalable to have all the different vendor fields in the view and to trust the user to fill out the right one.
  2. Reporting: when you want to report on vendor, you now have multiple vendor fields that could actually contain a value. All but one of them will be blank on any one expense. The only way I’ve found to get around this is to build a calculated field to essentially “funnel” the all of the different vendor fields back down to this one calculated field and then report on it.

The actual idea:

It’s kind of an evolution of display logic. The customer would like to be able to filter selection fields (dropdowns, checkboxes, radio buttons) based on choices made in previous fields. I don’t know if this would be built on the framework of the Typeahead filtering, or if it would be its own thing. But I think it would be a nice addition

10 Comments

Avatar

Level 3

2/9/21

Thanks Anthony, do you envision that the RESULTS of the fields (choices) below in the form are truncated based on selections earlier in the form? I can certainly see the benefits of that. Currently we have some multi-select fields that I'd really not wish to display to a user if they've chosen "A" earlier in the form, but also don't want to make multiple very similar fields to truncate choices.


This flexibility would be great.

Avatar

Employee

2/10/21

James Hill: Yes you're correct. This feature request is where a selection in the form can cause following fields to be filtered and show different options depending on what was selected previously.

Avatar

Level 3

3/22/23

Wondering if this idea has made any traction? We have several fields where the ability to hide domain of values within a dropdown, checkbox, etc.. would be ideal.