I’m a brand new user to AppSheet and I’m trying to figure out how to approach a problem I have. My app is a To Do list and to simplify it:
Columns: Item, Project
Columns: Project Name
When a user (me) is editing or adding a record to the Items table, I want to have them select from a list of Projects in the Lookups table. Pretty straight forward. However, if the Project isn’t in the Lookups table, I want them to be able to add another Project and have it added into the Lookups table. I know I could use Enum with “AllowOtherValues” and “AutoCompleteOtherValues”. However, then the new projects don’t get added back into my Lookups table.
Thoughts on how best to accomplish this? I’m wondering if I need to use a Reference instead of a Lookup.