Hi Owen I’d love to help you out with this… happy to email on email@example.com or Skype if you prefer? Looking forward to fearing further about the project but it does sound feasible as you say.
I’m Freelance Front-end developer and i’m selling consultant service and assistance about airtable here on fiverr : https:http://bit.ly/i-will-be-your-airtable-consultant-For-Setting-Up-Database-Forms-And-Workflows
I can help you with this complicated workflow using the airtable API.
If you require any further information, please do not hesitate to contact me on fiverr or by email : firstname.lastname@example.org