I am building an app that will have multiple repeatable jobs and sub-tasks, for example Planning a Wedding.
The template job and sub-tasks are created by the manager, and a customer can request a job.
When a job is requested, I need the current template and associated sub-tasks to be duplicated in the DB (same or new table) so that the unique job and sub-tasks can be worked/completed without impacting the template or other jobs. This will allow one-off modifications of the job/sub-tasks, as well as progress tracking at the job level.
I am unsure how to accomplish this using softr DB. I suspect the Ai Agent could help here, but I am looking for other options since the Ai Agent behavior could prove unpredictable in the future (like when they move to a different model) as well as the whole hallucinations bit.
I know Airtable has automations that could assist here, and moving my data there is an option but one I see as a last resort.
Only other option I can see is monitoring the DB via API or n8n and then setting up custom code to perform the DB record copies.
Looking for other options