How do I get the value of the last row for a specific user?

[Darek]

I am trying to set the initial value to the last value saved in the spreadsheet by the user

ANY(Select(Kilometry[Stop licznik],AND(([Kto]=USEREMAIL()),([_RowNumber]=MAX(Kilometry[_RowNumber])))))

but it doesn't work properly

[MultiTech]

If your records are ref connected to your User table, you'll have a reverse reference of all the records for that table.

• From that... you can easily extract the "last item in the list" by the following:

index([Related Whatever], Count([Related Whatever]))

• If you make a virtual column that's an Enum (base type REF - to whatever table its a list of records for), you can de-reference any value you wish out of the record.

If you implement the Current User System, you'll also have that value as a global variable - which you can then call from anywhere inside your system.

--------------------------------------------------------

This is also much more efficient that brute forcing an answer with SELECT(). (^_^)

[Darek]

Sorry, but I am a new user of appsheet.. I understand what's going on but I don't know how to write it. What you need to explain it to me step by step?