We're setting up your new app...

Sample app

Most Recent Value

Initialize forms with most recent value

Industry: n/a
Function: Other
This app shows how to initialize a form with the most recent values that were added. Try adding multiple rows to see the behavior.
Also see: tablet mode & fullscreen mode
Embed sample:

How we built this app

To do this, we created a table that has a timestamp column. This gives us a notion of "most recent row". Then, we added a virtual column called MostRecent with the formula MAXROW(Data, Timestamp). This returns a reference to a row in the Data table with the latest Timestamp value. Then, in the Initial Value property of the columns we want to initialize, we use formulas like [MostRecent].[City] to access the City column of the most recently added row.
This is a preview of the data sets used in the app.


This is a high-level model of both the data entities and the UI elements in the app.
Start for free