that is to say that within the red circle any blue dot is assigned to a store …
I would appreciate your help …
Solved! Go to Solution.
I think you should be able to use DISTANCE(…) function, and for example if the distance between HERE() and a particular location that you could consider as official address of that block is less than 0.2 (distance returns km), then replace the entered number with that official address.
You can read more details about distance here.
I think you should be able to use DISTANCE(…) function, and for example if the distance between HERE() and a particular location that you could consider as official address of that block is less than 0.2 (distance returns km), then replace the entered number with that official address.
You can read more details about distance here.
Hello Reza …
Your idea is very good, I wanted to put it into practice but I find this problem …
DISTANCE (LATLONG (20.700896, -103.364275) - HERE ()) <.2
the “EXPRESSION ASSISTANT” says that the parameters are invalid!
I have tried with quotation marks, or
DISTANCE (HERE () - HERE ()) and gives the same error!
What should the format of the parameters be so that I can do the distance evaluation ??
thanks for your attention …
other examle, invalid input types…
Did you have a chance to read the document from the link I sent you? Here is the paragraph about DISTANCE() function:
- DISTANCE( location , location ) returns the approximate distance in kilometers between two locations expressed as LatLong values. DISTANCE() does not work with Address values.
There has to be comma instead of “-”.
Have you tried just this expression and see the test results in expression builder?
DISTANCE (LATLONG (20.700896, -103.364275) , HERE ()) <.2
Reza…
You are very right, I will be more careful with syntax.
I’ve already worked on the Distance () formula, but I find that in some cell phones and laptops, HERE () does not get a fast value and when it calculates distance it gives me a huge amount “11405.8631957932” …
Would it help me to get some unique value of the mobile / tablet / pc that is being used at that moment, as the name of apparatus ! or something that distinguishes them, any ideas?
thx…
Captura%20de%20pantalla%20(62)|690x387
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |