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.
- Look at the persons work and personal calendar for availability
- IF available add this person to the list of available
- IF not available, ask the person if they want to be added to the list of available
- 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.