Visual Project Challenge? Calendar or Report?

Hey Everyone,

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.

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 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 ?

1 Like