Hello!
I need help. FM pro Newbie.
Goal: create a search function that returns all records within a 1000 feet from initial record using longitude and attitude only.
I have one location. I need to find all records within a 1000 feet of that location and display them.
Sounds easy right? I cannot seem to figure it out.
Please help Obi Won Kinobi
Thanks
Jeff
Had a similar problem. Ended up using global fields for the fixed position and having a calculation field for the distance.
The distance field is searchable.
My example file is calculating the distance in meters, youll have to convert the earth's radius 6371000 meters to feet.
Got the formula from https://www.movable-type.co.uk/scripts/latlong.html
Happy Filemaking
Kim