Appsheet Episode 95: How to calculate distance between two points. FREE Method!

Welcome to my tutorial on calculating the distance between two addresses in Google Sheets using the OpenRouteService API! In this step-by-step guide, i'll show you how to:

1)Set up your Google Sheets with addresses.
2)Use Google Apps Script to call the OpenRouteService API.

Join this channel to get access to perks:

[justfateh]

Thank you from algeria, as always your tutorials are very helpful. 😊

[matiasromero]

Buenos días desde Argentina, gracias por aportar conocimientos, saludos

[abdibox]

Sir, can I ask a question?
I have a problem working on an application creation project via Appsheet. The problem is, I was told to create a data input application via Appsheet but the format for a spreadsheet already exists, and I'm confused about how to enter the existing spreadsheet?
please help sir

[RaghuramanR-yh]

In the Appscript you've provided, can you pls confirm if the for loop is supposed to start from 1? I'm quite confused - Why? Array starts from 0 only right?. Or is it just a small mistake and I'm overthinking myself

[tangkeefong]

Hi! Do you have any tutorial for example a data sheet has been created, but some how column A already have user email while new data created, but if column C has been edit by third party, in column D i need to know who user email who is edit?

[cmsaskrindomedan]

Can you make tutorial API fot Face detection in appsheet?

[bahaaomar]

How to retain the current value entered in a specific field of a form when saving and reopening it in AppSheet form ?

[עמירצין]

Could be nice to be able the app to create different routes for picking up and drop off packages

[eronwah]

Thank you so much for this wonderful tutorial from PH,
May i ask if is it possible to have a dependent selection and link it to different kind of form views?

[Name-smns]

hello I love all your videos it's so helpful!
Can you make a video on how to do mail merge from appsheet to docs if it's possible please

[lankanlight]

I checked your videos, but I could not find any notification related video tutorial.
I am unable to send notifications.
emails can be sent.
I tried many times. process status is completed but I did not receive notification.
Please let me know how to do it. thank you

[mahrizo]

Friends, I use AppSheet to track prospecting activities.

- I want to set up a visit counter that updates each time the "last visit" field is changed.
- Also, how can I create a "last visit" button to input the date of this visit?
- Additionally, I need a formula to track the date of the last change in status (active, blocked, etc.).

Can you help me ?

[Dronebelawan]

Thanks Sir, I would like to ask you how to capture location every certain period of time automatically. Every period of time (5 minutes) will change the current lat long location. Thanks

[henrykang]

Hi do you do appsheet commission work? I need some support for an app. I tried emailing but thought I would also try to leave a message here. You're videos are great, btw!

[denisdinizyt]

Aris, obrigado por todo seu conhecimento. Sou brasileiro e admiro seu trabalho. Por favor, me ajude. Sou iniciante em Appsheet e estou criando um sistema de agendamentos onde preciso programar clientes recorrentes, que aparecem semanalmente. Gostaria de pedir para criar um vídeo explicando looping para agendamento semanal, quinzenal e/ou mensal para clínicas. Novamente, obrigado pelo compartilhamento e fico na esperança de poder me responder.

[raulianilham]

Sir, can you please make a video, about make login for AppSheet app using Apps Script and spreadsheet, I've been working for a week and none of my single experiment are work 😂, Thank you