# How do I make automatic time allocation?

**URL:** <https://community.glideapps.com/t/how-do-i-make-automatic-time-allocation/77928>\
**Category:** Ask for Help\
**Created:** [November 15, 2024, 9:27am UTC](https://community.glideapps.com/t/how-do-i-make-automatic-time-allocation/77928 "2024-11-15T09:27:07Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:** [November 17, 2024, 1:02am UTC](https://community.glideapps.com/t/how-do-i-make-automatic-time-allocation/77928/6 "2024-11-17T01:02:31Z")

</div>

I don’t have an immediate good way to do that. What I think you can do might look like this:

- Set the doctor’s ID to a field in User Profiles when a customer clicks on a doctor to view his details.
- Use a relation + lookup to retrieve the start and end admission times for that doctor.
- Use JavaScript to generate a comma delimited list of start and end internals for that doctor, based on the lookup above.
- Use this method to transpose them to a helper table and use that in a choice component.

> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)

---

_[View the full topic](https://community.glideapps.com/t/how-do-i-make-automatic-time-allocation/77928)._