Hi Kate, I think I might be able to help with this.
I've helped people work out specific issues with their workflows with Airtable's native functionality, and am pretty comfortable doing workarounds for whatever can't be handled natively. I can also build scripts for automations or script extensions as required
I'm pretty active on the forums so you can get a grasp of how I work from my activity
here, and I've got a bunch of example projects that you can find here
If you think I could help, here's a link
to schedule a free half hour call to see whether we'd be a good fit