Glide App to query device calendar for availability

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.

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?

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

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.