Similar topic: Besides Automations, is there a way to compose the data submitted through a flat form into structured (multi-table) rows?
The above is based on an approach of presenting a form (either an actual form which when submitted creates a row, or some Detail view of a table) to the user to ingest all the necessary data into a row in some intermediate table. Then another step (such as a button or an automation) would pull the created row from the intermediate table, and use the data to create the appropriate rows in other tables (and optionally delete the intermediate row).