Looking for some guidance on whether this is possible before I dive in so happy to read the docs / info etc but unsure where to look at the moment.
Below is a rough idea of the data structure with the colours that represent the joins. My goal is to have a checklist type page depending on whether its a yes / no in the complete section.
I have got everything to populate and can get the data for the owners and products but is it possible to create multiple data rows when a new product is added?
Ie if someone created ‘banana’ from a product input form than I would like 2 new rows in the checklist database (same as apple but banana and both saying no in the complete column). Currently I can only get it to make one line…