# Sync from 2 event sources

**URL:** <https://community.glideapps.com/t/sync-from-2-event-sources/40048>\
**Category:** Ask for Help\
**Created:** [March 24, 2022, 7:53pm UTC](https://community.glideapps.com/t/sync-from-2-event-sources/40048 "2022-03-24T19:53:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GK123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gk123/32/40613_2.png) [@GK123](https://community.glideapps.com/u/GK123)\
**Post date:** [March 24, 2022, 7:53pm UTC](https://community.glideapps.com/t/sync-from-2-event-sources/40048/1 "2022-03-24T19:53:57Z")

</div>

I have two sources of events that I want to see in my app schedule.  
1)google sheet  
2)events that are created from the app.

They don’t have exactly the same stretcher, but I want to see them inside my app.  
Because of some other issues, I can’t save them in the same source (like in the same google sheet).  
I was thinking of saving the events that I create inside my app - in one table (with all the data that I need), and creating another table that gets the events from the google sheet **and** the table.

Unfortunately, I didn’t find a way to make it happen yet.  
I am looking for some ideas on how to see events from 2 different sources.

---

<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:** [March 25, 2022, 1:18am UTC](https://community.glideapps.com/t/sync-from-2-event-sources/40048/2 "2022-03-25T01:18:51Z")

</div>

> [@GK123](#):
>
> 2)events that are created from the app.

So these events are written to the Sheet as well?

I think you can create a master sheet or master Glide Table, saving the rowIDs and all other related info (that is needed to display on the main screen) of those events.

Then, use 2 relations to try to match those rowIDs with the 2 tables.

If relation 1 is not empty then show detail screen of table 1, else show detail screen of table 2.

---

<div class="post-metadata">

**Author:** ![GK123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gk123/32/40613_2.png) [@GK123](https://community.glideapps.com/u/GK123)\
**Post date:** [March 25, 2022, 5:47am UTC](https://community.glideapps.com/t/sync-from-2-event-sources/40048/3 "2022-03-25T05:47:46Z")

</div>

Hi.  
No, the events are not written to the Google sheet.  
So I have two “databases” of events.  
Can you please explain again how to create the “master glide table”?

For example, each event must have start time, end time, title and description ( for some events I have more columns).

How can I create the master sheet that will collect all the events from both tables?

---

<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:** [March 26, 2022, 12:04am UTC](https://community.glideapps.com/t/sync-from-2-event-sources/40048/4 "2022-03-26T00:04:21Z")

</div>

I would take this tip from @Darren_Murphy to build a dynamic table, but you have to generate rows in advance for this to work.

[https://cdn.loom.com/sessions/transcoded/029239350a9740e5b0cbe1ce40b7841f.mp4?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4ubG9vbS5jb20vc2Vzc2lvbnMvdHJhbnNjb2RlZC8wMjkyMzkzNTBhOTc0MGU1YjBjYmUxY2U0MGI3ODQxZi5tcDQiLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE5NjM3NTI1MzN9fX1dfQ\_\_&Key-Pair-Id=APKAJQIC5BGSW7XXK7FQ&Signature=e128gA5rMGSh5tRErcFLv9-F-zxtHHhe2j5LBMk6PXHXp3DAERlGoxFCiaSZMQBEIvl6nKkmgPI9YMjfkt0u6LPP2JIcfjaa7De5MCleJiBMBPXMzy1l4CSFOtAAo1Tn1l6r0BPWxjn4MZcAiSWDIMvq83JVuK6X5xswQby1yhUP69gCtnmVlGMp9yocl~qi~tqWMWpyC~jtdVKJYLYdYg2hQxYRyYY4jyCjzWhrIx2v24LKMzHr8J2qLJdCg1QGBgLojpenhO5SfvK7W1M0WsNqpMlYSE-VsLRg5SHC7MfBENILNyhUPj2GrHF5VLMAvSytPwlu3J1CyAYFlALIWQ\_\_](https://cdn.loom.com/sessions/transcoded/029239350a9740e5b0cbe1ce40b7841f.mp4?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9jZG4ubG9vbS5jb20vc2Vzc2lvbnMvdHJhbnNjb2RlZC8wMjkyMzkzNTBhOTc0MGU1YjBjYmUxY2U0MGI3ODQxZi5tcDQiLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE5NjM3NTI1MzN9fX1dfQ __&Key-Pair-Id=APKAJQIC5BGSW7XXK7FQ&Signature=e128gA5rMGSh5tRErcFLv9-F-zxtHHhe2j5LBMk6PXHXp3DAERlGoxFCiaSZMQBEIvl6nKkmgPI9YMjfkt0u6LPP2JIcfjaa7De5MCleJiBMBPXMzy1l4CSFOtAAo1Tn1l6r0BPWxjn4MZcAiSWDIMvq83JVuK6X5xswQby1yhUP69gCtnmVlGMp9yocl~qi~tqWMWpyC~jtdVKJYLYdYg2hQxYRyYY4jyCjzWhrIx2v24LKMzHr8J2qLJdCg1QGBgLojpenhO5SfvK7W1M0WsNqpMlYSE-VsLRg5SHC7MfBENILNyhUPj2GrHF5VLMAvSytPwlu3J1CyAYFlALIWQ__ )