Hello everyone - first post here for me.
I have an order table, that has 3 columns (step 1, step 2, step 2). The steps are linked to another inventory table, so everytime I create a new order, the 3 steps are automatically filled.
I would like to create 3 records in the task table, one for each step. My initial thought was to use zapier, but 1) it seems zapier only does sequential zaps, and 2) it takes the ID of the cell, since it’s linked to another one.
in a nutshell, product one is created with 3 steps (eat, pray, love). I would like it to create 3 records in the task table, where the value in action is eat, pray and love.
Any suggestion, hint, option, alternative,… would be very welcome. I am wondering what’s the best way to do it.