Hotel Room Inspection (Row template question)

AppSheet AppSheet Q&A
1

@WillowMobileSys

Hello, Thanks for your reply from my previous comments, I just give a try but sorry I still didn’t get it

so I will explain more detail.

I make an inspection App for Hotel room, I have a list of questions that will be filled by operator’s who doing the inspection, the list is static, around 15 questions/rows, so every room have same list of 15 questions(Yes/NO).

So the Operator will choose which Floor, which Room number and then filled list of question,

Question Table

ID Item Yes/No Note
q1 Question 1
q2 Question 2
q3 Question 3
q4 Question 4
q5 Question 5
q6 Question 6
q7 Question 7
q8 Question 8
q9 Question 9
q10 Question 10
q11 Question 11
q12 Question 12
q13 Question 13
q14 Question 14
q15 Question 15

ex. result table

ID Operator Name Date Floor Room Number List Question Yes/No Note
a1 ABC 5/9/2024 3 302 Question 1 Yes
a2 ABC 5/9/2024 3 302 Question 2 No
a3 ABC 5/9/2024 3 302 Question 3 Yes
a4 ABC 5/9/2024 3 302 Question 4 N.A.
a5 ABC 5/9/2024 3 302 Question 5 Yes
a6 ABC 5/9/2024 3 302 Question 6 N.A.
a7 ABC 5/9/2024 3 302 Question 7 No
a8 ABC 5/9/2024 3 302 Question 8 Yes
a9 ABC 5/9/2024 3 302 Question 9 No
a10 ABC 5/9/2024 3 302 Question 10 Yes
a11 ABC 5/9/2024 3 302 Question 11 Yes
a12 ABC 5/9/2024 3 302 Question 12 No
a13 ABC 5/9/2024 3 302 Question 13 Yes
a14 ABC 5/9/2024 3 302 Question 14 No
a15 ABC 5/9/2024 3 302 Question 15 N.A.
a16 ABC 5/9/2024 3 305 Question 1 Yes
a17 ABC 5/9/2024 3 305 Question 2 No
a18 ABC 5/9/2024 3 305 Question 3 Yes
a19 ABC 5/9/2024 3 305 Question 4 N.A.
a20 ABC 5/9/2024 3 305 Question 5 Yes
a21 ABC 5/9/2024 3 305 Question 6 N.A.
a22 ABC 5/9/2024 3 305 Question 7 No
a23 ABC 5/9/2024 3 305 Question 8 Yes
a24 ABC 5/9/2024 3 305 Question 9 No
a25 ABC 5/9/2024 3 305 Question 10 Yes
a26 ABC 5/9/2024 3 305 Question 11 Yes
a27 ABC 5/9/2024 3 305 Question 12 No
a28 ABC 5/9/2024 3 305 Question 13 Yes
a29 ABC 5/9/2024 3 305 Question 14 No
a30 ABC 5/9/2024 3 305 Question 15 N.A.

I hope you understand with it

thank you for your help

2

For now your structure is less complicated - I’ll go into that more later.

You have the right idea. What I would recommend is to separate the Inspection level details from the Questions. So your “result” table becomes 2 tables – “Room Inspections” and “Inspection Results”.

Room Inspections - ID, Operator Name, Date, Floor, Room Number
Inspection Results - ID, Room Inspection, Question, Answer, Note

For inspection entry, there are many ways to implement the inspection entry depending on YOUR prefered process.

Assuming that the “Operator” is entering the Room info AND Inspecting at the same time, I would Add a Room Inspection row and when Save is tapped, attach actions to the Form Save that will:

  1. Copy the Questions into the Inspection Results table for THIS Room Inspection
  2. Navigate to a Table View that is in QuickEdit mode. This view shows the List of ALL questions with the ability to answer each question AND enter a Note.

If you wish for Room Inspections to be entered previously and an Operator then SELECTS a Room Inspection to perform. I would in this case, have an “Inspect” button somewhere - maybe show Room Inspections in a Deck View with this button. When the “Inspect” button is tapped, it performs the actions noted above - 1) and 2),

Circling back to the structure…

I know it seems that you only need a static list of questions now. But you will likely find in time that you DO need different set of questions for different types of rooms/situations.

For example, if a room has two beds versus a single bed, you may may want questions tailored to those specific rooms. Or if a room is a suite with kitchenette versus a studio, Or if a room is Pet friendly versus one that is not. This is where the Template approach will be extremely useful. You can create a Template for each type of room.

Not only can you tailor the questions to each room, but you can modify the list of questions to each room type independent of the others.

I hope this helps!

3

Hi Willow

Thanks for your helpful explanation, I really appreciated, it gave me bright lights, I just give a try but maybe my knowledge is not enough to doing exactly what you said.

to make it more clear, is there’s a ref between :

Room Inspections - ID, Operator Name, Date, Floor, Room Number
Inspection Results - ID, Room Inspection, Question, Answer, Note

how to do the step no 1? bulk copy? how the copied list of questions recognize the Room Inspections? and how to navigate to the list of questions of QuickEdit mode that related to step no 1

thank you