So i am trying to build an app which tracks sales which have been made across some stores.
Each month i get a new google sheet which has the details on which i need to look up and pull into a form.
The submitted form then builds up a database of sales which generates a dashboard and review etc
We have a glide app currently which works but i think it could be smoother and faster for colleague input and reduce errors.
I have spent a little time playing around on the app, watching some videos on Youtube but i am struggling to make progress.
So the app will work as follows
Colleague selects name
Selects which store they work for
Enters a code ( SOC) which identifies what has been sold
The SOC can relate to a New customer or Existing which both have a different profit value
Based on the store selected i would like it to return the correct profit, ( each store is different)
My challenge is how do i get from the colleague entering the SOC for it to return the results back into the form and have the correct value based on New or Existing and the Store.
Sheets I currently have
Options - Shows colleague names, type of sales, store etc
Rate card - Shows all the sales information and SOC code, revenue, store.
I appreciate any feedback and help,
if you know of any good learning tools to us please feel free to share.