I’m creating an equipment reservation application. I am using AppSheet DB instead of Google Sheets, but unsure if this is the right approach. There are different Tables for each category of equipment and a Reserve Table. I’m trying to link the Reserve table to each Equipment category so that multiple items could be selected for a reservation. I’m looking to provide a list of “Available” items to be select from and have them listed/added to the “Reserved” column…
I’ve created a Slice to show only items with Available as “Yes”, but unsure how to have the selected items added to the EnumList “Reserved” column…
Unsure if I’m doing this right, but any help would be appreciated…
Hello. To be honest, I didn’t fully understand the question, but I’ll try to answer based on what I managed to grasp.
• If you want a dropdown list with available values, where only one value can be selected at a time, and you need the table containing those values to have a system-generated “Related” virtual column, then use a REF column pointing to the table where the records you need are stored.
• If you want a dropdown list with available values, where only one value can be selected at a time, but you don’t need a RELATED column in the table containing the selectable records, then use Enum with base type Ref in the table where the records you want to select are stored.
• If you want a dropdown list that displays selectable records, but allows selecting multiple values at once, then use EnumList with base type Ref.
• If you’re using AppSheet’s database instead of Google Sheets, you must configure this in the database itself, as the editor won’t allow much customization.