I own a crossfit gym and I offer protein powders, pre/post workout drinks, apparel, jumpropes, and other miscellaneous products for purchase.
I have a sheet where these products are for members to fill out their name, date, what product/'s they purchase, quantity purchased, and a space for a coach to initial that they verified the purchase was correct.
I created a spreadsheet that I log these purchases week by week until it gets to the end of the month, where I add these charges to the members bills in the gym software I use for my gym.
Having to log these purchases week by week, or if i get behind or lazy, having to log them at the end of the month, takes too much time and is a pain in the butt.
I was hoping to make an app on appsheet that does the following:
The reason is so I can
track who is making the purchases but also not allowing other members to
make purchases on other members names.
I would prefer this option but if it
isnโt possible, I would atleast like to be able to give each member a specific ID
app so that I can identify who they are for the purchases in the spreadsheet
this app would log their purchase into.
they are purchasing.
(example: Drinks, Supplements, Samples, Apparel,
Miscellaneous)
the selected category.
(Example: They picked the category โSupplementsโ, so
the drop down menu would give them the option of "Whey Protein, Vegan
Protein, Bone Broth Protein, Egg Protein".
Or if they select the Category
โDrinksโ, It would give them the options "Water, Muscle Milk, Coconut Water,
Gatorade, etc.")
that product they purchased.
that product to their cart and allow them to go through that process all over
again for any other products they want to purchase.
The reason I would like to set something up like this is so that it automatically updates into a google sheet for me so I can create a pivot table that will pull the data I need to add in each members added purchase costs to their monthly bill so I donโt have to manually go through each sheet tallying up each members purchases into my current spreadsheet I created for tracking these purchases.
I plan on having a tablet set up where the products are for members to use that as a kiosk to purchase items rather than filling out a sheet of paper.
Is this even possible to set up on appsheet? mainly #1 on my list of app requirements.
If so, how would I set this up?
Hi @K_Berg
You should be able to do all this and more in Appsheet. Have you had a look at any sample apps .
@Lynn Ive been looking through a few of them but havenโt found one that does the things Iโve stated in this post.
The main thing I want to make sure appsheet is capable of doing is the sign in option at the kiosk to make sure the members can sign in first before they purchase
Hi , check out this page.
help.appsheet.com - Require Sign-In: The Essentials Require Sign-In: The Essentials help.appsheet.com
User | Count |
---|---|
45 | |
29 | |
24 | |
22 | |
13 |