Office Hours Question from Richard: “Why are you storing latitude and longitude in addition to the LatLong field?”
In this case, the location data we had was separated into two columns AND we had a combined LatLong column.
In most cases, you might have just separated columns for latitude and longitude - when you connect that table to AppSheet, the platform will automatically try to combine related columns (like Lat/Long or First Name/Last Name), and so a ‘LatLong’ field is generated as a single, virtual column. That LatLong column is what you’ll be able to use in a map, or for calculating distances.
Thanks for the Aliens reference, Rich!