When the visitor first signs in and checks the "I accept terms ..." checkbox this will cause a trigger (see below) to send an arrival
email to their sponsor. When they sign out a similar email is generated. Hidden columns J and K manage the status of this.
To install this, make your own copy, edit the Staff List tab (which I normally keep hidden) and then - the tricky bit -
is to add in a "trigger" that will enable the emailing of the notifications during the OnEdit event
I have deployed this using Google Chrome's "kiosk" function which would look like this line in a batch file:
This project is provided at no cost but also with no warranty express or implied. All liability is the responsibility of whoever has copied and is deploying this sheet.
If you do find this useful, drop me a note - I'm curious.
What powers this?
This site is running on a Raspberry PI 3a and pulls images from a Wyze Pan Cam located in my front window. It's just a toy I've been playing with. If you are interested in knowing more, please feel to contact me firstname.lastname@example.org
"Now then, Pooh," said Christopher Robin, "where's your boat?"
"I ought to say," explained Pooh as they walked down to the shore of the island, "that it isn't just an ordinary sort of boat. Sometimes it's a Boat, and sometimes it's more of an Accident. It all depends."
"Depends on what?"
"On whether I'm on top of it or underneath it."
"Oh! Well, where is it?"
"There!" said Pooh, pointing proudly to The Floating Bear.