A user selects their name from the drop-down menu:
How do I tell AppSheet to autofill the Room number based on the name selected:
Solved! Go to Solution.
Your form seems to be a ticketing system and you seem to be referencing the name from another table? So are the room details available in the same table from where you are referencing the name?
If so, you could then use dereferencing expressions to pull the room number from the referenced table.
Dereference expressions - AppSheet Help
Also in the Tickets table, the room number is a number type column. However in the sample data you have shared it appears to be alphanumeric number , meaning a text column.
Your form seems to be a ticketing system and you seem to be referencing the name from another table? So are the room details available in the same table from where you are referencing the name?
If so, you could then use dereferencing expressions to pull the room number from the referenced table.
Dereference expressions - AppSheet Help
Also in the Tickets table, the room number is a number type column. However in the sample data you have shared it appears to be alphanumeric number , meaning a text column.
Works like magic🪄!
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |