Conditional Formatting to show multiple hyperlinks on one field

%3CLINGO-SUB%20id%3D%22lingo-sub-1584954%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20to%20show%20multiple%20hyperlinks%20on%20one%20field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584954%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20if%20the%20following%20is%20possible%3F%3C%2FP%3E%3CP%3EI%20have%20a%20list%20in%20SharePoint%20Online%20storing%20the%20domains%20that%20are%20owned%20by%20the%20company.%20Against%20each%20one%20I%20want%20links%20to%20open%20various%20hyperlinks%20to%20test%20if%20the%20domain%20is%20set%20up%20correctly%2C%20or%20run%20tests%2C%20get%20WHOIS%20info%20etc.%20Currently%20I%20have%20added%20text%20columns%20for%20Domain%20Check%2C%20Whois%20and%20WWW%20Link%20that%20have%20no%20content%20and%20just%20generate%20the%20hyperlinks%20based%20on%20the%20column%20format%20JSON%20referring%20to%20the%20Domain%20Name%20field%20(Title).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22domains.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212083i2A60FCBCD0FEFB60%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22domains.png%22%20alt%3D%22domains.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhat%20I%20would%20like%20to%20do%20is%20have%20a%20single%20field%20called%20Actions%2C%20that%20contains%20multiple%20'nicely%20formatted'%20hyperlinks%20(coloured%20pill%20format%20would%20be%20great)%20that%20are%20automatically%20generated%20based%20on%20the%20Domain%20Name%20field.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20find%20any%20samples%20showing%20this%20although%20I'm%20sure%20some%20clever%20person%20can%20provide%20the%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20reference%2C%20I'm%20using%20the%20following%20column%20formatting%20to%20build%20the%20domain%20check%2C%20whois%20and%20WWW%20link%20fields%20hyperlinks%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3CU%3E%3CSTRONG%3EDomain%20Check%3A%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-json%22%3E%3CCODE%3E%7B%0A%20%20%22elmType%22%3A%20%22a%22%2C%0A%20%20%22txtContent%22%3A%20%22Domain%20Check%22%2C%0A%20%20%22attributes%22%3A%20%7B%0A%20%20%20%20%22target%22%3A%20%22_blank%22%2C%0A%20%20%20%20%22href%22%3A%20%22%3D'https%3A%2F%2Fwww.mxtoolbox.com%2Fdomain%2F'%20%2B%20%5B%24Title%5D%22%0A%20%20%7D%0A%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3CU%3E%3CSTRONG%3EWhoIs%3A%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-json%22%3E%3CCODE%3E%7B%0A%20%20%22elmType%22%3A%20%22a%22%2C%0A%20%20%22txtContent%22%3A%20%22WHOIS%22%2C%0A%20%20%22attributes%22%3A%20%7B%0A%20%20%20%20%22target%22%3A%20%22_blank%22%2C%0A%20%20%20%20%22href%22%3A%20%22%3D'https%3A%2F%2Fwho.is%2Fwhois%2F'%20%2B%20%5B%24Title%5D%22%0A%20%20%7D%0A%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3CU%3E%3CSTRONG%3EWWW%20Link%3A%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-json%22%3E%3CCODE%3E%7B%0A%20%20%22elmType%22%3A%20%22a%22%2C%0A%20%20%22txtContent%22%3A%20%22%3D'www.'%20%2B%20%5B%24Title%5D%22%2C%0A%20%20%22attributes%22%3A%20%7B%0A%20%20%20%20%22target%22%3A%20%22_blank%22%2C%0A%20%20%20%20%22href%22%3A%20%22%3D'http%3A%2F%2Fwww.'%20%2B%20%5B%24Title%5D%22%0A%20%20%7D%0A%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlex%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1584954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hi,

 

Wondering if the following is possible?

I have a list in SharePoint Online storing the domains that are owned by the company. Against each one I want links to open various hyperlinks to test if the domain is set up correctly, or run tests, get WHOIS info etc. Currently I have added text columns for Domain Check, Whois and WWW Link that have no content and just generate the hyperlinks based on the column format JSON referring to the Domain Name field (Title).

 

domains.png

What I would like to do is have a single field called Actions, that contains multiple 'nicely formatted' hyperlinks (coloured pill format would be great) that are automatically generated based on the Domain Name field.

 

I can't find any samples showing this although I'm sure some clever person can provide the answer.

 

For reference, I'm using the following column formatting to build the domain check, whois and WWW link fields hyperlinks:

 Domain Check:

{
  "elmType": "a",
  "txtContent": "Domain Check",
  "attributes": {
    "target": "_blank",
    "href": "='https://www.mxtoolbox.com/domain/' + [$Title]"
  }
}

 WhoIs:

{
  "elmType": "a",
  "txtContent": "WHOIS",
  "attributes": {
    "target": "_blank",
    "href": "='https://who.is/whois/' + [$Title]"
  }
}

 WWW Link:

{
  "elmType": "a",
  "txtContent": "='www.' + [$Title]",
  "attributes": {
    "target": "_blank",
    "href": "='http://www.' + [$Title]"
  }
}

 

 Thanks in advance.

 

Alex

0 Replies