When creating a record in my table, I use the location field (from google maps). I am not able to use Location as table ID. A possible work around would be to create a separate address field and populate it with the address from the location field. However, I am having trouble doing this.
Lucas Ward shared this idea · Oct 12, 2017
Comments
4 comments
Hi Lucas,
Thank you for reaching out to us with your question.
What you are looking to do, unfortunately, is not possible in the TrackVia system. You are able to reference a Location Field in the formula of a Calculated Field, however, if the formula is just a direct reference to the Location Field, it will not output a coherent value or the address information you are looking for.
Additionally, you can create an Application Script on a table with a Location Field on it that pastes the value of your Location Field into another Paragraph FIeld or Single Line Field, but it will only paste in the Latitude and Longitude values of the Location Field. It does not paste in the actual address values. (This is because the database only saves the Latitude and Longitude values in the backend.)
You will need to manually paste the address into a Paragraph FIeld or Single Line Field and then set that field as your Record ID. Just let us know if you have any further questions on this.
Thanks again,
Justin
Justin,
Thank you for the reply. Is it possible using the python API to reverse geocode the Latitude and Longitude and then return the address to TrackVia?
Thank you in advance for your help,
Lucas
being able to easily view an address would be much more user friendly than just coordinates.Only work around i've found requires entering the address in a paragraph field as well as the location field. This doesnt help when using the location of record creation though. would it really be that much trouble to add the address field as usable information?
Is there a way to do it in the reverse? Can I auto copy a typed in address field into the address portion of the location field?
Please sign in to leave a comment.