# User Profile in a Timesheet App

**URL:** <https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584>\
**Category:** Ask for Help\
**Created:** [August 5, 2020, 4:17am UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584 "2020-08-05T04:17:34Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\
**Post date:** [August 5, 2020, 4:17am UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584/1 "2020-08-05T04:17:34Z")

</div>

I’m building a timesheet app. The projects show as a choice component. But I’d like to have the choice be dynamic and dependent on the user logged in. So for e.g. if user A is assigned to Project 1,2,3 and user B is assigned to Project 1 then the choice component should show 1,2,3 when signed in user is A and only show project 1 when signed in user is B. How do I do this with user profile setup?

Thankyou very much

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 5, 2020, 4:27am UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584/2 "2020-08-05T04:27:52Z")

</div>

Create a relation to link the user email to the email in the project sheet. Then set the relation as the source for the choices.

---

<div class="post-metadata">

**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\
**Post date:** [August 5, 2020, 5:20am UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584/3 "2020-08-05T05:20:28Z")

</div>

I’ve done that. But the relation doesn’t show up as an option in the dropdown where I can select the sources for the choice component. Seemed rather odd unless its tripping because the relation is sitting in a wrong sheet.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 5, 2020, 5:28am UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584/4 "2020-08-05T05:28:21Z")

</div>

Is it a multiple relation?

Otherwise I would create a template column with the user profile email address on whichever sheet you are using for your tab. Then use that column for a relation to use for the choice component.

---

<div class="post-metadata">

**Author:** ![Food2Soil](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/food2soil/32/659_2.png) [@Food2Soil](https://community.glideapps.com/u/Food2Soil)\
**Post date:** [August 5, 2020, 5:30am UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584/5 "2020-08-05T05:30:49Z")

</div>

it is a multiple relation. there are several individuals assigned to a project.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 8, 2020, 9:54pm UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584/6 "2020-08-08T21:54:53Z")

</div>

Can you show any screenshots of your relation settings and what shows for the choice component sheet sources?

---

<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:** [August 8, 2020, 11:10pm UTC](https://community.glideapps.com/t/user-profile-in-a-timesheet-app/13584/7 "2020-08-08T23:10:28Z")

</div>

Check out this template — [https://www.glideapps.com/templates/2B8UAHpyanKi1oxxOHD1-template](https://www.glideapps.com/templates/2B8UAHpyanKi1oxxOHD1-template)

It’s what I call the “basic” version, but I built another advanced version with support for multiple positions and multiple departments (for my organization, a doctor could work in multiple departments, so I needed the ability for several choice components). Each choice is then used to check for previous submissions of the same job+department combination and prevents the user from submitting a time sheet for the same pay period twice for the same job+dept combo.

The time sheet itself only shows the user jobs and departments they’ve added to their profile.

If you’re interested, send me a PM and we can discuss further. The advanced version isn’t in the template store because the highest available price choice is $99 and I felt the work that went into the advanced app was worth more so I haven’t submitted it as a template (yet).

I also spoke a bit about how I did this in my app here: [🙋‍♀️ User Profile columns in conditions and columns](https://community.glideapps.com/t/user-profile-columns-in-conditions-and-columns/8093/54)
