Can I use a form to update a column with 2 different, mutually exclusive single selects

Platform discussions Special workflows & use cases
, ,
1

I have a form with single-select with two options.

CLASS:

  • Program
  • Bonus

If I select Program, then the form opens another single-select with several options to populate a column called CATEGORY.

If CLASS = Program

APPLICATION (Single-select)

  • Program 1
  • Program 2
  • Program 3

If I select Bonus, then the form opens a single-select with a different set of options to populate the APPLICATION column.

If CLASS = Bonus

APPLICATION (Single-select)

  • Bonus level 1
  • Bonus level 2
  • Bonus level 3

When I do this, I end up with 2 columns called APPLICATION. Is there a way to accomplish this without creating 2 columns on the board with the same name? I intend to have several other options for CLASS, each with its own set of APPLICATIONS.

2

It seems like the key here is to establish the hierarchy and dependency between the columns. Based on what you described:

  1. If CLASS is the parent field, then the options under APPLICATION should depend on the selected value in CLASS (e.g., Program or Bonus).
  2. If BONUSES and APPLICATIONS are truly independent and not dependent on CLASS, then they should be separate columns to avoid confusion.

I would recommend you creating a new form to handle this setup correctly. Before proceeding:

  1. Backup Your Data: If the current columns have data, export or back it up to ensure no information is lost.
  2. Delete the Old Columns: Remove the existing columns that are causing duplication or confusion.
  3. Create a New Form:
  • Design the form with the updated columns, ensuring that they are connected logically.
  • For example, set up CLASS as the main field, and then use a single APPLICATION column with dynamic options based on the CLASS value.