# Calendar: Multiple data sources feeding to one calendar

**URL:** https://community.glideapps.com/t/calendar-multiple-data-sources-feeding-to-one-calendar/54849
**Category:** Ask for Help
**Created:** [November 24, 2022, 12:23pm UTC](https://community.glideapps.com/t/calendar-multiple-data-sources-feeding-to-one-calendar/54849 "2022-11-24T12:23:54Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [November 25, 2022, 12:43am UTC](https://community.glideapps.com/t/calendar-multiple-data-sources-feeding-to-one-calendar/54849/2 "2022-11-25T00:43:52Z")

</div>

Hi Nathan 👋 Here is how I would do it. I’ll would first bring my two date columns into the same table, I’ll assume you have done that. Now you need to merge/collate these two columns: one list of dates below the other and we need values (not arrays).

You can use the screenshot below to follow along:

- RowID column
- RowIDsArray column: Do a lookup on the RowID column.
- RowIDIndex column: Do a “Find element index” on the RowIDsArray column.
- We already have our two basic date columns: Dates1, Dates2
- Dates1Array: Do a lookup on the Dates1 column.
- Dates2Array: Do a lookup on the Dates2 column.
- Now let’s merge Dates1Array and Dates2Array: use the “Make array” computed column (the /Array/Append array computed column would work too).
- We now have merged/collated our dates into an array. Each row of Dates1+2Array column is exactly the same. Now let’s transpose this array vertically into values.
- Dates1+2Array-\>List column. Use a single value computed column: get “from start”, row “RowIDIndex”, from “Dates1+2Array”. This will take the 1st element (index 0), then 2nd element (index 1) and so on of the elements in the array and turn them into a value.
- Note: If Dates1 has m dates and Dates2 n dates, we will need m+n rows in our table to make this work.
- Apply the calendar collection to the Dates1+2Array-\>List column.

**Data editor**

 ![Screenshot 2022-11-25 at 01.37.20](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/9/49ba45df9d0e8dff0254785b301f3b7f5ab03b23.png)

**Layout**

 ![Screenshot 2022-11-25 at 01.39.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/4/5471af011024851b83e21afd474cbecd63cf8d6c.png)

**Display monthly/weekly view**

I don’t know about Apps, but on Pages the responsive mobile version allows the user to toggle nicely between the daily, monthly and weekly views.

 ![Screenshot 2022-11-25 at 01.47.32](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b662432b9dcac73a44b0fd677f8d918fdb883cb5.png)

---

_[View the full topic](https://community.glideapps.com/t/calendar-multiple-data-sources-feeding-to-one-calendar/54849)._