Hi Team, I am working on the Vehicle Log She...

AppSheet AppSheet Q&A
1

Hi Team,

I am working on the Vehicle Log Sheet App that lets drivers select which service car then collect the odometer readings after every trip.

I need your help to come up with a formula or expression in the Initial value for column “Odometer Start” - that it should capture the last Odometer End value to which Car is selected on “Vehicle No.” column.

Is there any better way of doing this? Please throw in some suggestions too or anything that would make it more awesome! Thank you

2

Hi. Better you have one more column timestamp Then formula becomes Any(Select(Vehicle Log[Odometer End], [youKeyColumn]= MAXROW(“Vehicle Log”,“Timestamp”,[Vehicle No]=[_ThisRow].[Vehicle No])))

3

@Sdfaheemuddin This didnt work. Did you mean by Vehicle Log as the Table name? and is this formula particularly be used in Column Odometer Start?

4

Yes exacly Vehicle log is the table and the formula is to be used in column Odometer Start

5

@Sdfaheemuddin It worked! your awesome Syed! Thanks!

6

+Walton Atizado

Happy to help?