Template
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.
Loading...
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.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...