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

(Audiovisual Services Headend) #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

(Syed Faheemuddin) #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])))

(Audiovisual Services Headend) #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?

(Syed Faheemuddin) #4

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

(Audiovisual Services Headend) #5

@Sdfaheemuddin It worked! your awesome Syed! Thanks!

(Syed Faheemuddin) #6

+Walton Atizado

Happy to help😃