# Creating a qr code that autofills a form in glide **URL:** \ **Category:** Ask for Help\ **Created:** [January 23, 2024, 6:57pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914 "2024-01-23T18:57:28Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 23, 2024, 6:57pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/1 "2024-01-23T18:57:28Z")
I am attempting to build a high school sports funding app, the goal is to have schools sign up under a salesman, then after registration the school would have there coach register and from there the players would register and send a link to their supporters that would direct them to a landing page where they can choose to donate or purchase merchandise from the team store. What I am having trouble with is auto-filling relationships in the forms, I am attempting to autofill the relationships to maintain a way to track each supporter all the way back to the salesman without them having the option to change this. I am not yet familiar with glide but in airtable I did this by creating a qr code that sent visitors to a registration form with all the url prefill&hide information already baked in the qr code. I am wondering if I can do the same thing in glide. The ultimate goal is for a salesman to sign up a school, the school can sign up coaches, the coaches sign up the players and the players send the link with all the relationships baked into the qr code, that way we can track donations and purchases back to the salesman. I also cannot seem to figure out how to get each team to be able to have their own iteration of the team store. For example I want one set of products (the store) but I want each team to have their own (team store) that consists of the products in (the store) any ideas and solutions would be greatly appreciated! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [January 23, 2024, 7:03pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/2 "2024-01-23T19:03:48Z")
Hi James, welcome to Glide’s community forum 👋 You could create 4 tables: Salesmen, Schools, Coaches, Players Whenever you add a row to Schools, add the SalesmanRowID to that row. This will allow you to relate schools to a salesman and vice versa. Whenever you add a row to coaches, add the SchoolRowID to that row. This will allow you to relate coaches to a school and vice versa. Whenever you add a row to Players, add the CoachesRowID to that row. This will allow you to relate players to a coach and vice versa. [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/46784c95dc6dd923c1719c7b7629b7f8bad99e93.jpeg "Things in Things | Glide Apps Tutorial | No Code") ](https://www.youtube.com/watch?v=HwKoIekup00) ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 23, 2024, 7:13pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/3 "2024-01-23T19:13:06Z")
Hi Nathan, I understand the relationships and I am currently using a row id for each of the tables, but I want the assignment of the relationships to be automated and trackable all the way from the supporter to the salesman. I have achieved this in airtable by creating a form with the relationships as select fields, I then created a qr code with prefill&hide and prefilled the fields with the salesmans info, each salesman gets a qr code with the url prefill&hide baked in, when a school uses the qr code it prefills the relationship info and hides it so that the school cant accidently change their salesman. I am trying to figure out how to do the same thing in glide but it is very different than airtable in many ways. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [January 23, 2024, 7:24pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/4 "2024-01-23T19:24:27Z")
When you submit a native form, there are 3 ways to pass on data: - Edit/Entry components: these are components that the user interacts with (fields, choice, switch, date pickers, etc.) - Values from screen: these are hidden values from the active screen, for example a parent screen - Values from user profile: these are hidden value from the user profile table Values from screen and from user profile allow you to pass along hidden values in a form, I think this is what you are looking for. > **[Screen Values | Glide Docs](https://www.glideapps.com/docs/reference/values/screen-values)** > > Values that you can access from the current screen. > **[User Profile Columns | Glide Docs](https://www.glideapps.com/docs/user-profile-columns)** > > Work with user data from anywhere in your app. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 23, 2024, 7:58pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/5 "2024-01-23T19:58:58Z")
Long story short, it’s possible but not straight forward. Essentially you can create a url to your app with query parameters in the url. When the app opens (in the table that it opens to) you can add ‘Get Part of URL’ columns to extract the query parameters from the url. Then you can have a button on the screen that opens the form, and from there you can add Value components to pass along those values that were extracted from the url without the user being able to manipulate them in the form. I’m not sure, but your button may need to have a custom action that first writes those computed ‘Get Part of URL’ column values to regular user specific columns before opening the form. ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 23, 2024, 8:40pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/6 "2024-01-23T20:40:03Z")
I’m sorry Nathan but I am a little confused, are you saying that there is no way to prefill&hide fields in forms on glide? ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 23, 2024, 9:20pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/7 "2024-01-23T21:20:51Z")
Hi Jeff, I think we may have a different idea of functionality. The end goal is to allow new schools to register with the service by scanning a qr code, I am wanting the url prefill information to be part of the qr code so that when scanned it will answer and hide the question (account manager name) qr code would have prefill&hide, this would allow me to create the relationship based on who’s qr code is scanned, that way when a new school scans the qr code and signs up the relationship to their account manager is already established. I want the same logic to apply for the new coach, player, supporter registrations, they scan the schools qr code and the relationship to the school and account manager is prefilled and hidden. I want to do this all the way down to the supporters so that I can track each donation all the way back to the account manager that way we can give recognition to the account managers for signing them up in the first place. Kind of like an Multi Level Marketing setup. Ideally I will automate the relationships through the qr code prefills, then the supporters will be taken to landing page where they can choose to donate money to the school or purchase merchandise from the team store, view the teams game calendar, etc. etc. ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 23, 2024, 9:32pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/8 "2024-01-23T21:32:21Z")
I want to use the same qr code prefill&hide logic to display a short video from the player on the top of the landing page that supporters are directed to. For example I want to have a video player who’s source is dynamic, the qr code prefill&hide would place the yt link in the video player. I hope what I am saying even makes sense. I have done all of this in airtable but its so different from glide and I am so new to glide that I think I am making something simple seem far more complex than it is. In airtable I created a field for the form’s url, then another field to concatenate the url with the account manager name prefilled and then automated a qr generator to create the qr code with the prefill baked in, when the qr code is scanned it takes you to the form but the account manager field is already filled and hidden. The same process for new coaches, it prefills the school and account manager, and so down to the supporters. It all works in airtable on the database end but the ui is so ugly and doesn’t allow me to place video above the forms. ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 23, 2024, 9:45pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/9 "2024-01-23T21:45:52Z")
I looked at the links you provided but to be honest I don’t understand what the example on the page is doing. It’s always a little frustrating learning new platforms. I am struggling with this but I know it can be done, I just need to learn this platform better to accomplish it. It should be simple (I said while pulling out my hair) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 23, 2024, 11:34pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/10 "2024-01-23T23:34:25Z")
> [@jamesstamper72](#): > > I think we may have a different idea of functionality. No, I completely understood, and my first comment explains what you need to do allow a user to scan a QR code, open a form, and pass those hidden values through the form. The difference is the extra step of pressing a button to open the form once the page loads, but that could probably be replaced with a form container instead directly on the screen, so the user would be taken directly to a form without having to click a button. Pulling the values from the url would still be the same. This has been done before and from what I hear it works very well. > [@Referral Program](https://community.glideapps.com/t/referral-program/26560/22): > > Recently, I had to implement an affiliate link referral system. The trick was to use the “Get part of URL…” computed column to grab the referral code from the affiliate link. Then, we can save that code into a User Specific column and assign the referral to the corresponding affiliate. Here is a tutorial explaining the process: [[Track Affiliate Link Referrals | Glide Tutorial] ](https://www.youtube.com/watch?v=KjhLgaO_-K4) ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [January 24, 2024, 12:23am UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/11 "2024-01-24T00:23:45Z")
> [@jamesstamper72](#): > > What I am having trouble with is auto-filling relationships in the forms, I am attempting to autofill the relationships to maintain a way to track each supporter all the way back to the salesman without them having the option to change this. Hi there. In your initial post I focused on the beginning of your post and totally ignored the part of the QR code. I feel like if you can already set up the tables and layout correct with a form without the QR code, then working with a QR would be the next step. When I build, I have a tendency to work in layers: I start easy then gradually add complexity. To me your QR code already sounds like a step ahead of what I would attempt, at least at the beginning of building the feature. It seems working with QR code might be easier in Airtable. It’s not as straightforward in Glide, at least not to me. I read what Jeff wrote and if I were implementing your setup with a QR code, I would be attempting to follow his recommendation. It looks good on paper, and it’s Jeff, so it should work. Our recommendations are complementary by the way. I focused more on the form and passing hidden values, Jeff focused more extracting the hidden values from the QR code. ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 24, 2024, 12:50am UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/12 "2024-01-24T00:50:35Z")
Thanks Jeff, I will look into this first thing tomorrow ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 24, 2024, 12:52am UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/13 "2024-01-24T00:52:05Z")
What Jeff said👆 . Glide does not have an easy/native autofill forms functionality but you can use the workaround described in Jeff’s first comment to auto fill a form using URL parameters baked into the QR codes URL. The set up on Glide side is not straightforward though. I’ve always meant to make a video on this, so maybe it will be my next one. ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 24, 2024, 12:52am UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/14 "2024-01-24T00:52:42Z")
Thanks Nathan, I will work on both of the suggestions first thing tomorrow, I know I am close but struggling with just a few things. I really appreciate all of the help! ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 24, 2024, 4:06am UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/15 "2024-01-24T04:06:11Z")
Thanks Robert, will do. Love your content on yt by the way! ---
**Author:** ![jamesstamper72](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jamesstamper72](https://community.glideapps.com/u/jamesstamper72)\ **Post date:** [January 24, 2024, 4:31am UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/16 "2024-01-24T04:31:36Z")
Hi Jeff, That was an excellent example of how to build the multiple relationships scenario I needed. I was hoping you might know of an example of someone using the “Get Part of URL” function that you mentioned, perhaps a video of it? ---
**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:** [January 24, 2024, 4:58am UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/17 "2024-01-24T04:58:18Z")
Have a browse through the below thread. > [@How to pass parameter to glide apps?](https://community.glideapps.com/t/how-to-pass-parameter-to-glide-apps/40090): > > Hello. I need to pass some parameter to glide app. How can this be done, for example, through a URL or in another way? Without zapier or similar services, I need a free and easy way to pass a parameter to the application, like this: [https://simple-soap-1.glideapp.io/?var=111](https://simple-soap-1.glideapp.io/?var=111) How to get this “var” parameter from the application? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 24, 2024, 5:34pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/18 "2024-01-24T17:34:02Z")
> [@jamesstamper72](#): > > perhaps a video of it? I’m on it. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [January 24, 2024, 8:51pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/19 "2024-01-24T20:51:25Z")
@jamesstamper72 👇 Fresh off the press, by Bob. > [@selfie Populate a Form by Scanning a QR Code](https://community.glideapps.com/t/populate-a-form-by-scanning-a-qr-code/69957): > > v Hey fellow Gliders! In this video, learn how allow users to scan a QR code to prepopulate a form screen using: backhand_index_pointing_right A helper table backhand_index_pointing_right A template column backhand_index_pointing_right Get Part of URL columns backhand_index_pointing_right Form container I’ve used this method to create scavenger hunt activities, inventory apps, onboarding functionality, and time card systems. There are several of variations you can do using this m… ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 24, 2024, 8:52pm UTC](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914/20 "2024-01-24T20:52:16Z")
Beat me to it! [Next page](https://community.glideapps.com/t/creating-a-qr-code-that-autofills-a-form-in-glide/69914.md?page=2)