Collect multiple link columns into one column

Modified on Fri, 15 Mar 2024 at 03:28 PM

If you have multiple columns with different links, you may want to show them all in one general column for better readability:

To do so, the last column should be configured in the following way:

...
 {
         "headerGroup":"Potential Failure",
         "headerGroupCss":"headPotentialRisks",
         "headerCss":"headPotentialRisks",
         "header": "Items",
         "width": 150,
        "serverRender":"<b>aa</b>",
        "formula":"items",
          "id":"items",
         "cellRenderer":"items",
         "filterable":true,
         "level": 1
      },
...

The formulas should be the following, considering that item, item2, and item3 are the IDs of the first 3 columns with links:

...
"formulas":{
 "items":"(info)=>{return (info.item.item_link?info.item.item_link+'<br>':'')+(info.item.item2_link?info.item.item2_link+'<br>':'')+(info.item.item3_link?info.item.item3_link:'');}"
   },
 "cellDecorators":{
     "items":"(info)=>{info.cell.innerHTML = info.cell.innerText}"
},
...