So I have a checklist app for cleaning a house
The user can create a default checklist, add rooms to it, and add tasks to a room
There is a table that holds checklists.
Another holds rooms that are connected to the checklists
And another that holds tasks that are connected to rooms.
Here is my data for the checklist. Notice it has a name, as well as a list of rooms that are in it.
Here is my data for eachrooms. Notice a room is associated with a checklist, and also has a list of tasks for the room.
Finally, the task list. It is also associated with a room and a checklist.
So here is the problem.
I can’t figure out how to duplicate a checklist and have the rooms and tasks duplicate as well, while having similar associations.
Here’s my workflow to duplicate a checklist AND rooms. But I can’t figure out how to duplicate the tasks to associate with the rooms and checklist.
The way this works is I create a new checklist. Then I copy the rooms that are associated with the checklist. Then I change the “Checklist” column in each room to the checklist that was created in step 1. Then I change the column in the checklist data type to store the newly created rooms.
It’s messy, but it works. However, I can’t figure out how to go one step deeper as this flow just does not work.
Maybe an API workflow?