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:
Table: Items
Columns: Item, Project
Table: Lookups
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.
Solved! Go to Solution.
Hi @Jeff_Gordon. Welcome to AppSheet. What you’re looking for is references between tables. You would make the Project column in your Items table a Ref column that points to your Lookups table. In the mobile UI, this will show up as a dropdown menu with an option to add a new row to the Lookups table.
Take a look at these sample apps, too:
basic demo of references
order capture app that extensively uses references
Hi @Jeff_Gordon. Welcome to AppSheet. What you’re looking for is references between tables. You would make the Project column in your Items table a Ref column that points to your Lookups table. In the mobile UI, this will show up as a dropdown menu with an option to add a new row to the Lookups table.
Take a look at these sample apps, too:
basic demo of references
order capture app that extensively uses references
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |