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.
Why in the world did you do this using a spreadsheet formula?
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.
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
I’m afraid I’m not familiar with using spreadsheet formulas within AppSheet, so I can’t help you.
User | Count |
---|---|
41 | |
27 | |
27 | |
20 | |
13 |