# CALENDAR and EXCEL SHEET AIRTABLE

**URL:** <https://community.glideapps.com/t/calendar-and-excel-sheet-airtable/73764>\
**Category:** Ask for Help\
**Created:** [May 30, 2024, 9:46pm UTC](https://community.glideapps.com/t/calendar-and-excel-sheet-airtable/73764 "2024-05-30T21:46:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pharaon8](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pharaon8/32/75869_2.png) [@Pharaon8](https://community.glideapps.com/u/Pharaon8)\
**Post date:** [May 30, 2024, 9:46pm UTC](https://community.glideapps.com/t/calendar-and-excel-sheet-airtable/73764/1 "2024-05-30T21:46:15Z")

</div>

Hi,

I’m a new Glide user and I have a couple of questions regarding the possibilites.

I work with a basic excel sheet to organize a weekly planning for a team of 15 persons. It works very well as it is and everyone knows what they should do and when as long as I print out this planning and display it to them.

I want to upgrade the method and give an app access to them.

Using the calendar features of a glide app and and importing my sheet on airtable, i want to create a tab with a list of all my team members where we can click on each of their profile (This I know how to do) but I would like to implement a calendar as component (this is ok too) and in this calendar, I would like that the data from my excel sheet be automatically added to the right dates and when the employee goes on his profile he sees that, for example :

- on June 1st, he will be on “DUTY”,
- on June 2nd he sees that he will be “OFF”
- on June 3rd he will be on “RESTAURANT DUTY” and on and on…

Everytime I will update the date on the excel sheet imported in airtable, the calendar should update the data for the right dates and right person.

Of course, this calendar should be unique to each staff member in their own page.

Do you think this is feasable ?

Thank you for your help 🙂

---

<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 31, 2024, 12:45am UTC](https://community.glideapps.com/t/calendar-and-excel-sheet-airtable/73764/2 "2024-05-31T00:45:04Z")

</div>

That should be feasible. As long as your Airtable data contains something like this:

| Date | User ID | Notes |
| --- | --- | --- |
| June 1st, 2024 | ID001 | DUTY |
| June 2nd, 2024 | ID001 | OFF |
| June 3rd, 2024 | ID001 | RESTAURANT DUTY |

Then, in Glide, create a relation using the user ID, make it a multiple match and use it for your calendar.

---

<div class="post-metadata">

**Author:** ![Pharaon8](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pharaon8/32/75869_2.png) [@Pharaon8](https://community.glideapps.com/u/Pharaon8)\
**Post date:** [May 31, 2024, 12:38pm UTC](https://community.glideapps.com/t/calendar-and-excel-sheet-airtable/73764/3 "2024-05-31T12:38:02Z")

</div>

Hi,

Thanks for taking the time to answer.

Could you elaborate a little more on the multiple match and the connection it will have with the calendar as I don’t see where the feature is, please ?

---

<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 31, 2024, 12:41pm UTC](https://community.glideapps.com/t/calendar-and-excel-sheet-airtable/73764/4 "2024-05-31T12:41:51Z")

</div>

You can check this.

> **[Relations | Glide Docs](https://www.glideapps.com/docs/relations)**
>
> Create relationships and link rows together.