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.
Anybody got any ideas for this problem? I’ve been mulling it over in my mind for the past few days, still can’t come up with any better solution than an “order” field on the Services table that is a JSON array of objects with the “type” and “id” of every element. Like this:
That would give me what I want to programmatically (used to automatically create visual media and set lists for the worship team), but right now I’m stuck creating it manually outside of the Airtable UI, which I’d rather not do if there’s another way around it.