I am creating a high school sports funding app, the idea is that schools sign up for the service via qr code, coaches sign up their team from schools qr code, the players sign up and share their qr code with supporters who can choose to donate or purchase team merchandise through the team store. The team store is a predetermined set of products (the store) but I want each team to get a new iteration of the store, and for that store to be their (Team Store) which they can edit the merchandise in their own iteration of the store.
I honestly don’t even know if this is possible on this platform as I am more familiar with airtable, make and wordpress to make my projects.
I will eventually want to add other things like the team schedule, the roster with photos etc. but for now I want to make sure the store can be used to create team stores.
any help is greatly appreciated!
sounds like maybe you can have 2 tables. 1 for the team stores and 1 for the products. you can then have the individual teams add, remove or edit from the products table. have a column product info and a column matching the correct team store. then you can connect the products to the correct team store via relation columns matching team store names. i hope this helps
Hi Arong,
That sort of makes sense to me, but I cannot for the life of me figure out how to make it all work. I agree there needs to be one product set, that each (team store) can select from, but do you have any examples of how this might be done, perhaps a video I can watch to better understand? sorry still so new to this platform, I created this in airtable prior to learning of glide, now I want to create it here as there is a great deal I want to add but it wouldn’t work in airtable.
Im thinking at the very least you’ll need:
Table 1 - Team Stores
Column 1 - Team Store Name
Column 2 - Relation column connecting (Table 1 Column 1 “Team Store Name”) to (Table 2 Column 2 “Team Store”) Match Multiple
Table 2 - Product
Column 1 - Product Name
Column 2 - Team Store
front end you can add collections or list to display the products per store
just got to make sure when creating new products that the team store and team store name match - i would use a front end multiple choice type deal but which ever way works best for you
I would have a RowID column in Table 1, and use that for the relation in table 2 to make sure it’s all unique, also you can change the team name in Table 1 any time without affecting the relation.
To use the rowid column in table 1 you would have to have the same corresponding id in the product table. another solution can be you have a team column for the back end relation data such as coaches or players then a front end team name column for the interchanging team name
Agreed, I try to make sure each record has it’s unique record id (or RowID in Glide). Do you post related content to yt?
not gonna lie, I am a bit confused. Do you mean that in order to get them to relate to one another I have to first have the exact rowid in both tables?
if you use rowid then they will have to be the same. it would be easier to use a standard team label such as coaches or player. if they want a custom team name that can be a separate column for team name
I think I understand what you are saying, I am probably going to hold off for just a bit while I try to finish out constructing more of the other portions of the app and then come back to this issue. I would love to show everyone the app when it is finished.