tl;dr: Newbie-me created a really dumb data structure and I need help consolidating 3 lists of things into 1 new list of things.
I’ll lead off by saying that this is embarrassing.
Back when I was first creating the MVP for my idea, I didn’t know much about data structure and whatnot, so I painted myself into the following tech-debt corner, which is getting in the way of other features I want to implement:
I have a service-based marketplace centered around painting plastic miniatures. It’s basically UpWork, but for painting miniatures in a specific gaming community. The jobs are structured using 3 things:
- availableJob - This is created when a user creates a new job for painters to bid on.
- openJob - When a client accepts a bid from a painter, this is created and the associated availableJob is deleted.
- completedJob - When a job is finished and paid for, the openJob is deleted and a completedJob is created.
Rather than having one thing that follows a commission from cradle to grave, I’ve got 3 things that are created and deleted based on what stage the job is in. This is having a negative impact on SEO (dead links to non-existent openJobs) and has put a damper on what other features I can implement. While the above worst-practice example of schema has been a fantastic learning experience in what not to do, it has officially gotten to the point where it is in the way.
I am now attempting to consolidate these three things into a single thing, commission, which will have a status field (available, active, or closed) indicating which stage the job is at, rather than have three separate things (like newbie-me created).
Between the three lists of things, I have a few hundred new commission things to create, but I can’t get my mind around how to create a tool to do this in one fell swoop. I basically want to create a for loop that creates a new commission (and populates certain fields) for each avialableJob, openJob, and completedJob.
I’m not sure how to tackle this on Bubble other than to create repeating groups of the 3 lists and put a make new commission button in each cell, then do them one-by-one (which sounds terrible).
Any assistance is greatly appreciated. Thanks!