Hi, Scott 

Sorry for the delay

To be fully honest with you, i am not sure if i understood all the details exactly and it seems a bit higher then my level of expertise.

You can certainly use custom HTML in the cells of wpDataTables.  Please check out more on how our string columns work here.

But i will have to check with senior colleagues if this is possible to achieve exactly as you described it.

Sorry for the waiting time.

If you could be so kind to perhaps elaborate a bit more, and if you have any example to show us - it will help. Thank you

Hi, Scott 

Sorry for the delayed response

-

Can you please take a look at this video, where my senior colleagues show an example of using SQL Queries in our plugin, to use the CONCAT functionality;

They made an example by adding a URL link, along with some variable values from certain columns through an SQL Query.

I am not sure if we can use placeholder such as %POSTID% in this way , but perhaps this might be useful for you, to devise a workaround, i hope.

Please check out the video here

I will check with senior colleagues again if it's possible to use the POST ID placeholder in the way how you described, thank you for further clarification.

As soon as they respond i will report back again for you.

Thank you for all the patience.

Hi, Scott 

I am glad that this might help achieve what you need at this time.

But i absolutely understand what you mean, this does require certain knowledge of SQL,

it would be much easier to have a built-in feature as you described.

If you can be so kind, please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

Hi, Scott

I just wanted to add something. 

The developers took another look at everything, and they advised me of an alternate way, what you could try, if you wish.

I know we said that the goal was to get to a more user-friendly built-in solution, and this is certainly not that;

but i will pass the workaround anyway, if there is a chance that it might be helpful.

-

You can try making two same columns ( for example post ID  if that is what you need);

then the second column you can set to be String type even though it has numbers,

then you could use a filter,

that you can add in your functions.php file of the theme or child theme;

function wpdatatables_filter_string( $formattedValue, $tableId ){ 
if($tableId != 1 && is_numeric($formattedValue)) {
 return '<a href="https:/mysite.org/' .$formattedValue . '">Link to Post ' . $formattedValue . '</a>';
 } 
return $formattedValue;
}
add_filter( 'wpdatatables_filter_string_cell', 'wpdatatables_filter_string',10,2 );

You would replace tableId == *1*  with ID of your table.

This would be a filter that can 'transform' all the string type cells.

-

 I am not sure if this will help, but just wanted to additionally pass the advise from our developers.

Thank you

Hi Scott 

No problem at all

If you have any other questions, please don't hesitate to open a new ticket.