Question
In reports, second filter dropdown choices based on first user selected filter
+4Is it possible to do this in a report: have 2 dropdown filters (values from related tables), where the second dropdown values are filtered based on selection in the first dropdown? Essentially, conditional dropdown features in report filters, similar to that of forms.
This topic has been closed for replies.
+15You sure can!
Open the related field properties of the second dropdown. There is a section for "Conditional values". You'll check to box and indicate that a selection in the first dropdown shows choices that match a value in the second dropdown.
-Sharon
Open the related field properties of the second dropdown. There is a section for "Conditional values". You'll check to box and indicate that a selection in the first dropdown shows choices that match a value in the second dropdown.
-Sharon
+4Hello Sharon. I do have that set-up and it works well in a form. However, in the report the second dropdown shows all the values even before the 1st dropdown has been selected. Whereas in the form, the second dropdown has no values until the first dropdown is selected. Any suggestions on how to fix this? Thanks ins advance.
+15It sounds like you're using Grid Edit. Can you describe the relationships in more detail? When I use these conditional settings with Grid Edit, I cannot choose the second dropdown until I make a selection in the first.
-Sharon
-Sharon
+4It's a Table style report, not Grid Edit. I have 3 tables: Building, Location and Workstations. Building to Location is one to many; Location to Workstations is one to many; Building to Workstations is one to many relationship. See attached picture for the Related Location field set-up.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.