Skip to main content

I need some help on setting up this scenario.

 

Drop Down 1 - filter to 1 ID

Drop Down 2 - filtered to records based on Drop Down 1

Drop Down 3 - filtered to records based on Drop Down 2  (hidden field)

 

Drop Down 4 -  need to filter in all of the records in from Drop Down 3 not just based on 1 ID.

 

Basically if the records exist in Drop Down 3 I need to display the same records in Drop Down 4

 

 

Example:  

Drop Down 1 -   Teachers - they pick 1 teacher

Drop Down 2 -  Sections that belong to teachers in drop down 1

Drop Down 3 -  enrollment based on Section that populates student #

Drop down 4 -  I want to display name information on all the student #s populated in Drop Down 3.

 

Thanks in advance!  Hopefully that made sense.

Hi,

 

you can do it . Configure the drop down and disable all the aupopulate date rules from view and then enable firrst Drop down auto populate rule.

 

you can write the rule as below .

 

1. Use default aupopulate rule for first Drop down list

2 . On chane of first drop down . write a rule to populate the record in second drop down and pass the input parammeter from first drop down list smart object field.

3. Same as for third drop down on change of second drop down

 

 

Thnks

Alternatively, if by "student #" you mean a student ID that is in the same table as the student name, you could set the display of drop down 3 to be "student ID - Student Name"

I'm basically trying to create a many to many relationship.

 

The Teacher selects 1 section that has multiple kids tied to the section. So I need the drop down to populate many records.

 

Table 1 (Enrollment)

SectionID

StudentID

 

Table 2 (Students)

StudentID

FirstName

LastName

 

I need to get a concatination of the Section, First name, lastname.

 

Hopefully that makes better sense.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings