So, I'm wanting to use the following line of code:
But, this formula needs to change from A2/B2/C2 to A3/B3/C3 and so on, but automatically.
I'm wanting to create unique QR codes, based on the incoming data, which is written to a Google sheet. So, a form is filled out capturing certain information, is written to row A2/B2/C2 etc, in Google sheet, and the resulting QR code is generated at the end of that row. based on the above line of code. This line of code/formula is not present on the spreadsheet, but rather, is pushed to the cell when the rest of the information is submitted.
The current problem of course, the code above does not change the QR code dynamically to represent the next row of data. It hard references the previous row ad infinitum. I need it to reference the next row, dynamically.
Is this possible?