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!
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.
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.
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.
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.
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)
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.
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.
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.
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!
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?
