# Need Junction Table Help

**URL:** <https://community.glideapps.com/t/need-junction-table-help/79716>\
**Category:** Ask for Help\
**Created:** [February 1, 2025, 3:50pm UTC](https://community.glideapps.com/t/need-junction-table-help/79716 "2025-02-01T15:50:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Get\_Known](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/get_known/32/80823_2.png) [@Get\_Known](https://community.glideapps.com/u/Get_Known)\
**Post date:** [February 1, 2025, 3:50pm UTC](https://community.glideapps.com/t/need-junction-table-help/79716/1 "2025-02-01T15:50:39Z")

</div>

Made a quick [LOOM](https://www.loom.com/share/bc4061fa3441463cad9a4bdd75f4b42f?sid=48ac58d9-49a4-4516-87e7-cfc223ce3cb6) video to illustrated what I’m asking.

 ![Screenshot 2025-02-01 at 7.50.00 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/296e848e68593fd6f7a55db725125d7be76fbe2a.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 1, 2025, 3:59pm UTC](https://community.glideapps.com/t/need-junction-table-help/79716/2 "2025-02-01T15:59:53Z")

</div>

I would definitely recommend the first option - one row per city, per date.

If you go the second option then apart from violating database normalisation rules, you’ll have a maintenance nightmare.

Question: How important is it to present everything in a table as per your “Workspace” view?

A very simple way to display the data would be in a collection, and group by city.

If you really want that table view, then it gets a bit complicated, because the number of columns needs to be dynamic. Not impossible, but would probably require some advanced techniques involving a helper table.

---

<div class="post-metadata">

**Author:** ![Get\_Known](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/get_known/32/80823_2.png) [@Get\_Known](https://community.glideapps.com/u/Get_Known)\
**Post date:** [February 1, 2025, 9:52pm UTC](https://community.glideapps.com/t/need-junction-table-help/79716/3 "2025-02-01T21:52:16Z")

</div>

Thank you so much for the feedback and advise. I’ll do the first option then.

One more question tho. I’m assuming I use a workspace LOOP to create the junction table right? I’ve never done a loop action before, and wondering if you could point me to an example of how it’s done.

---

<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:** [February 2, 2025, 1:08am UTC](https://community.glideapps.com/t/need-junction-table-help/79716/4 "2025-02-02T01:08:18Z")

</div>

Recording a video for this.

---

<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:** [February 2, 2025, 1:17am UTC](https://community.glideapps.com/t/need-junction-table-help/79716/5 "2025-02-02T01:17:52Z")

</div>

@Get_Known Here’s a video.

> **[Thinh's Demo - Looping with Workflows](https://docs.lowcode.agency/recordings/cJickiejOeRhDDAttsGE)**