# Form to Check IN & Check OUT
**URL:** https://community.glideapps.com/t/form-to-check-in-check-out/59021
**Category:** Ask for Help
**Created:** [March 11, 2023, 6:44am UTC](https://community.glideapps.com/t/form-to-check-in-check-out/59021 "2023-03-11T06:44:45Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Ismael](https://community.glideapps.com/u/Ismael)
#### Post date: [March 11, 2023, 6:44am UTC](https://community.glideapps.com/t/form-to-check-in-check-out/59021/1 "2023-03-11T06:44:46Z")
Good morning!
Im trying to do a form to check IN my employees and do a check out and i have some troubles.
1- Can i turn the location ON automatically?
2- When a employee Check IN, how can i remove the Check IN forms to evade make 2 Check IN nad show the Check OUT form?
3- When Check OUT resets to next day.
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 12, 2023, 12:41am UTC](https://community.glideapps.com/t/form-to-check-in-check-out/59021/2 "2023-03-12T00:41:07Z")
> [@Ismael](#):
>
> Can i turn the location ON automatically?
At the moment there’s no special variable that collects a user’s location, they have to give their consent through that component every time.
> [@Ismael](#):
>
> When a employee Check IN, how can i remove the Check IN forms to evade make 2 Check IN nad show the Check OUT form?
Assuming you do it everyday, then you can do it like this:
- Create a “today” Math column in your user profiles table, with the formula being:
YEAR(N)\*10000 +MONTH(N)\*100 + DAY(N)
With N being the “now” value. You should get something like 20231203.
- Create a template column to join the user’s rowID/email with the value above. You should get something like “[a@example.com](mailto:a@example.com) - 20231203”.
- When recording the check in form, make sure you record the “current timestamp” to a column, and the user’s rowID/email in another column.
- In the check in/out table, create a math column with the formula being:
YEAR(T)\*10000 +MONTH(T)\*100 + DAY(T)
With T being the timestamp you recorded when the user checks in.
- Create a template column joining the user’s rowID/email with the column above.
- Create a relation from the template column in the user’s table to the template column in the check in/out table.
- Create a lookup column in the user’s table, looking up the “check out” value.
Then, if the relation is empty, show the check in button.
If the relation is not empty and the check out value is empty, show the check out button.
The check out button should write the current timestamp value to the check out column in the check in/out table using the relation.
> [@Ismael](#):
>
> When Check OUT resets to next day.
At this point, with the setup above, no buttons should show until the next day.
---
### Author:  [@Ismael](https://community.glideapps.com/u/Ismael)
#### Post date: [March 13, 2023, 7:27am UTC](https://community.glideapps.com/t/form-to-check-in-check-out/59021/3 "2023-03-13T07:27:31Z")
Thanks a lot for the answer! it works perfectly!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 14, 2023, 7:27am UTC](https://community.glideapps.com/t/form-to-check-in-check-out/59021/4 "2023-03-14T07:27:45Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.