Re: Cascading Dropdown with rule to set a Field's value then filter

Reema Daga — Fri, 24 Apr 2015 19:07:34 GMT

Hi there,

Please check this Cascading Dropdowns in InfoPath video tutorial.

Hope this helps!

Thanks,

Reema Daga

Qdabra® Software / 877.544.2389 main / 425 999 4597 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Re: Cascading Dropdown with rule to set a Field's value then filter

MRC123 — Tue, 21 Apr 2015 14:39:53 GMT

Anyone?? I am at a standstill with form until I can get past this Rule/Filter thing.

Cascading Dropdown with rule to set a Field's value then filter

MRC123 — Mon, 20 Apr 2015 18:36:23 GMT

Hi Everyone

I have a form for Conference Room reservations. I have several things that need to happen in the form. First is they need to select a location (we have two office buildings) their are others fields but I'll just use the important ones. Then they need to put in the number of Attendees that will be attending the meeting, then based on the location above the proper dropdown for room selection is made available (if they choose location 1 then location 1 dropdown will be active for them to choose a room) based on the location they chose above. So location 1 is now available for them to make a room selection based on the number of attendees.

What I need next is proving difficult. I need the Setup for that room based on the minimum and maximum for that room to be returned. So room 103 could have 3 different room setups based on the number of attendees.

I am using a SP list as my secondary list called room options (secondary).

Example data from my list. Example scenario would be need to book a room at Central, I will have 40 people, based on that I get to choose the room options that fit within those parameters. I pick room 103 then the Set-up Down-down should populate with Theater, Hollow Rectangle, Pod/Rounds and Classroom.

Columns Are

ID RoomNum Min Max Setup Location

13	103	15	81	Theater	Central
26	103	15	33	U-Shape	Central
41	103	15	42	Hollow Rectangle	Central
55	103	15	24	T-Shape	Central
70	103	15	24	Conference	Central
83	103	15	54	Pod/Rounds	Central
97	103	15	36	T-Pods	Central
112	103	15	72	Classroom	Central

Any help would be greatly appreciated.

Michelle

Newbie Questions

Re: Cascading Dropdown with rule to set a Field's value then filter

Re: Cascading Dropdown with rule to set a Field's value then filter

Cascading Dropdown with rule to set a Field's value then filter