I’m a pastor who uses Airtable to organize our church’s worship services. It’s become absolutely indispensable, an every day part of￼ my workflow.
Currently my Worship base has four tables:
The Services table has a one to one relationship with Sermons, and a many to many relationship with the rest.
Now in real life, every Service contains a mixture of these elements, in a particular order. For example…
What I need is the equivalent of a multiple linked record field￼, but one that would allows for different record types. Other than storing JSON in a plain text field, I haven’t been able to come up with a good solution for this problem.
Would much appreciate any ideas!