Changing the EntryType for Fields in an External Table

Dear Jeff,

This post is great, but I have an issue.

Please consider that the external table field is numeric, and it has two possible values 0 or -1.

In that case when I access to the fields data of linked database, I cannot change field type in this case.

In connected view I created a field Yes/No based on 0/1 using case sentence, and defined that field as nchar(40), but when I access the fields data of linked database, also doesn't allow me to change to field type selection. It looks like only existing table text fields can be changed to selection type.

Is there any way to bypass this issue?

Thanks & Best Regards,

Hi Jeff,

I had tried your suggestion but appear not working. I tried again today (and surely because of IISReset or whatever) now I could change field type to selection. So now it's working nice!

Thank you very much for your support!

Hi Jeff,

I created a view and added a column called 'Action' with the option "Show Select as Gif" = YES. I Create 3 folders with GIF files inside on the paths u indicated but none of this seem to work. Do u have a clue of what i'm missing?

Thanks

•C:\Program Files\Sage\CRM\[installname]\WWWRoot\Themes\Img\default\Choices\Action

•C:\Program Files\Sage\CRM\[installname]\WWWRoot\Themes\Img\color\Choices\Action

•C:\Program Files\Sage\CRM\[installname]\WWWRoot\Themes\Img\neutral\Choices\Action

I have successfully added a custom table and have a WWW URL file path link similar to above which opens a PDF in another tab when I click on it. I would prefer to display a GIF (such as the paperclip) instead of the full URL as it is so long. So I want the same GIF for all the values. Is there a way to do this please? I could add a second field with a fixed value "Click Here" and display that but I don't know how to make this field clickable so that it invokes my WWW URL of the file path for that row. I am using 2017 R2.

Thanks, Mark.

Hi Jeff and thanks for responding. No, sorry that's not what I meant. What I want to do is just show a GIF of the paperclip (for example) against each row of my data and when that GIF is clicked on I want to open the WWW URL in my filepath field for that row. This opens a PDF related to that row. So the GIF does not change but the filepath does. I want to hide the filepath as it takes up so much space on the list view and its actual value is not important to the user. Is this possible?

Thanks Jeff. I looked at those articles and some others I had found, discussed with some colleagues and I then came up with this solution which replaces the filenames with the paperclip icon. It uses a custom jump pointing to paperclip.js saved in the wwwroot/js/custom directory:

crm.ready(function () {

var contextInfo = crm.getArgs();

//Set up Filenames List

if (contextInfo.Act == "115") {

//Identify the Filename Column

var columnFilename = crm.grids(0).columnIndex("filename");

//Loop through each Filename that is not blank

crm.grids().filterWhere("filename", "ne", "").exec(function (index, key) {

var rowIndex = $(key).parent().index() - 1;

//get the html of the Filename cell

var columnFilenameHTML = this.getCellHtml(rowIndex, columnFilename);

// modify the HTML so the entry points to the system Paperclip image (T.gif)

var strImage = columnFilenameHTML.substring(0,columnFilenameHTML.indexOf("EWAREVISITS")+13) + "<img alt=" " />" + columnFilenameHTML.substring(columnFilenameHTML.lastIndexOf(""));

//crm.grids().setCellText(rowIndex,7,strImage);

this.setCellHtml(rowIndex, columnFilename, strImage);

})

}

});

The strImage definition does not show correctly in my post, not sure if the number of quotes is throwing the web form. Here is it again:

var strImage = columnFilenameHTML.substring(0,columnFilenameHTML.indexOf("EWAREVISITS")+13) + "<img alt=" " />" + columnFilenameHTML.substring(columnFilenameHTML.lastIndexOf(""));

It is the web form - I'll try again, the "img src" = should be followed by \ then " then " not just the one " shown here:

var strImage = columnFilenameHTML.substring(0,columnFilenameHTML.indexOf("EWAREVISITS")+13) + "<img alt=" " />" + columnFilenameHTML.substring(columnFilenameHTML.lastIndexOf(""));