Hello everyone! I want to add a map to my app...

(Sebastian Avila) #1

Hello everyone! I want to add a map to my app with a virtual column in wich i used the “CONCATENATE” formula to add the values of Lat and Long. I have this data in two different columns in my database that´s why i´m using this formula but this isn´t displaying the map. Any kind of help with would be great

There´s a way to od what i want?

Thank you.

(Jacob Lin [AppSheet]) #2

Firstly, if you name your columns ‘Latitude’ and ‘Longitude’ or ‘Lat’ and ‘Long’ Appsheet will automatically create a virtual column that concatenates the two columns.

Secondly, with what you’re doing here, if you look closely at your ‘LatLong’ field, there is no comma between the two numbers. Without it, you can’t make the field into a Lat/Long data type.