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.
Wednesday 9am-12pm and 4-6pm
Thursday 11am-2pm and 4pm-7pm
Is there a way to make this easier to input and then share/output to people?.