openocean Posted July 19, 2017 Report Share Posted July 19, 2017 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. Quote Link to comment Share on other sites More sharing options...
0 Franchiser Posted October 25, 2017 Report Share Posted October 25, 2017 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. Quote Link to comment Share on other sites More sharing options...
0 MayMusic Posted January 5, 2018 Report Share Posted January 5, 2018 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. Quote Link to comment Share on other sites More sharing options...
Question
openocean
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.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.