Morning everyone,
I was wondering if I am able to use the expression builder to create a hyperlink that would open a network folder.
I have uploaded an excel spreadsheet with the current paths and made that field a hyperlink field, which works. But if we add a new practice unless we copy and paste the folder path into the field it will not be there.
I want to use the expression builder to pull from the fields on the table to create that path without having to copy and paste it. (if that makes sense)
Currently i have: =("\" & [TOMCAT SERVER Name] & "\d$\eClinicalWorks\tomcat6_" & [Practice Code] & "\webapps\mobiledoc\jsp\catalog\xml") which gives me the path, but nothing happens when i click on it.
\\ecli\d$\eClinicalWorks\tomcat6_XXXX\webapps\mobi ledoc\jsp\catalog\xml
Can someone help me or explain why the link is not working via expression builder? I have set the field to be Hyperlink always.
Is there a way I can insert the expression on the table?
Thank you in advance.