Hi everyone and happy new year. Its been sometime since i havent posted, but here I am back.
Im working now on a cleaning app for a hotel. The idea is that the maids get a UX view (let´s call it “Day Tasks”)that shows only those rooms that were occupied, and when clicked they can mark if the room was cleaned or not.
I have a main “Reservations” table that is updated automatically with Zapier from the hotel Reservation System which is where the information should pulled from for the “Daily Tasks”.
I need to create some kind of Reference or LOOKUP formula to get the updated daily info into the “Daily Tasks” table.
Any ideas for this?
All I´ve tried hasnt really worked.
The only thing that did was to create a Google sheets table preloaded with all dates in the year, one for each room.
Then, I created a slice so that it only shows today´s reservations. but of course Reservations change, I get new ones and also cancellations so I need someway to autoupdate this.
So I created an action (set the values of some columns in this row with a SELECT formula)to update this manually, although this is not ideal, as the maid has to select in the table the rooms to update and then run the action every morning.
I tried using a workflow triggered by updates to the Reservation table by this obviouly doesnt work since the updates are generated by zapier and not by the app itself.
I also tried using a SELECT() formula for the needed columns but this only works when a new row is created inside the app, not outside by Zapier.
Any ideas on how to automate this will be greatly appreciated!