Not sure what to use here?

AppSheet AppSheet Q&A
, ,
1

I have two sheets, one for History of each day a driver is out which includes which stores they go to it houses(store number, date, pay, goal, and the after they put in their first store it displays how many miles they need to hit their goal) I want to take the number of how many miles they need from the history sheet and search on the other sheet I have which is a sheet of all the stores we serve with their mileage to that store, store number, address etc. I want to generate a list after the first store has been put in for the day that will display what other stores that driver is able to do to reach his daily goal.

2

Create a slice for the Stores table using an expression along the lines of the following:

[their mileage to that store] > {expression that returns "how many miles they need to hit their goal" from the History table}
1 Like