Forum Discussion

AleksandarSalap's avatar
AleksandarSalap
Qrew Cadet
8 years ago

conditional dropdown on the same table

Hello,

I have two fields on the same table: Product Line and Product Family.

Values in Product Line are: Field Services, Managed Services, Transaction Services.
Values in Product Family are: Analytics As a Service (MS), Event Management (MS), Multi Vendor Services (FS), Hardware Maintenance (FS), Staging Services (TS).

I would like following: when I select for example Field Services I want to have dropdown list in Product Family with only (FS) names, when I select Managed Services I want dropdown in Product Family to show only (MS) names etc.

Both of those fields are within the same table.

Could you please tell me how this can be done?
I'm aware that I could use separate tables for this but I would like to have this option without the need to create new tables.

Thank you very much.
Ask about Quickbase functionality
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Conditional drop down only works via tables. You only have 1 CDD, which is the second drop down field, so that is the one where the values will be selected by a relationship. If you have existing data, I suggest that you make the key field the Words for the drop down choices. That way it will not disturb your existing data when you build the relationship.

    If this app is in production, you may want to do this first in a copy of your app if you have not done this before,