conditional dropdown on the same table

  • 0
  • 2
  • Question
  • Updated 11 months ago
  • Answered
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.
Photo of Aleksandar Salapura

Aleksandar Salapura

  • 482 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 2
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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,
Photo of Aleksandar Salapura

Aleksandar Salapura

  • 482 Points 250 badge 2x thumb
Thank you very much for fast reply, appreciate it.