Help

Re: Visitor management sytem sign out

1286 1
cancel
Showing results for 
Search instead for 
Did you mean: 
MARIO_RIVIERE
5 - Automation Enthusiast
5 - Automation Enthusiast

Hallo Airtable Experts,
I want to create a database for visitor registration. I started with the template visitor management system and i’m trying to set it up to sign out.
For example Steven Lodewijks come in on 7/11/2018 13:16 and leave the company on 7/11/2018 15:15.
Does anyone have an idea how to do that?
Afterwards it is then possible to calculate the present time.

Very open to ideas

3 Replies 3

It sounds like you can do this with the following fields:

  • {In}: A date field with time format enabled
  • {Out}: A date field with time format enabled
  • {Status}: A formula field with the formula being IF(AND({In},{Out}),"Signed Out",IF(AND({In},NOT({Out})),"Signed In",BLANK()))
  • {Time Present}: a formula field with the formula being IF({Out},DATETIME_DIFF({Out},{In},'seconds'),BLANK()) and using the “duration” format

Thank you, I really appreciate your help. I have always problems with the “IF AND” Formulas.

I make a table with :

  • Contact persons we name it “Personeel”

  • Main menu (see printscreen in annex) Here I make a form to registration Signed In

  • Table to write out I make also a form to Signed Out.

I note in the form to Signed Out that you see the full list and I would like to see only the people who’s signed In (see annex)
is that possible? I can not figure it out

Best Regards,

I wish you spend a great year ahead that starts with happiness and ends with that, too. Happy New Year!

MARIO RIVIERE
ZOUTMAN NV

Verzonden: zaterdag 22 december 2018 5:39

Bezoeker_ Main menu 28_12_2018 9_19_39.png

Bezoeker_ Main menu 28_12_2018 9_19_53.png

Bezoeker_ Main menu 28_12_2018 9_20_05.png

0c0dbb3799ab09bba5bc68296820918aa60448d6.png

89f42f9f01e8bea9079b4e2c9fe8a00de26b25ce.png

You can’t do this yet, but the feature is in beta.

Follow the link above to request access to the beta testing of the feature “Limit linked record & select field options in forms”