Cascading - Multiple filters and conditions

Forms SharePoint Online
1

I have been able to show or hide certain SPO fields based on conditions. Such as if "field1" == "something1", then "show/hide field2". I was able to learn that from the documentation. Thank you for posting that on your site.

Now I need to take a deeper dive. From top left to bottom illustrates the order of operations - or desired results.

This is more complex than your documentation and I am at a roadblock. Thank you for any help you can offer.

PlumsailCommunityHelp
PlumsailCommunityHelp.png902×676 22.8 KB

2

Hello @shedev,

Could you please give more details so I could better guide you to implement this.

  • What are the field types?
  • The condition is based on other fields value or it is static?
  • Do you need to order the lookup field? Based on what information?

Also, It would be great if you could add the screenshots of your form for clarity.

Thank you!

3

Plumsail Forms SharePoint Online Version 1.4.6 (2019)

To answer your questions:

Field types - DropDown (SharePoint Choice)

Condition - Dynamic (based on other fields value)

Lookup field - ordered, yes

Information basis - main group, sub-groups, etc.

In the screenshot, you can see each of the areas of the outline. This entire outline will be available based on the selection of a choice field immediately listed before the outline. Once that required selection is made, I need JavaScript to reveal the related outline (I have all outlines in a master list used as a database). I successfully have been able to show/hide fields based on the choice. What I cannot do is to figure out how to do is...I will give you a scenario:

User chooses B (from screenshot), A + C-F should all be hidden. Further, if the user has chosen B from a DropDown, (B) itself and (2.) cannot be chosen because they have children, so valid choices for B would be (B.1.), (B.2.a), (B.2.b), (B.2.c), or (B.2.d).

AnonOutlineSample
AnonOutlineSample.png782×792 32.5 KB

I have temporarily used a workaround, employing SharePoint managed data fields to hide certain choices that are not related. It was the least desired option, but I needed to keep the project moving.

4

@shedev,

You can set up filtering of the lookup field values based on the input from the different field.

It will be very similar to cascading lookup but based on a drop-down field value. You can find an example in the 'Cascading Lookups (Filtering)' article.

Also, maybe you will be interested in information from the 'Set up view results for lookup field' article.

5

Thank you - I will review.

1 Like