The part before is concerns a call to Google’s chart API, which has an option (‘qr’) to generate QR codes. The QR ‘chart’ is then converted into an image with the IMAGE encapsulation.

Since the URL is specific to each tab, I can simply copy the URL and use it to create a QR code that will open Google Sheets directly to that tab.

Amy Cavender explains how readers can create their own attendance “app” using Google Forms.