I had posted this in MPU, but because it’s also faith-based, maybe it fits better here.
Each year during Lent in our Diocese, I have an annual task that I manage. 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 better way to do this? Anything that’s visually nicer? I thought about AirTable, but was trying to figure out how easy that would be to distribute for people to view.
Or just keep it simple with a PDF ?