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 |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |