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.
2 Likes
Hi @Ultan_Coyle
Welcome to the community.
What about:
table1: Categories, columns :
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)
4 Likes
That makes a lot of sense, thank you for taking the time. Really appreciate it.
2 Likes
