Help

Re: A simple clocking in and out interface

4992 1
cancel
Showing results for 
Search instead for 
Did you mean: 
JonathanB
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi everyone

Here's a simple base with an interface that can be used for employees/visitors to clock in and out of a location:

https://amazingairtable.gumroad.com/l/lvcyc 

The interface could be on display on tablet from which people select their name and click when they arrive/leave.  Also allows people to clock in and out for the breaks if leaving the site on the same day.  All you need to do is pre-populate the list of people who will be on site each day. 

11 Replies 11
oldspool
4 - Data Explorer
4 - Data Explorer

Hello @JonathanB ! I found your interface/template while searching for a simple employee time tracking solution that I could use but I think I'm missing something now that I've bought/copied your template onto my base: there are no automations and I'm not quite savvy enough to figure out how you configured everything. Any chance I could get a little clarity on making it work? 

Sure, happy to help. 

All you need to do is:

  1. Use the People table to list the names of your employees.  One record per person.JonathanB_0-1686292819237.png
  2. Use the In/Out table to add the date each person is on duty.  Each day they are on duty will need a new record, e.g.
    JonathanB_1-1686292981602.png

     

  3. Your interface will then list only the people who are on duty that day, for them to select their name to clock in/out, e.g. for 09/06/2023 only Paul, George and Ringo will show on the list:JonathanB_2-1686293170021.png

     

    ...and then the next day it will show John, Paul and George.

You could also set up an automation each day to populate the list for you automatically , or even have set people on set days each week, in advance.  I can help with that too if you like?

 

 

 

Fantastic! Thank you, I have all of that set up now. 

Would you mind sharing the automations you set up for the clock in/ clock out buttons on the interface? I appreciate the offer of help, if I can't get those automations working as they should I will absolutely reach back out. 

JonathanB
8 - Airtable Astronomer
8 - Airtable Astronomer

They should already be set up to work so that if someone clicks "In", it populates the current time in "Time in 1" if this field is empty, otherwise it fills in the time now in "Time in 2".  Same logic for "Out".

JonathanB_0-1686568523586.png

 

JonathanB_1-1686568556749.png

 

Hi again! 

I wanted to circle back and let you know that with your assistance (thanks for the screen shots!) I was able to get the template and interface working perfectly for our new time clock- just in time for a bunch of new employees to start this Summer. 

 

Your help and time is much appreciated! 

JonathanB
8 - Airtable Astronomer
8 - Airtable Astronomer

Really happy to hear this.  Good luck!

If you're interested, I just released another simple work application: this one's a meeting room booking system.

ijduncan
5 - Automation Enthusiast
5 - Automation Enthusiast

I also purchased it. The automations do not copy over and need to be re created.

Thanks for pointing this out.  I will look at updating it and/or adding instructions to the interface itself 🙂

ijduncan
5 - Automation Enthusiast
5 - Automation Enthusiast

I followed your screenshots also.  Its great thanks!