I haven’t used Softr to do what you are doing (yet!) but having read this thread the other day, it might set you off in the right direction.
All the best for your project and developing your own skill set at the same time. I’ve loved that about Softr/Airtable myself.