Hi every one, Need Help!!! I try to make a ...

(Cars Bits) #1

Hi every one,

Need Help!!!

I try to make a hyperlink to google search which search the value of couple of cells from same row in google.

it is working fine on google sheet and here is the format:

=if(Isblank(A5)," ",HYPERLINK("https://www.google.com/search?hl=en&q="&A5&" “&E5&” "&G5,“Google Search”))

but when i click on appsheet link it give me [http://google%20search/]

the column property is follow:

Type = Url LaunchExternal = ture IsHyperlink = ture Read-Only Required Searchable Spreadsheet formula = if(Isblank(RC[-7])," ",HYPERLINK("https://www.google.com/search?hl=en&q="&RC[-7]&" “&RC[-3]&” "&RC[-1],“Google Search”))

What I have done wrong?

your help is much appreciated.

(Steven Coile) #2

Why in the world did you do this using a spreadsheet formula?

(Steven Coile) #3

As an AppSheet formula suitable for use as the app formula of a virtual column:

=IF(ISBLANK([A]), “”, HYPERLINK((“https://www.google.com/search?hl=en&q=” & ENCODEURL([A] & " " & [E] & " " & [G])), “Google Search”))

Replace A, E, and G with the appropriate AppSheet table column names.

(Cars Bits) #4

Thanks Steve Coile I tried couple of way but still got the same problem I used the column names as follow:

=if(Isblank(RC[Manufacturer Part Nr])," “,HYPERLINK(“https://www.google.com/search?hl=en&q=”&RC[Manufacturer Part Nr]&” “&RC[Model]&” "&RC[Part Name],“Google Search”))

it didn’t work then I changed to this: = if(Isblank(RC[7])," ",HYPERLINK("https://www.google.com/search?hl=en&q="&RC[7]&" “&RC[3]&” "&RC[1],“Google Search”))

still same problem :frowning:

(Steven Coile) #5

I’m afraid I’m not familiar with using spreadsheet formulas within AppSheet, so I can’t help you.