Duplicate Row

CaraBart28

UPDATE: I figured it out :)

Hello!

Screenshot 2023-09-19 225728.png

I am trying to get a row to duplicate if one column meets certain criteria. So if the cuff size is listed as large we need to duplicate the row to let the vendor know there is an additional item to be ordered, which has a separate SKU and price, how would I go about doing this? If Cuff size is large, they would have a row for standard, as well as a row for large...see screenshot for reference, there should be two rows with the information from row 4, one row would be standard cuff an one row for large cuff...

The customer fills out the form and selects either standard or large, if they select large we need it to duplicate the row and have the size also be listed as standard as it is two separate items to be ordered. Customers who submit the form automatically receive the standard size cuff and the large cuff is separately ordered.

Andrée Starå

Hi @CaraBart28

I hope you're well and safe!

Excellent! Glad you got it working.

Feel free to share your solution.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

CaraBart28

Hi @Andrée Starå ,

So Basically what I did was created an automation to copy the row over to a separate sheet, that separate sheet then duplicates the row, and there is an automation set to change the contents of the cell. Once the contents of the cell are changed the row copies over to the original sheet, thus creating a duplicate row with the updated cell information.

Hope this makes sense!