How do I create a simple app/table which has list of rooms which has two variable - room number and room description and then when i select a room - it should show items in it which i can edit/add. Any example/ideas for this - assume I don’t know much about appsheet.
1 Like
Finishing Database App Questions
I have a building having 2 floors. Where there are 10 rooms. I want to build a database where I have List of Items Category: Flooring,Wall & Column,Ceiling,Glazing,Door and Window List of Rooms: R1 to R10 List of Items: 20 Items (say) where Items are not unique to each room. Each item has their item description and picture. I want to search room by floor, and it should get me all the relevant details for each room by item categoy.
1 Like
Learner:
How do I create a simple app/table which has list of rooms which has two variable - room number and room description and then when i select a room - it should show items in it which i can edit/add. Any example/ideas for this - assume I don’t know much about appsheet.
First, please edit the post and change the Category to “Questions”. It will get more attention there.
As for the app, I’ll assume you are using Google Sheets as the datasource.
You will want to create 2 sheets - Rooms and Room Items:
Rooms table has these columns:
* Room ID - TEXT - row key - Use UNIQUEID() function
* Room # - NUMBER -assigned number to the room
* Description - TEXT - a description of the room.
* (any other columns that describe the room)
Room Items table has these columns:
* Room Item ID - TEXT - row key - Use UNIQUEID() function
* Room - REF - the row key from the Rooms table
* Item - <<see below>> - REF column to a third Items table
* (any other columns that describe the item for this room)
Because rooms will likely have the same set of items in them, instead of typing out the details each time, I would also recommend including a third table named Items. This is just a table that provides a list of the basic items you can choose for a room. You can then have a dropdown to choose the Item in the Room Items table. Other columns in the Room Items table might provide specific details of THAT item for THAT room.
Items table has these columns:
* Item ID - TEXT - row key - Use UNIQUEID() function
* Name - TEXT - name of the item - chair, lamp, table, bed, dresser, etc
* Description - TEXT - detailed description of the item
* (any other columns that describe the item)
With the 3 sheets created based on the above, add them to AppSheet and adjust the column types (some will be automatically set but not all).
IMPORTANT: After the tables have been added to AppSheet, go the Room Items table and edit the Room column. Make sure it is a REF type column and set the “Is Part Of” flag to on. This creates a Parent/Child relationship and will automatically add an input table to the Room Form so you can add/edit the Items.
3 Likes