Add Data from Current Sheet to Another Sheet

I’m not finding a workaround for this function.

Situation: I need User’s to “report inaccuracy” with a button on a detail page.

The inaccuracy reports need to be added to a new sheet, so that we can work through them one by one - issue tracking system.

For this to work, I need to add the unique Row ID for the detail page they are on to the ‘new sheet’ where reports go - so we know which entry it is. I can get the user’s email, but I can’t find a way to get this info.

I’ve tried:

  1. Having a button that goes to the sheet (and has a couple of entry fields to submit)

I can’t find a way to post the data from the start sheet however.

I hope this makes sense/ is clear.

The content that has “inaccuracy” parts does have a rowID, is that correct?

You can use the form button to write the rowID to the Reports sheet using columns component.

1 Like