Adding Values to Dependant Dropdowns

[Ultan_Coyle]

Hi there,

This might be a silly question. I have searched for an answer for this but I wasn’t able to find what I need. I hope someone in the community might be able to help.

I have created a dependant dropdown from a table. The first dropdown is Category and the second is Subcategory, and the last column is a text column for topic. I do need to be able to add or update values in the subcategory column but I am not sure how to go about this other than doing the updates in the backend spreadsheet. If anyone has any guidance it would be greatly appreciated.

[Aurelien · Accepted solution]

Hi @Ultan_Coyle

Welcome to the community.

What about:

table1: Categories, columns :

• key,
• name

Table2: subCategories, columns:

• key,
• name,
• category ==> type:Ref, source table: Categories

Table0: Main_Logs, columns:

• key
• description
• Category ==> Type Ref, source table: Categories
• subCategory
  ==> Type Ref, source table : SubCategories
  ==> Valid_If expression:
  FILTER("SubCategories",[Category]=[_THISROW].[Category])

At adding a new Main_Log row, you should see something like this:
(Nouveau = New)

[Ultan_Coyle]

That makes a lot of sense, thank you for taking the time. Really appreciate it.