Use location as a Table ID or pull address from location field and put into a separate field
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 commented
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,
Justin Mauldin commented
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.