Calendar / Schedule - Multiple Locations

Hello Airtable users!

Newbie here to the community and beginning to dabble into Airtable as well.

Trying to do my 4th project in Airtable, the first 3 were simple directories and inventories. This one is a bit more complex and I am struggling.

This task that I do happens every year during Lent in our Diocese, I am trying to hopefully automate it from now on to some extent or at least make it visually easier.

My yearly task
I send out a Google Form to all the churches in the region (roughly 40) and ask for their service schedule during the time period of Great Lent. Everyone fills out the form, I generate a table that lists the churches and their equivalent Lenten service, convert to PDF, post online and distribute.

I thought about a dedicated calendar that people can subscribe, but it might be too cluttered. (Example, if all the 40 churches have the same service time on the same day, -which does happen) But again, think about it from those 40 churches are scattered from up to Fresno down to San Diego.

An example

Church A
Monday 9am-12pm
Wednesday 9am-12pm and 4-6pm
Friday 3pm-6pm

Church B
Monday 9am-12pm
Tuesday 10am-1pm
Thursday 11am-2pm and 4pm-7pm

Is there a way to make this easier to input and then share/output to people?.

Or just keep it simple with a PDF ?

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.