Convertir URL

[AVista]

Hello, I ask for your help regarding the Appsheet,
let me explain:
In my database a Sheets spreadsheet, I have a column 'Place ID Lieu' which the establishment ID, in another column I have this function:
=IF(R3>"";HYPERTEXT_LINK("https://www.google.com/maps/search/?api=1&query=Google&query_place_id="&R3;B3);"")

to get :
https://www.google.com/maps/search/?api=1&query=Google&query_place_id=ChIJZw5H3Xjr0BIRUpBAi9-RQZ0

In AppSheet :
I tried this kind of conversion to make it a URL
HYPERLINK(
CONCATENATE(
"https://www.google.com/maps/search/?api=1&query=Google&query_place_id=",
ENCODEURL([Place ID Place])
),
("Search for " & [Link] & " on Google")
)
But that does nothing. I specify that I start with AppSheet

Thank you for your help

[Aurelien · Accepted solution]

Yes, and for the location this is as simple also: just provide the address, the Google Maps button will be available automatically.

---

@Aurelien wrote:

Also:

Since it seems you wish to use Google Maps, if you have the address you can select the type Address. That will automatically create the action for opening a map view, with two action buttons: one for seeing the map, the other one for seeing the route to the destination.

---

Moreover, if the address is empty, then the google maps button won't be displayed.

---

@AVista wrote:

What if I have an empty Place ID? not to display the button

---

You may want to add a show_if condition to your column: 

ISNOTBLANK([Place ID])

For reference:

Conditionally show or hide a column value (Show_If) - AppSheet Help