Hello Mark,
I try to explain what I want to do:
On my first screen I have a button, that button creats an empty entry in my Spreadsheet1 and forwards me to my second screen where I can update these empty values, on my second screen is also a switch, that switch creats a copy of the data in another spreadsheet2, here Im using your idea and store the rowobject from the created row into an variable, Im using that to be able to delete the row when the switch value is set to false.
It works aslong as I stay on that screen2 and siwtch the switch on and off, it creats the row in spreadsheet2 and deletes it, but if I for example creat another job and go back to the previus job im not able to delete the row in spreadsheet2 because I dont have the value of the rowobject (Rownumber) anymore.
There for I need to get the rownumber of the corresponding value in spreadsheet2 if I open a job.