# Glide App to query device calendar for availability **URL:** \ **Category:** Ask for Help\ **Tags:** data-sync, api, custom-code\ **Created:** [April 24, 2025, 8:08pm UTC](https://community.glideapps.com/t/glide-app-to-query-device-calendar-for-availability/81524 "2025-04-24T20:08:04Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![CineDiver](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cinediver/32/16501_2.png) [@CineDiver](https://community.glideapps.com/u/CineDiver)\ **Post date:** [April 24, 2025, 8:08pm UTC](https://community.glideapps.com/t/glide-app-to-query-device-calendar-for-availability/81524/1 "2025-04-24T20:08:04Z")
Hello, I have build a directory of BIPOC people working in camera department for film production. What I would love to do is have the app check for availability when some one enters dates for a production looking to hire folks. 1. Look at the persons work and personal calendar for availability 2. IF available add this person to the **list of available** 3. IF not available, ask the person if they want to be added to the **list of available** 4. Present **list of available** people into a sortable list for the job submitter I would great appreciate any and all help on this. My app has become a great tool to help with inclusion and has been self supported by myself. Thanks in advance. ---
**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:** [April 25, 2025, 12:04am UTC](https://community.glideapps.com/t/glide-app-to-query-device-calendar-for-availability/81524/2 "2025-04-25T00:04:06Z")
I would do it like this, with a big assumption that all the jobs are for a specific date only, and not a range of dates: - In your Users table, add a multiple relation to all jobs that person has taken. - In your Jobs table, add a math column calculating the numerical value of the date of the job: YEAR(D)\*10^4 + MONTH(D)\*10^2 + DAY(D) with D being the date of the job. - Back to the users table, use a lookup to get all numerical dates of the jobs the user has taken. - Add a helper table with only one row, which is where you will host your custom form. Add user-specific columns for job name, job description, job date etc. - Add a column to calculate the numerical value of the date, same formula as above. - In the Users table, add a single value column, take the first value of the numerical date from the helper table. - Now, add an if-then-else column, if the single value is included in the lookup list of numerical dates, then the user is booked for that date, else they’re free. - Display a list of users that are available for the job submitter to choose from. For the “ask the person if they want to be added” part, it gets a bit more complex. Do you ask them outside of the app? Or inside the app? ---
**Author:** ![CineDiver](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cinediver/32/16501_2.png) [@CineDiver](https://community.glideapps.com/u/CineDiver)\ **Post date:** [April 25, 2025, 1:52am UTC](https://community.glideapps.com/t/glide-app-to-query-device-calendar-for-availability/81524/3 "2025-04-25T01:52:20Z")
Hi Thinh, the job could be a day (Dayplayer) or a few days. You lost me for a minute, but it started making since to me as I read along. So if I am following you, I would rate availability based on their calendar events, 0 being available, 1 being possibly (ask) and 2 being not avail. How would I query their calendar app (Apple Calendar or Google Calendar)? How could date range be handled? Yes, ask ---
**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:** [April 25, 2025, 3:17am UTC](https://community.glideapps.com/t/glide-app-to-query-device-calendar-for-availability/81524/4 "2025-04-25T03:17:53Z")
I don’t think you would be able to build something that access their own calendars app, it should be something that is stored inside your tables.