Address field showing 90 180 as lat and long

Help Center Get Answers
1

Hi,

I have an address field, with the input set to Lat/Long. (and international).

the majority of my locations are correct, with a lat and long, or they are blank and I can paste in the values.

About 10% of records the field is set to 90 (for lat) and 180 (for long) and I cannot delete or replace these entries.

I have tried changing the input to address in case there was so rogue data in an address field, but nothing.

Tried turning off geo location etc etc - and nothing will allow me to delete or overwrite the 90, 180.

Any ideas?

Thanks in advance

2

I’ve found a workaround…

I’ve created a grid with an action of replacing address field to custom value, and have left that custom value black, and when you trigger action it works, deletes the values,

2 Likes