Question
Conditional dropdown shows error
+4I have a conditional dropdown that is generating the error: This is a conditional dropdown; First select.....I have created the 3 way relationships as described in the QuickBase Help. 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. I have a form where the Building names is a dropdown. Photo attached of the relationship, the form and the error. How do I debug this error further? And fix it? Thanks in advance.
This topic has been closed for replies.
Uma,
From what you are saying, Buildings have many Locations and Location has many workstations, correct? For Location, you should say it depends on the building selection. Then for workstations, it depends on the location selection. If this is how you set it up, the first thing you need to select is the Building. What's wrong with that? Isn't that what you wanted?
From what you are saying, Buildings have many Locations and Location has many workstations, correct? For Location, you should say it depends on the building selection. Then for workstations, it depends on the location selection. If this is how you set it up, the first thing you need to select is the Building. What's wrong with that? Isn't that what you wanted?
The field 'Building (Hospital or Practice) - Building Name' on the Workstation Hardware form needs to be placed on the form in order for the conditional filter to work. If it is not on the form it cannot be 'seen' by the drop down list.
+4Thanks Surya and Phil. Here is a snapshot of the form. The Related Building is on the form.
@ Surya. That is how I want it to work.. But, it was not working and giving the error message even after I had selected the Building.
@ Phil, See the attached form.
@ Surya. That is how I want it to work.. But, it was not working and giving the error message even after I had selected the Building.
@ Phil, See the attached form.
+4I think I fixed it. I changed the fields from Building Name and Location: Department Name to Related Building and Related Location and now it is not giving the error message any more.
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.