Quick Base Discussions

Expand all | Collapse all

conditional dropdown on the same table

  • 1.  conditional dropdown on the same table

    Posted 12-13-2017 11:47
    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.


  • 2.  RE: conditional dropdown on the same table

    Posted 12-13-2017 12:43
    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,


  • 3.  RE: conditional dropdown on the same table

    Posted 12-13-2017 12:46
    Thank you very much for fast reply, appreciate it.