Help Needed: Linking Shopify Purchases to Unique User Quiz Progress in Glide

Ask for Help
1

Hi everyone,

I’m building an app in Glide and could use some guidance. Here’s what I’m trying to accomplish:

  • Customers makes a purchase in Shopify that grants them access to the app.
  • Their purchase details get added to the user list in Glide.
  • They receive a unique web link (tied to their email address) so they can log into the app.
  • Inside the app, they take a quiz, and I want their answers and progress to be tied specifically to their row in the user table.

Right now, the issue I’m facing is that when users input their quiz answers, the data doesn’t tie to their row—it just seems to go to the top row instead.

Does anyone know the best way to structure this so that:

  1. Each user’s inputs are stored on their own row, and
  2. Progress is saved uniquely for each user?

Any advice, best practices, or examples would be greatly appreciated.

Thanks so much!

2

Sounds like you are trying to use entry fields right on the main display. If that is so, you want a “helper” table that is all user-specific columns for entering the info. When they hit the “Submit” button that you create it will use an add row action and make sure you are recording that user’s email to that new record. Now you can create a relation in the user table to show all responses or from the responses table lookup the users details.

Alternatively, use a button leading to a form screen. This will add a row to your table with the filled in details. Again, tag the user’s email in that new record so you can relate it it.

If this doesn’t make a ton of sense, I highly recommend using Glide University to get up to speed.

1 Like