I have a master “Project” sheet with 1 row per project.
I also have a “Reviews” sheet that is used to capture form responses where multiple people submit a form with attachments for the same project (they enter in the unique project ID as a form question to link it all together)
This results in lets say 4 rows on my Reviews sheet for 1 project on my Project sheet. I’m not worried about collating the data onto the Project sheet, I can do that. I also figured out how to get the Row ID from the Project sheet to be in a “Project Row ID” on my Review sheet (using zapier and index/match.)
My issue is I can’t figure out how to move all the attachments from my review rows to all by moved/copied over from my Reviews sheet to the correct 1 row on my Project sheet.
I tried using this zap:
Trigger - new attachment
Action - Add attachment to row
The issue is that when I select the row for the action, I can only see the “attachment” data but not the row data it was attached to (besides the Row ID, that’s it). I need the column value for “Project Row ID” of the row the trigger attachment was attached to. When the trigger is “New row” it gives you all the column values but not the attachment. But for “New Attachment”, it gives you the attachment data but not the row data. Gahh….
Any workarounds or ideas?
Best answer by SamBView original