Template
Initialize to Nearest Location
Initialize a form with values from nearest location
Industry:
n/a
Function:
Other
This app shows how to initialize a form value to be the nearest one from a set of locations. Try opening the form and see that the value is initialized to the nearest Person on the map.
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
To do this, we created a "Distance in km" column on the Person table. We used the formula DISTANCE(HERE(), [LatLong]) to get the distance away from the app user. Then, in the Form table, we used an Initial Value formula of MINROW("Person", "Distance in km") that returns a reference to the Person table that has the minimum "Distance in km" value.
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...