Field to open a folder

Question

I need to create a field in CRM that has a link to project folder on the file server. 
 We have a field in CRM called Project Number. The project number is 2-xxxx (four digit number). 
 On the file server we have projects listed starting with the same 2-xxxx number followed by a description. So 2-1234 My Project. 
 The link in the field would then look like \servername\projects\2-1234. The \servername\projects\ bit is always the same and the 2-1234 bit is taken from the project number field. The user clicks it and it opens the folder of the relevant project. 
 Is this easy to achieve?

Guy Cecil · Answer

Easy enough. I'm assuming that everyone is on the same local network as the file server so it is just a matter of creating a UNC path. There are a number of ways that you can achieve this; probably the best is to create the UNC path when you create the project record by way of a tablescript that updates the field based on the reference. When is that created? In regards to then displaying this as a hyperlink, this is slightly more tricky because you can't easily use a hyperlink field type as CRM insists on putting http in front of it, which wouldn't be correct for a UNC path. You would have to check whether this happens after a tablescript; I don't know that. If you use a SQL trigger instead then you will bypass that problem. You would have to make the field read-only to make sure that nobody changed it otherwise you would then definitely have the http problem.

Sage CRM

Field to open a folder

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING