# Combine / join tables

**URL:** <https://community.glideapps.com/t/combine-join-tables/73331>\
**Category:** Ask for Help\
**Created:** [May 13, 2024, 9:17pm UTC](https://community.glideapps.com/t/combine-join-tables/73331 "2024-05-13T21:17:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\
**Post date:** [May 13, 2024, 9:17pm UTC](https://community.glideapps.com/t/combine-join-tables/73331/1 "2024-05-13T21:17:38Z")

</div>

Hi  
I have two tables i’m looking to display as one. Both are calendar lists with dates; one is entered by users in the app, the other is imported from a google sheet which takes it from an HTML data source. I want to be able to show a calendar to users with both user entered and imported dates.

Possible approaches - but I cant do any of them!

1. Scheduled refresh of google data to glide table
2. SQL type ‘full join’ where users add to the glide table but the displayed data is combined
3. Show two lists…but this is terrible for the user who doesnt really care where the calendar entry came from

---

<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:** [May 13, 2024, 11:11pm UTC](https://community.glideapps.com/t/combine-join-tables/73331/2 "2024-05-13T23:11:34Z")

</div>

I would try to set up a scheduled automation to take rows from Google Sheets and add them to the Glide Table. Would save you some headache.

---

<div class="post-metadata">

**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\
**Post date:** [May 14, 2024, 6:03am UTC](https://community.glideapps.com/t/combine-join-tables/73331/3 "2024-05-14T06:03:48Z")

</div>

That makes sense. There is definitely some complexity with a table join. How would you do that? Make? Or does that option exist in glide?

---

<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:** [May 15, 2024, 1:18am UTC](https://community.glideapps.com/t/combine-join-tables/73331/4 "2024-05-15T01:18:21Z")

</div>

I would use Make. Fetch all rows, or search & filter by the condition you need, then push them to Glide Tables using the API.

---

<div class="post-metadata">

**Author:** ![fraser](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fraser/32/68111_2.png) [@fraser](https://community.glideapps.com/u/fraser)\
**Post date:** [May 15, 2024, 6:39am UTC](https://community.glideapps.com/t/combine-join-tables/73331/5 "2024-05-15T06:39:11Z")

</div>

Thanks. I’ll have a try

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 22, 2024, 6:39am UTC](https://community.glideapps.com/t/combine-join-tables/73331/6 "2024-05-22T06:39:15Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.