Time Clock with access pin

I am looking to create a timeclock for our shop workers that they can clock in and out on. I was wondering if there was a way to make this available to where when they selected their name it required a pin number or password. Then the same for logging out.  Maybe this is not possible 

 

Solved Solved
0 4 191
1 ACCEPTED SOLUTION

I was thinking the same ,  the employee needs a code to be able to clock in or out
if this is it , i see it doable via valid_If for validating the code and show_if for the action buttons


First Create a code column in the employee directory table 
then use a valid_if statement to validate the code:
[Clocking_Code]=[Employee_ID].[Code]


Clock_In action can have a show_If expression such as 
[Clocking_Code]=[Employee_ID].[Code]


Clock_out Action Show_If expression such as :
AND([Clocking_Code]=[Employee_ID].[Code],isnotblank([Clock_In]))

This is only an example, all depends on your tables relations and UI

View solution in original post

4 REPLIES 4

so the clock in / click out button will only be available for the user if the code is correct for this particular user?

I believe he means that when pressing the action button, it asks the user name + the pin. That's doable with Valid_If.

I was thinking the same ,  the employee needs a code to be able to clock in or out
if this is it , i see it doable via valid_If for validating the code and show_if for the action buttons


First Create a code column in the employee directory table 
then use a valid_if statement to validate the code:
[Clocking_Code]=[Employee_ID].[Code]


Clock_In action can have a show_If expression such as 
[Clocking_Code]=[Employee_ID].[Code]


Clock_out Action Show_If expression such as :
AND([Clocking_Code]=[Employee_ID].[Code],isnotblank([Clock_In]))

This is only an example, all depends on your tables relations and UI

Thank you for the replies. I hadnt thought about it as the action button being the security. That might work. I will give it a try!

 

Top Labels in this Space