Forum Discussion

BariVaz's avatar
BariVaz
Registered
20 hours ago

Change data used to populate dropdowns, based on other factors

I am brand new to QuickBase, and have been asked to maintain an existing system where users rate various information presented on multiple tabs in a Form. The data presented in stored in records in a Table, and the selection made in the dropdown on the first tab determines which record in the table is imported to display on the Form. The only exception is the data that populates the various dropdowns, which in past was imported from a single Lookup list (think numbers - 0, 1, 2, 3). Each dropdown reflected the same scoring list (0,1,2,3).

Now, we want to be able to populate each dropdown on each tab with a different rating scale (0-3, 0-5, etc.) based upon (1) the selection made in the dropdown on the first tab; (2) the tab number; and (3) which dropdown on the tab (each dropdown on a single tab could have a different rating scale).

I have been researching, and I want to experiment during off hours, but if anyone has suggestions on how they may have accomplished something like this, I would be grateful for your input. Thanks!

Forms

1 Reply

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    10 hours ago

    I can give you a couple of options. One option is to have different multiple-choice fields subsequent tabs and use form rules to control which field show. That's probably the most straightforward way, but it does make data analysis afterward difficult.

     

    I can give you a couple of options. One option is to have different multiple-choice fields subsequent tabs and use form rules to control which field show. That's probably the most straightforward way, but it does make data analysis afterward difficult.

     

    The other possible concept is having the  choices come from a look up table that is driven by a conditional drop down.  That set up is a little more complicated initially, but could make it easier down the road to be able to analyze the results.

     

    That set up is a little more complicated initially, but could make it easier down the road to be able to analyze the results.

     

    Do you think you can work in your used case to have different fields show and hide based on selections on the first tab?.But when you are deciding whether it to show or hide a particular field, you want to make a rule based typically on that one field only. And then have another four rule control the next drop-down field, etc.

     

     But when you are deciding whether to show or hide a particular field, you want to make a rule based typically on that one field only. And then have another four rule control the next drop down field, etc. 

     

    Please feel free to post back with any additional Questions.