Hello everyone,
After several hours of searching the forums for a solution, I still don’t have a solution to my problem.
I created an App with a GPS geolocation function and a script that transforms the position into a full address.
One column is dedicated to the full address and another column extracts only the city.
This is the city name that I would like to use for the email header and display in the app.
When I have finished encoding and the app updates the Googlesheet database, the name of the city and the full address appears in the APP but not in the email sent.
I wanted to use the “wait” functionality before sending the email with the condition that a city is in the column but during bot processing, the incomplete data received is not updated when the city column fills up. The email never sends as the condition is not met and does not receive the update.
How can I make the process, when creating a new entry only, wait for the City column to fill before sending an email?
Is it possible to have a task that would run in the background even without refreshing the App to be able to send an email as soon as a city name is in the “city” column?
The problem probably comes from using a bot to call the script (GeolocationToAdress) once the App has been synchronized.
Is there another solution to transform LatLong coordinates into Address and then send the result by email with the rest of the form?
EDIT:
I found a solution.
By adding the action of sending an email following the creation of the address with the GPS coordinates, the email is sent while waiting for the recorded data.
I had to put everything in the same bot for it to work.
Thanks in advance