Generate QR codes for Google Forms to share forms quickly and conveniently. Here's how to generate QR codes from Google Drive, Google Sheets to collect data effectively!
How to create QR codes for Google Forms in detail and effectively
To generate a QR code for Google Form on Google Sheet, you just need to follow three simple steps:
Step 1: Go to Google Forms via browser, create or open the form you want to share. Click the "Send" button in the upper right corner, select the "Link" icon, then copy the Google Form link. You can select "Shorten link" to make the link shorter and more visible.
Step 2: Open Google Sheets on Google Drive and paste the copied link into any cell, for example cell B1.
Step 3: Next, enter the following formula into the cell where you want to display the QR code:
`=IMAGE("https://image-charts.com/chart?chs=500x500&cht=qr&chl="&ENCODEURL(B1))`.
Formula explanation:
- IMAGE : This function is used to display an image from a URL.
- https://image-charts.com/chart ? : This is the QR code generation link.
- chs=500x500 : Specifies the size of the QR code (500x500 pixels).
- cht=qr : Specifies the chart type as QR code.
- chl= : This is the part that contains the data that the QR code will encode.
- ENCODEURL(B1) : This function encodes the contents of cell B1 into URL format. You can replace B1 with the cell containing the data you want to convert to a QR code.
How to share Google Form with QR code easily
To share a Google Form via QR code, you can follow these three steps:
Step 1: Go to Google Forms and create or open the form you want to share.
Step 2: After completing the form, click the "Submit" button in the upper right corner, switch to the "Link" tab and copy the Google Form link. If needed, you can select "Shorten URL" to make the link more concise.
Step 3: Visit a free QR code generator website like: https://new.express.adobe.com/tools/generate-qr-code? to generate a QR code from the link you just copied.
Paste the copied Google Form link into the QR code generator box on the website, click to generate and download the QR code to your computer. You can then print the QR code or share it via social media, email, or other platforms for others to scan and access. Alternatively, you can also generate the QR code directly on Google Sheets, then take a photo and print it to share.
Creating QR codes for Google Forms is a convenient and effective way to share forms with everyone. With just a few simple steps, you can quickly create QR codes, making it easier to reach your audience. Try creating QR codes on Google Drive, Google Sheets to experience the convenience it brings.
Source
Comment (0)