I have a column GPS Location in a Reporting table, which is type latlong. Normally reporters tap the spinner to get their current location. But for the location type, “Admin Facility”, all the locations are buildings where latlong locations are known. For these I’ve entered each building’s latlong in table “Location Type”. The column “Name” are names of various building names. A third column is “GPS Location” (I’ve tried type text and latlong), with a latlong value for each Name.
In case user enters a Name that is an Admin Facility I want to lookup the GPS location and enter it in GPS Location. But the following expression doesn’t work as an app formula or as an initial value.
ANY(SELECT(Location Type[GPS Location], [Name] = [_THISROW].[Name]))
I’m hoping someone can sort me out.