Knowledge Base
Got issues? Don't worry, here are all the solutions.

How to let users open the entry by scanning the QR code?

You may follow the steps below to create a QR code for each of your entry:

Step 1. Create an "Entry ID" field with the auto-generate field type. Then, apply it with {Record ID} default values

Step 2. Save the design and trigger the populate empty values

The step is to apply the settings of default values to all existing entries. If you have no existing entries, you may skip this step.

Step 3. Create an "Entry URL" field with barcode field type and apply string formulas to refer to the "Entry ID" field

The formulas will be different based on your sheet URL and the location of the "Entry ID" field. The logic would be:

"Sheet URL"+ location of "Entry ID" field

Let's say if the sheet URL you're working on is https://www.ragic.com/ramzawang01/forms2/2/ and your "Entry ID" field locates in A10. Then, the formulas would be:

"https://www.ragic.com/ramzawang01/forms2/2/"+A10

Note: the quotes in the formulas are required!

Step 4. Save the design and trigger the formulas recalculation

The step is to apply the settings of new formulas to all existing entries. If you have no existing entries, you may skip this step.

Once the recalculation completed, you'll have the QR code in the "Entry URL" field:

Step 5. Set proper access right to the sheet in the global access rights panel

You may set the proper access right based on your use case. For example, if you want to let any users, with or without a Ragic account, view the entries, please grant the "EVERYONE" user group with "Viewer" access right.

If you only want to let some of the user groups view the entries, please refer to this article for different access right levels.

Step 6. Generate the label with lable maker

Once labels printed, you can attach them to your products or equipment. Users will be able to view the detailed information by scanning the QR code.

Top of Page
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com