{"id":1126,"date":"2017-04-19T05:09:38","date_gmt":"2017-04-19T10:09:38","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=1126"},"modified":"2017-04-19T05:09:38","modified_gmt":"2017-04-19T10:09:38","slug":"location-column-formula-map-views","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/whats-new\/location-column-formula-map-views\/","title":{"rendered":"Location column, formulas and map views"},"content":{"rendered":"

Today, we proudly present TeamDesk<\/a> integration with Google Maps<\/a>. With new Location column type and map views you’ll be able to add GPS position visualization to your databases.
\n<\/p>\n

Location Column<\/h2>\n

Location column is designed to hold the latitude and the longitude as a single entity and optionally visualize it on a map. Here is a screenshot of Location column options:<\/p>\n

\"Location<\/p>\n

First of all, Format<\/em> option allows you to set whether the value is displayed in a form of a pair of two decimal numbers – latitude and longitude expressed as whole number and fractions of a degree, such as 41.836944, -87.684722, or in a classic<\/em><\/a> form such as 41\u00b0\u00a050\u2032\u00a013\u2033\u00a0N, 87\u00b0\u00a041\u2032\u00a05\u2033\u00a0W. Signed degrees<\/em> format is commonly used in GPS systems so it is the default to simplify copy-pasting. Second format is human readable but is a subject of rounding errors. TeamDesk holds up to six decimal points for coordinates, that’s the location precision is about 11cm.<\/p>\n

List style and form style properties define how to display location in views and forms respectively. You can choose to display location either as a text, button, or map thumbnail with or without coordinates. Either way is clickable and leads to Google Maps. On mobile platforms click will launch corresponding application.<\/p>\n

\"Map<\/p>\n

 <\/p>\n

Input field accepts both formats for user’s input regardless of column settings. Also, it provides two buttons for advanced location editing.<\/p>\n

\"Location<\/p>\n

 <\/p>\n

Compass arrow button fills input field with current location (if the browser supports geolocation at all). In addition, pin button allows the user to select location either by searching an address or place or by dragging the pin around the map.<\/p>\n

\"Select<\/p>\n

Column has an ability to automatically fill the field with current location if has no value. However, we need browser’s support to get the coordinates and it may take some time before we get the result. Thus we have not put it as Default\/Calculate option, rather created separate setting limited to forms and inline view editing.<\/p>\n

Location formula<\/h2>\n

Of course, there is a Formula – Location counterpart. Formula column options match Location column. Also, there are couple of functions you use with locations:<\/p>\n