My country (Italy) requires for companies to monitor visitors. Most of them are actually using a simple book where the visitor annote the date/time entrance, mobile phone, address and put a sign; this for when he enters and when he exits.
I would like to develp an App with AppSheet where a tablet is placed at the frontdesk, the visitor (but it could be also the employee), click on some button, fill in personal data (or it shows some barcode), put a signature and that’s it.
I’ve two simple dables: access and visitors.
A form-view visitor asks for barcode or name and let the visitor fill his data.
How to create a workflow/action that write on the access table?
I’m also using a flag (logged in yes/false) on the visitors table to monitor who is logged in (counting visitors).
Another problem is how, when a visitor exit, app sheet can check in the access table the row of the first access and update that record putting the logout time?
I know appsheet is nocode but it still requires “coding mentality” :))
Thank you for all suggestions.
Of course if you’ve a better idea to implement this let me know.
Appsheet is a very great product!