Jump to content
  • 0
Sign in to follow this  
openocean

Distance Search Field Value

Question

I would like to use the Value ("Calculated Distance") provided as a field value by the Distance Search by ZIP/Postal Code in a formula like:

CASE WHEN [@field:TravelDistance]< =("Calculated Distance") THEN 0
  ELSE 1
END

I do not know what Caspio names the value to allow it to be used in a formula. ("Calculated Distance") does not allow the formula to VERIFY.

Does anyone know what the name of the value would be to allow it to be used in a formula?

Thank You.

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

 

Is Calculated Distance a field? Can you please explain a bit further.

What have I done, stored the value of Latitude and Longitude of a place in the table and use SQL statement in Formula Field to get calculated distance.   

Share this post


Link to post
Share on other sites
  • 0

In Configure Result Page Fields screen, from the picker where you can select Calculated Field, HTML Block, HeaderFooter you should also be able to select Calculated Distance if you have selected distance search option.

 

image.png.df25481cab01d213751d0a9640d1773e.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×