Hi,
It would be simple to build an App against a SharePoint List for this yes. A few thoughts on it
1. You need to create a List in SharePoint (or Dataverse if you want to pay for premium but I don't recommend it atm).
This list will have all the Points lined out.
Example
SharePoint List Example
Column (Name) Column (Point Value)
Big Tree 1
Dead Leaves 2
And so on. This is simply used to give us the ability in real time to track points against a specific category
2. Now lets create another SharePoint list. It will be our Daily Tracker.
Column (Collection Date) Column (Truck Operator This would be Person Type Data Column) Column (Daily Points)
This would be Todays Date When the trucker signs in it knows to make it them Total Points for today that changes over time
3. On more List to track the individual items collection
Column (Category) Requested Quantity Quantity Picked Up (Truck Operator person)
The type of item how many of a Category was asked to pick up How many did you actually take again who logged in
This would allow you to also keep track if a customer had more to pick up, maybe the next day. So many things you could do.
Think of List 1 and List 2 like a shopping list. You have each item listed on your receipt, but you need to know in advance and at the end who much the total would be. So, List 1 is a rollup of all the daily collected stuff so far in real-time, and List 2 are the individual items.
4. Now in the App
The person would sign in (by opening the app)
--The app would allow them to Select a Category of the item type, as well as set the quantity, in case they are getting more than 1 "size" of this type
--The app should allow them to add more than one Category type at a time in case they are at a place that lets them pick up more than 1 type at a time
--The app will calculate what the total points would be, IF they actually collected the estimated pick up. So they would know if they were going to go over, either to stop altogether, or tell the customer, hey sorry I can only grab X today
-- Once they accepted that they could take it all, they would load it and then in the app, save it so that it goes in the back end. Which would auto update the total items for the day as well as the total points already collected, which they would always see.
There is so much more that can be done, but this is just a high level suggestion and again, I could add so many bells and whistles..
Cheers,
-Michael
Share
Report
4
All responses (
Answers (