# Import QR codes generated in Google Sheets **URL:** \ **Category:** Ask for Help\ **Created:** [September 2, 2023, 10:18am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709 "2023-09-02T10:18:24Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 2, 2023, 10:18am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/1 "2023-09-02T10:18:24Z")
I received data from Google Forms to which I convert some of that data directly into a QR code. It is just LastName, Firstname. I need to pull those Google Sheet Image created codes into Glide so they display in the user profile (of a team. Can someone guide me how to do this? Thank you. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 2, 2023, 10:26am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/2 "2023-09-02T10:26:35Z")
Why not generate your QR Code inside the Glide Data Editor? > **[Glide • QR Code column](https://www.glideapps.com/plugins/qrcode)** > > Generate QR codes from any value. ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 2, 2023, 11:37am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/3 "2023-09-02T11:37:39Z")
I’m open to check it out, however, how to do that? Can you point me how to create QR codes in Glide Data Editor? The QR codes currently generate automatically in Google Sheets depending on the input from Google Forms. That keeps all data in one table when I pull it over to Glide. The Google form will be active periodically and need to generate QR codes when input is received. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 2, 2023, 11:54am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/4 "2023-09-02T11:54:42Z")
Well, I assume that the Google Sheet that contains the FirstName and LastName is connected to Glide? Given that, you’d just go to the Glide Data Editor and add two columns: - Start with a template column that concatenates the two names: ![CleanShot 2023-09-02 at 19.52.55@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f49bca8fc5c7a8d7c89394dc0cfc2b94bbcea159.png) - And then add a QR Code column that generates the QR code from the template column: ![CleanShot 2023-09-02 at 19.53.27@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/330003759f0021d205c73ccf78567d3f7899193e.png) ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 3, 2023, 7:57am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/5 "2023-09-03T07:57:04Z")
Thank you. I’ve added it and was able to generate the qr code. How to get the QR code to display in the app on Layout view? It is visible in the data editor but not the layout view. Thank you, M ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 7:59am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/6 "2023-09-03T07:59:06Z")
You can display it in any component that accepts an image. An Image component, a Title component, even as the image in a Collection. So just choose a component, add it to your layout, and set the source as the QR Code column. ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 3, 2023, 8:05am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/7 "2023-09-03T08:05:15Z")
![image0 (1)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c8576ef883660839c6871e6d8048be9beef2a5e4.jpeg) I’ve added a field and pointed to the column in the data editor. The QR code now shows in the layout view. However so does many rows of garbled data. Did I add the QR code incorrectly? How to remove the garble data? See attached image. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 8:07am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/8 "2023-09-03T08:07:20Z")
Did you use a Fields component? It won’t display properly in that, as it doesn’t accept images. Here are some examples of how it could be displayed using various components: ![CleanShot 2023-09-03 at 16.04.20@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d5504d4557158509726cfb22c0a1aa99d975f1e.jpeg) ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 3, 2023, 8:26am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/9 "2023-09-03T08:26:39Z")
Thank you. Sorry if I’m crushing you with questions. Trying to learn tonight. I have images with URL links in the data table. However, I can’t seem to get them to reference to the Image on the Card. If I click the URL link itself in the layout the image opens fine. Just don’t know how to apply those images to the Card. ![2023-09-03_01-24-29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/09a134d5548b73fe9d9cbf9f764e85a1c3bad94d.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 8:50am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/10 "2023-09-03T08:50:24Z")
Can you show me a screenshot from the layout editor that shows how the card collection is configured? ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 3, 2023, 8:53am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/11 "2023-09-03T08:53:22Z")
![2023-09-03_01-51-41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/2121e42d5c450212e55f639070f5c3cebb45f37e.jpeg) Here you go. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 9:00am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/12 "2023-09-03T09:00:41Z")
See below - Image should be pointed at your QR Code column ![CleanShot 2023-09-03 at 16.59.30@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f4ec9709885c6e14d00e0c2a97bd0ed2c78f9fe.png) oh, wait - have I misunderstood? If you want to use that “Photo of Self” column, try changing the column type to “Image” in the Glide Data Editor. ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 3, 2023, 9:24am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/13 "2023-09-03T09:24:23Z")
I think I understand the issue. The URL links are to uploaded images stored on a Google Drive sourced from user input via a Google Form. The Google Drive URL links are not working. When I changed the links to images (on a couple of cards in the data editor) to URL links from the web (general links to public images) it worked immediately. What is odd is the Google Drive URL images do not pull into the card, however, when I have them as a field (and it displays the URL) it opens just fine when I click the link. So the link to the Google Drive images (via URL) does work when clicking out to the image… just not to pull in and display on the card. Any other way to manage this? I ask because Google Forms are very useful for sending to High School student / athletes (I’m using this to help manage a high school sports team). When I send them the google form (to register them and get basic contact details) I ask them to upload an image of themself to add to the card. This obviously helps coaches relate the name to an image while they get to know the whole team. Your thought on how do to this while still using Google Forms to collect the images? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 9:36am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/14 "2023-09-03T09:36:44Z")
How important is it that you use Google Forms? Personally - I would ditch the Google Form and collect the data via Glide. Either add a form to your existing App, or create a new basic App just for the purpose of collecting the data, and use a shared Glide Table. This way, the images will be uploaded directly to Glide storage, and the issues you’re having will go away. ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 3, 2023, 9:52am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/15 "2023-09-03T09:52:01Z")
For the moment I will need to use Google forms as the data goes directly to my Google Drive for the District. I then share that information with others in the school. I’m open to learn how to create a Form in Glide but I’m very new to this and afraid it will take a while to learn. It’s 3am where I’m at so I’m trying to learn… but my deadline is fast approaching. I need to send out the form next week. Can you point me to a Glide tutorial on budling forms (which is similar to Google Forms with drop-down lists?). ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 3, 2023, 9:59am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/16 "2023-09-03T09:59:23Z")
Setting up a form is quite straightforward, below is a link to the relevant doc: > **[Forms](https://www.glideapps.com/docs/use-cases/forms)** > > Collect data from your users in custom forms. ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 3, 2023, 10:03am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/17 "2023-09-03T10:03:04Z")
Thank you. I’ll go through it a little now and more tomorrow. Much appreciated! ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 7, 2023, 6:50am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/18 "2023-09-07T06:50:52Z")
In my app I have data presented like cards (members of the team). How to set up a filters like I would do slicers in Excel. For example I want to filter all males who are wrestling at a specific weight class (126 for example which is one out of 14 weight classes)… So I’d need a drop down for each of those filters (on data already in the table) on the layout screen. Filter Male/Female, and weight class, and status (JV/Varsity). I’ve watched several videos and I’m tinkering around for the last two hours but can get it started (don’t see how to set it up). ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 7, 2023, 7:43am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/19 "2023-09-07T07:43:54Z")
Have you tried the In-App filtering? In your Card Collection configuration, look under Options: ![CleanShot 2023-09-07 at 15.42.16@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d8101ed1103a2129baf93f89335576ee0576c1e.png) ---
**Author:** ![Michael\_Bozanic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_bozanic/32/63628_2.png) [@Michael\_Bozanic](https://community.glideapps.com/u/Michael_Bozanic)\ **Post date:** [September 7, 2023, 8:04am UTC](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709/20 "2023-09-07T08:04:47Z")
Excellent. That gets me in the right direction. Thank you! Aside question, I view everything in the layout section on my computer. For some reason now, in the app on my iphone, I only see users. I do not see (and cannot get to) the data cards. I must have blocked myself. Where to check? [Next page](https://community.glideapps.com/t/import-qr-codes-generated-in-google-sheets/65709.md?page=2)