I'm working on a car mileage app. but need the latest value

[numfon_naka]

Normally save paper like this.
2023/4/7 time 12:00 A took the car out of the company, mileage number 123456
Time 13:00 A brings the car to the company, mileage number 789101
At 14:00 A took the car out of the company. Mileage number 789101.

2023/4/8 time 08:00 A brought the car into the company, the mileage entered 234567
Time 09:00 A takes the car out of the company, mileage number 234567

I want the mileage out is the latest value of the mileage number.

[Kirk_Masden]

That should be possible.  I think, though, that we will need more information about how your data is structured and how your interface works to help.

[Marc_Dillon]

https://help.appsheet.com/en/articles/2357296-max

https://help.appsheet.com/en/articles/2357314-select