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:
- Has a home screen that requires a member to log in.
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
that only they would know so they can log that into a space on the purchase
app so that I can identify who they are for the purchases in the spreadsheet
this app would log their purchase into.
- Have a drop down menu, or something similar, for what category of product
they are purchasing.
(example: Drinks, Supplements, Samples, Apparel,
- Have a drop down menu, or something similar, for selecting a product within
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,
- Have some type of menu that allows the member to add in the quantity of
that product they purchased.
- Have some kind of button or option that would allow them to add
that product to their cart and allow them to go through that process all over
again for any other products they want to purchase.
- Lastly, a button or option that allows them to complete the purchase and log out so that the app goes back to the home page to allow another member to sign in and make purchases
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?