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! Go to 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
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!
User | Count |
---|---|
18 | |
6 | |
6 | |
5 | |
3 |