Room reservation application (help)

Hello

I am making a meeting room reservation app, but my question is how to make it so that another user cannot reserve the meeting room when it is already reserved, any idea.

Hi,

I am thinking at something like:

Status column (vacant/booked)
BookedBy column

Book action as group of 2 actions
1.set status to booked
2.set bookedby to useremail
Condition bookedby=blank

Vacant action as group of 2 actions
1.set status to vacant
2.set booked by to blank
Condition that useremail()=bookedby

Hope it helps!

1 Like