For example, if I try to put the URL ...

http://creator.zoho.com/liamzoho2/tests

into a CRM formula field, it doesn't accept it...but using the Concat function it works OK...

Concat(' http://creator.zoho.com/liamzoho2/tests') 

This isn't clickable, but if I select it and right mouse click within the Chrome Browser, it takes me to that web address (so...it's 'almost cliackable')...which I think is reasonably useful (obviously, it would be nicer if it is clickable....BUT...when I try this URL...

Concat(' http://creator.zoho.com/liamzoho2/tests/#Form:Test_HTML_View_Form')

which as you can see contains a '#', the syntax checker for the formula field objects strongly to the '#'. This is disappointing given that Zoho Create apps use this '#' in virtually all of their application URLs.

I have tried various combinations to 'neturalise' the # key (using a backslash to quote it) in the following way...

I even looked at URL encoding...but that didn't work either.

Thank you,

Liam