0

I'm in need of some help with my google sheets project.

I currently run a small business. And use sheets as a way to manage stock. I want to create QR codes to scan on item that will take me straight to the cell to adjust stock levels. However, when I insert a new row for an item, this changes the location for all QR codes already generated.

Is there a way around this? For example. If I have 3 rows of stock items. If I insert a row between row2 and row3 then row3 becomes Row4. But the QR code generated will still take me to Row3 which would now be incorrect 😫

1
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community
    Sep 9 at 8:21
0

You can use a formula to dynamically generate a URL which includes the cell address, and use that to generate the QR code. But since the reference has to be updated every time you add rows in between other rows, the QR codes will also update to point to the new location (it will keep changing), which may not be what you want. But at least, the QR code in a row will always point to the row it is in.

For example, assuming your QR code is to be in column C, put this in cell C2:

=IMAGE(
  CONCAT(
    "https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl=", 
    ENCODEURL(
      CONCAT(
        "https://docs.google.com/spreadsheets/d/<SHEET-ID>/edit#gid=0&range=C",
        cell("row", $C2)
      )
    )
  ),
3)

You can now drag the cell to auto-fill the rest, and inserting rows should update the existing entries as well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.