Need som help with an expression

AppSheet AppSheet Q&A
1

Hi there

So I am making a driving log app and am trying to make an expression in “km out” initial data that will find the last entered km by witch vehicle that is selected. So when a driver enters a vehicle he opens the app and add new entry, then when selecting a vehicle I would like the column “km out” to be filled with the last entry of the same vehicle.

Anyone that could help me on the way?

2

For example MAX(SELECT(TableName[km],[vehicle]=[_THISROW].[Vehicle]))

2 Likes
3

Thank you, thats what I needed.

4

You’re welcome