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:
- Services
- Songs
- Sermons
- Readings
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…
- Song
- Song
- Reading
- Song
- Sermon
- Song
- Reading
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!