Forum Discussion

UmaHarithsa's avatar
UmaHarithsa
Qrew Cadet
7 years ago

Conditional dropdown shows error

I 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.
Forms
  • SuryaExpert's avatar
    SuryaExpert
    Qrew Assistant Captain
    7 years ago
    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?
  • PhilPinkham's avatar
    PhilPinkham
    Qrew Trainee
    7 years ago
    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.
  • UmaHarithsa's avatar
    UmaHarithsa
    Qrew Cadet
    7 years ago
    Thanks 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.
  • UmaHarithsa's avatar
    UmaHarithsa
    Qrew Cadet
    7 years ago
    I 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.