So I have a table with a multiselect field that contains about 1000 different values that were used as general metadata tags for video content (topics, people, companies, events, etc). I want to somehow be able to use this multiselect field across different tables but have the ability for users to add new tags/values and have these new tags available on all tables.
There’s probably a better way to do this, but I thought I could somehow convert these multiselect options into individual records on a new table… then somehow be able to turn it back into a multiselect type field? I was able to copy the multiselect field with its options into a new black table (just copied and pasted all values and then deleted it), but I don’t know how to convert them into records
The ultimate goal is to then have this synced multiselect field available in a form, but somehow give the user the ability to add new tags from within the form… somehow… might require a link in the form to a “add tags” form?