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

[Aurelien]

Bonjour @AVista 

You have a type URL in AppSheet:

No need to use a Hyperlink expression, unless you are willing to send an email with a hyperlink inside.

For reference:

Column data types - AppSheet Help

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.

[AVista]

Thank you for your reply,
I tested Address and URL, the link I make with the two columns in my sheet. The 1st column 'Link' and the 2nd column 'Place ID Place'
Link: https://www.google.com/maps/search/?api=1&query=Google&query_place_id=

Place Link ID: ChIJczdp8j2P2RIRcxHrS06tM84

To obtain in my my sheet a single establishment:

https://www.google.com/maps/search/?api=1&query=Google&query_place_id=ChIJczdp8j2P2RIRcxHrS06tM84

I tried in AppSheet, Url, Address; I can't find a way to make with my two fields the URL that returns to Google Maps.

Thank you for your help

[AVista]

Here are my two fields with which I want to make a URL of this type:

https://www.google.com/maps/search/?api=1&query=Google&query_place_id=
ChIJczdp8j2P2RIRcxHrS06tM84

[Aurelien]

I'm not sure of understanding properly.

You mean, you wish to get the url in the sheets, or having it available in the app?

[AVista]

In Google Sheets, I build a link with two cells to get this link: https://www.google.com/maps/search/?api=1&query=Google&query_place_id= concatenate with Place ID column Place: ChIJudY0my1q2hIRy1EtRlovLIo

I wanted to do it without a hidden column in Sheet to get the full link. and In APPSHEET I wanted to do the same thing, I found by doing an action with a menu button as shown in my print screen.

[Aurelien]

ok. I suggest you make it simple 🙂

Add a new virtual column, type: URL.

Expression: 

"https://www.google.com/maps/search/?api=1&query=Google&query_place_id=" & [Place ID]

 That will automatically create an action button for the hyperlink part.

[AVista]

Good morning,
Thank you for your comeback. As simple as that. Finally I have two solutions. What if I have an empty Place ID? not to display the button

[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

[AVista]

Thank you for your valuable help and answers.
I take the opportunity to ask you another question regarding please, because I did not find anything on the subject.

I would like to return my Tel field, when I work on a Windows 10 = PC, and my smartphone is synchronized with the 'MOBILE CONNECTE' application

How to make a direct call from the pc to MOBILE CONNECTE?

[Aurelien]

always simple: just set the phone column with type Phone 🙂

[AVista]

When I want to call on my Windows PC,

Appsheet directly opens the default browser in my case Chrone and only offers me Skype.

I would like to open the application (Mobile Connected) of Windows on my computer?

Is it possible ? Thank you

[Aurelien]

Hi @AVista 

would that do the job?

I droped using mobile connecté as I went out of patience on my own computer a while ago ^^'

[AVista]

Google Voice, is not available in France.
For the moment I do not want to use Skype, and as my smartphone is synchronized with the PC Widnows I would like to use from Appsheet (MOBILE CONNECTED)?
I can't find what to do?

[Aurelien · Accepted solution]

What if you use your AppSheet mobile app directly?

Unfortunately I can't help you more on the topic of syncing phone and computer, this is beyond my AppSheet skills here. I will stop on this topic, if you got the answer you were looking for, this is good from my point of view.