Most Recent Value
Initialize forms with most recent value
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
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.