Hi,
I am working on a check in/ check out system for a local studio. I’ve hit a problem that I can’t find a solution for elsewhere.
The image below shows the problem. The second row should show a “ :white_check_mark: ” as the Last Check In is 1 minut...
Hey folks,
I’m trying to make a check in/ out system for a music venue/ studio so they can see which members of staff are on site at any given time. I’ve used two forms where staff can check in and out which populates a table. That side of things is ...
Thanks @Nathalie_Collins. Does that mean it wouldn’t be possible to have the current check in status show on the staff table? I’ve had a play with look up and rollup but so far no luck. Ideally I’d just have a Staff table view with all the staff memb...
Nathalie_Collins:
IF(IS_BEFORE({Time In}, TODAY()),“ :x: ”,IF(AND({Time In},{Time Out}),“ :x: ”,IF(AND({Time In},NOT({Time Out})),“ :white_check_mark: ”,BLANK())))
Brilliant, thank you!
I have another table called “staff” that is linked to the...
