I am using Airtable to create an advanced social media calendar. It is used to manage 150 social media accounts - each account corresponds to a specific university.
A student submits a form with pictures and a caption that they would like to have posted on their schools account. When the form is submitted, a record is created in Airtable. All records for all schools go into the same Table and are tagged with the school on which the content should be posted via a linked record. There is a second table that has the list of all of the schools.
I would like to create a function or automation that assigns each record with a date and time to be posted. Each school instagram account can only post 5 records per day - for example one at 10am, one at 12pm, one at 2pm, one at 4pm, and one at 6pm. The function should be able to assign each record with the next available posting slot for that school. The posting times should also be determined per school, via the list of the schools in a separate table.
For example - assuming School 1 & 2 both use the posting times listed above - someone submits a post to School 1 at 9:30am, and another person submits a post to school 2 at 9:45am. Both posts are scheduled for 10am, since they are for different schools and there are no other posts scheduled before them. If instead of submitting to school 2, the 2nd person submits to school 1, the first post would be scheduled for 10am, and the second would be scheduled for 12pm.
Let me know if anyone has any ideas on how to achieve this!
