Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Advanced Display Logic

Avatar

Employee

18-12-2020

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

9 Comments

Avatar

Level 3

09-02-2021

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

10-02-2021

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

10-01-2022

Can't agree more on this. You should be able to filter a dropdown based on the selection of another dropdown.