HYPERLINK() returns URL

[Jason_Reynolds]

HI!

This has been an issue for me for a while. The HYPERLINK() funciton seems to not be working for me for some reason. I have tried several simple tests, and even looked at the Sample app, 
https://www.appsheet.com/template/appdef?appName=Hyperlinks-71626&appId=Hyperlinks-71626#Data.Column...

and if you look at the formula 
HYPERLINK([Url], [Link Text])

The expression result is just the URL:
https://www.appsheet.com

Same for my virtual column test.

HYPERLINK("http://www.jinxbot.com","Jinxbot")

returns

http://www.jinxbot.com

The column type is URL and I dont know what I could be missing on such a simple function. I thought it was just me until I looked at the sample app and clicked test on the sample app formula, and saw the same result. This is driving me nutz. I even tested the data in my spreadsheet and was able to create a hyperlink with text in the spreadsheet and the text showed up in the app and was clickable! But the HYPERLINK() function just continues to return the URL and not clickable text. Is there a formatting or settings issue or checkbox I am not seeing? Even if there were, that doesnt explain why the Sample app would also not work correctly. 

[JSO]

The format is:

HYPERLINK("https://www.google.com", "Google")

[Jason_Reynolds]

Thank you for responding. From my post, you can see that I do have an understanding of the correct format. 

To give an update. I went back to the app example I listed above and tested it again, and the expression result was still just the URL and not the clickable text.
HYPERLINK("https://www.appsheet.com","Build an app")  -> https://www.appsheet.com

I have been working with appsheet functions for the past 3 to 4 years now and have not had this much trouble with any other function. I am quite embarrassed as this is a fairly simplistic function. 

In my app I am looking at older rows and see that the hypertext is still just the full url, however I just did an import and for some reason I see the HYPERLINK() function working to some extent. 

For anyone else having trouble, I am having the HYPERLINK() function generate as a formula in a URL type Column, and builds a link from some other column data. Then there is an import Action I built that takes that generated link along with other column data, and puts it in another table. The column that the generated link gets imported to is also a URL type column. For years this process just yielded the full URL, I fiddled with the code a lot last night and the old URLs would never update, however in creating new records, it seems to be working now. My first thought was it wasnt updating because it was the new table, but then I went to the first table where the link was being created from the other column data, and that also wasnt updated. I kept testing the formula in the formula builder and it would never work correctly. 

[benthesheep24]

I'm having exactly the same issue. I'm trying to add a link with URL text into the body of a chat message, but however I test it (e.g. <<HYPERLINK("www.google.com","Google")>>, the output is the URL, not the text (in this example, "www.google.com" rather than "Google" as it should be.

Unless anyone has any suggestions for the format (or can suggest what I'm , this seems to be an issue with the HYPERLINK function in AS.

[Jason_Reynolds]

Thanks for replying. I somehow managed to get it working, but I have no idea how. I just fiddled with it for hours, redoing the same formula. Every time in the preview and test window it would just be the url. and I would check the app and again, still be the url, then I had to sleep and put the problem down for a bit. Without changing anything, I opened up the app the next day and lo, the url displayed correctly. I hate having fixed it like this as I dont know what I did wrong to avoid that mistake in the future, or help others solve their issue. Sorry, and good luck!

[peterson]

The HYPERLINK expression won't work if the first parameter is text, it has to be a url column (if you refer to an existing column), or if you enter manually it has to be the correct link.

[benthesheep24]

In my scenario (seems to be different from OP's, but resulting in the same issue), I am trying to add a hyperlink to a chat message. Could you suggest how to properly use the expression as a variable in this context?

https://support.google.com/appsheet/answer/10107911?hl=en says: "HYPERLINK("https://www.google.com", "Google") returns Google", but when I try it it returns "https://www.google.com" instead.