This seems more like SharePoint lists than Airtable. And SharePoint Lists are an absolute pain to work with using any typical structured data patterns.
I’ve run into many weird List workflows made by non developers to try to save money on developers and they just end up creating all these manual steps and wonky forms with horrible UX to do simple things like “add a document in a specific category.”
I wish they would make “cloud access” as it would be bette than all these half web, half excel macro spatchcock solutions.
I think the forms+workflow with data in the cloud is done well with airtable and also pretty close with appian, Salesforce and others.