I’m creating a database with multiple select and single select columns. I want the “answers” / “tags” (aka what people can select) to be generated when my team fills in a form for this database. As an example, I want the form users to be able to enter 5 keywords for a particular person’s interest, and have these keywords automatically become the options for new form users to select from in addition to new form users being able to enter new keywords (adding to the growing list). Or, I want them to be able to enter an organization’s name on the form (free writing it) and have that name automatically become part of a single select column for organizations on the back end.
Is this possible? If so, how do I make this happen?