I have an app that allows people to place orders, using the app on a tablet as a kiosk at my gym for members to buy supplements and other products.
I have it set up so that the person can log their name, the date automatically fills in,
a drop down for the product category, then a drop down that shows the products to choose from in that category, and finally a quantity with a plus/minus for the person to log how many of that product they want to purchase.
What I want is for the app to pull the price from the spreadsheet and multiply by the quantity in the app so that it updates in the app to show the individual how much their purchase will be before placing the order.
how do I do this?