Apps Help with making wtai://wp/mc;XXX work for broswer

[rleal2010]

Here is what i'm trying to do.

I'm making a rolodex online using google spreadsheet.

I embedded the spreadsheet on google sites as a list.

I want to be able to make a phone number click-able.

I have played with both ends of the phone and the google application.

However the only thing that works in my android phone is this code in the browser
wtai://wp/mc;XXXXXXXXX where X=a digit from a 10 number phone number.

The code will open up the dialer and enter the number XXXXXX perfectly! However I'm having trouble loading that code from a google document as a link to the address bar.

I know hyperlinks work in the google document because I can add a hyper link as so:

=HYPERLINK("google.com","Google")

or to open up my mail client and address it to someone

=HYPERLINK("mailto:XXX@gmail.com","Send an Email)


Technically to make a phone number put in cell A1, the code would be

=HYPERLINK("wtai://wp/mc;&$A1&", "Click to Call")

but its not working!!!

 

[cp1]

I have no idea, but make sure you don't need to escape any of the characters you're using.

 

[rleal2010]

I figured it out.

IN the spreadsheet, I entered a hyperlink that connected to a website i created in weebly.com

the website (for example) was

=HYPERLINK("www.weebly.com/?wtai://wp/mc;" &$A1&"", "Call number")

Well A1 was the phone number in which would be transfered to my weebly website.In this case, the phone number i will attempt to dial is 888-8888


So now that we have made the hyperlink, at weebly.com, i inserted a script that would take the address after the "?" and redirect me to it.

Thus redirecting me to wtai://wp/mc;"8888888"

When when i access my spreadsheet on google docs on my android,

I click on the hyperlink that says "Call number", it will take me to my custom webpage that WILL load 888-8888 to my dialar, and all i have to do is press the call button.