# Set up table / Count for workers attendance

**URL:** <https://community.glideapps.com/t/set-up-table-count-for-workers-attendance/72151>\
**Category:** Ask for Help\
**Created:** [March 29, 2024, 4:22am UTC](https://community.glideapps.com/t/set-up-table-count-for-workers-attendance/72151 "2024-03-29T04:22:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [March 29, 2024, 4:22am UTC](https://community.glideapps.com/t/set-up-table-count-for-workers-attendance/72151/1 "2024-03-29T04:22:34Z")

</div>

I would like to make Worker Salary section which calculate twice a month ( Every 2 weeks )

1. Salary calculation based on my worker database which consist of one’s wage rate (per day) and OT rate (per day ) , this part everything going well when I link them by worker name
2. I will make a form and let my worker to submit workers attendance every 8 pm (Full attendance (8 hrs + 3 OT) , Full day no OT ( 8 hrs ) or in case they absence )
3. I want to count the total attendance of each worker , (First Monday of that month to second Saturday , I work 6 days a week )
4. The table auto calculate from Worker wage database with total count attendance of 2 weeks ( 2 times a month)
5. Please help me to set up table and how to count 2-week attendance , thank you

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 29, 2024, 2:42pm UTC](https://community.glideapps.com/t/set-up-table-count-for-workers-attendance/72151/2 "2024-03-29T14:42:00Z")

</div>

> [@atiwat\_tangchaiwatta](#):
>
> when I link them by worker name

You should link them by a rowID or anything that’s unique. I don’t think names would guarantee to be unique.

Regarding your data structure, would there be any cases that a worker doesn’t work the full day, or doesn’t work the full 3 OT hours?

---

<div class="post-metadata">

**Author:** ![atiwat\_tangchaiwatta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/atiwat_tangchaiwatta/32/22191_2.png) [@atiwat\_tangchaiwatta](https://community.glideapps.com/u/atiwat_tangchaiwatta)\
**Post date:** [March 29, 2024, 5:08pm UTC](https://community.glideapps.com/t/set-up-table-count-for-workers-attendance/72151/3 "2024-03-29T17:08:43Z")

</div>

Yes , sometimes but rarely occur

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 29, 2024, 11:07pm UTC](https://community.glideapps.com/t/set-up-table-count-for-workers-attendance/72151/4 "2024-03-29T23:07:42Z")

</div>

So wouldn’t it be better to cover those cases if people have the chance to enter the “normal” hours that they work daily, and the “OT” hours, for every entry?