Hi everyone,
I’m building an app that allows us to manage jobs that we do in-hous and by subcontractors.
Work that’s done by subcontractors is sent to us as a bulk CSV at the end of each month.
I’ve built a datagrid and a workflow that allows me to download a CSV of outstanding jobs. Each job has as unique job_id in the relevant table in Supabase.
I’m looking for a solution that will allow me to insert/upsert the missing job data (delivered quantities, weights, etc) back into Supabase via WeWeb once it’s been validated and merged in the CSV file.
We can do it already via editable fields in the datagrid. But when you’re dealing with hundreds of jobs for each subcontractor, it’s going to be much more efficient to have some soft of bulk upload functionality.
Has anyone solved a similar problem or can point me in the right direction?