I am hoping to create an inventory spreadsheet that uses a QR code to bring up the inventory list, and then allows the person scanning the code to edit a blank cell to identify who the item was checked out to. We have multiples of the same item, so I would like to be able to pull up only the item associated with that QR code instead of the entire spreadsheet. I have figured out how to allow someone to view only the range associated with a QR code on a published document, but they need to be able to edit. Here is an example of the URL I am using to create a QR code for a specific rage of cells (1 item):https://docs.google.com/spreadsheets/d/19IVyc2Zpc5iR5Lnjb8UD7ptb8qxkJU7CGMXKacILmdc/pubhtml?gid=0&single=true&range=A5:D5
How can I create a QR code that links to a specific cell in Google Sheets, but can be edited, not just viewed?
google spreadsheets