That sounds like a prime case for using links. Instead of making a single-select or multiple-select field, create a link to a new table, and build your list in that table. Any changes you make to the table will be reflected in any other tables that link to it, including forms that use those link fields.
If that’s not what you’re looking for, then could you provide more details about your use case?
That sounds like a prime case for using links. Instead of making a single-select or multiple-select field, create a link to a new table, and build your list in that table. Any changes you make to the table will be reflected in any other tables that link to it, including forms that use those link fields.
If that’s not what you’re looking for, then could you provide more details about your use case?
Hi, I understand about normalizing relational databases. I see in Airtable the ability to use drop down fields in lieu of a linked table.
Can you expound a bit on why you might use that instead of a linked table? I copied one of the templates I found in the Universe and their database is not normalized (they used DDL instead).
