# Logging Hours + User Specific Columns

**URL:** <https://community.glideapps.com/t/logging-hours-user-specific-columns/29598>\
**Category:** Ask for Help\
**Created:** [July 27, 2021, 7:51am UTC](https://community.glideapps.com/t/logging-hours-user-specific-columns/29598 "2021-07-27T07:51:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tasina\_Westberg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tasina_westberg/32/29533_2.png) [@Tasina\_Westberg](https://community.glideapps.com/u/Tasina_Westberg)\
**Post date:** [July 27, 2021, 7:51am UTC](https://community.glideapps.com/t/logging-hours-user-specific-columns/29598/1 "2021-07-27T07:51:09Z")

</div>

Hello,  
I am currently working for Minite, a startup tech platform that connects student freelancers with young companies looking for talent to help them grow. We’ve been working on building an app where our students can log their weekly work hours, so that they can be sent to the company for which they are working at the end of every 4-week period.  
In order to do this, I am working with user-specific columns, however I am having difficulty getting them to appear on my phone.  
How can I test whether or not the user-specific columns are working? Also, how can I make the information entered by those users (the students) available to a select number of other users (their client a.k.a the company they are working for)?  
Final question, is there a mathematical formula I can employ to sum up all the hours worked in the period given (this would be for the data entered in the user-specific columns)?  
Thank you,  
Tasina Emma Westberg

---

<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:** [July 27, 2021, 9:46am UTC](https://community.glideapps.com/t/logging-hours-user-specific-columns/29598/2 "2021-07-27T09:46:00Z")

</div>

Hi Tasina,

Based on what you said, if you want a log of working hours to be visible not only to the signed-in user but also to other users, you would need an additional sheet to use as a log.

The structure would be something like: Email/Working hour/Week Code/Company/Notes etc.

If you want to sum all the hours in a given period, you would first need to define how that period relates to your data (i.e week is greater than X and less than Y), then create a relation and use a rollup (sum) on that relation.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 27, 2021, 10:22am UTC](https://community.glideapps.com/t/logging-hours-user-specific-columns/29598/3 "2021-07-27T10:22:43Z")

</div>

Check out this template as it may be a good starting point for you!

> **[Daily Time Sheet (Glide Tables version) app template • Glide](https://www.glideapps.com/templates/daily-time-sheet-glide-tables-version-dl)**
>
> Note: Instructions for the template are found in the menu of the app (left-side hamburger menu).
> 
> Submit daily hours for approval by a Manager. Logic within the app prevents duplication of hours and provides the ability to submit current or late time...