Link to URL formatter with the display text from another column
20 June, 2014
Hi. I have a field called PermitID which I want to use with the Link To URL formatter. I have entered in the URL of "javaScript:RedirectToPermitGeneralDetails('##');" and what I would like to do is use display text from a different field i.e. Permit Name. It would be good to have a pull down with options in the Display Text so that I can choose a different column to use as the display text. Even better would be to allow use of some special characters to indicate that it is a different field i.e. {{Permit Name}} to allow multiple fields to be shown if desired. Also the data would probably need to sort on display name instead of the column data.
Regards,
Michael
Regards,
Michael
Hi Michael,
Thanks for the idea, but I do know we will not be supporting this method in any future releases.
Reason being, you should be able to do this via a calc field in Yellowfin.
Just create your calc field, similar to below;
[code]
JavaScript:RedirectToPermitGeneralDetails('++');"
[/code]
In terms of sorting the column, I would have thought it would be sorting via the displayed value and not the raw data.
Is this not the case?
Please let me know I have misunderstood what you're trying to achieve.
Regards,
David
Thanks for the idea, but I do know we will not be supporting this method in any future releases.
Reason being, you should be able to do this via a calc field in Yellowfin.
Just create your calc field, similar to below;
[code]
JavaScript:RedirectToPermitGeneralDetails('++');"
[/code]
In terms of sorting the column, I would have thought it would be sorting via the displayed value and not the raw data.
Is this not the case?
Please let me know I have misunderstood what you're trying to achieve.
Regards,
David
Hi David,
Ok, no problems. Currently we are just using it in a freehand SQL query so it works at the moment.
No, it sorts based on the raw data as displayed below.
Permit Number Ascending Sort
Without Hack
Raw Formatter
As you can see by looking at the above, SBI-WP-9007 is displayed before SBI-WP-8999 because the internal ID is smaller and the internal ID is what is used first in the HTML code.
To get around this we are putting a dummy HTML comment in that lists the number component of the display and the revision number so that they are the first unique parts of the HTML and therefore it sorts on that instead of the internal ID.
This is the code to achieve this [code]'' + p.DisplayName + '' [Permit Number][/code]
I'm using the HTML5 postMessage feature now because browser security didn't allow me to do it with JavaScript.
Regards,
Michael
Ok, no problems. Currently we are just using it in a freehand SQL query so it works at the moment.
No, it sorts based on the raw data as displayed below.
Permit Number Ascending Sort
Without Hack
Raw Formatter
As you can see by looking at the above, SBI-WP-9007 is displayed before SBI-WP-8999 because the internal ID is smaller and the internal ID is what is used first in the HTML code.
To get around this we are putting a dummy HTML comment in that lists the number component of the display and the revision number so that they are the first unique parts of the HTML and therefore it sorts on that instead of the internal ID.
This is the code to achieve this [code]'' + p.DisplayName + '' [Permit Number][/code]
I'm using the HTML5 postMessage feature now because browser security didn't allow me to do it with JavaScript.
Regards,
Michael
Hi,
I have two columns: client_id and Client Name. I can easily reach the client page with The URL https://www......files.aspx?client_id=## from client _id column. But I want to hide client_id column and be able to click Client Name to reach client's web page.
Is that possible to do? I am using Yellowfin 6.3
Thank you
I have two columns: client_id and Client Name. I can easily reach the client page with The URL https://www......files.aspx?client_id=## from client _id column. But I want to hide client_id column and be able to click Client Name to reach client's web page.
Is that possible to do? I am using Yellowfin 6.3
Thank you