Can i define a default value for a HyperLink site column to include the item ID

Question

i have the following column of type Hyperlink and i want its default value to include a url with the Id of the item, i tried to define the format inside the JSON but it did not work, as follow:-

So can anyone advice how i can define a default value for a HyperLink site column to include the item ID?

Answer 1

Hello @john john ,

We recommend that you create a Single line of text column and then convert this column into hyperlink formatting.

Please the following steps:

1.Create a Single line of text column in the list

2.Format this column

3.On the Formati column panel, click on Advanced mode

4.Use the below JSON:

{  
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",  
  "elmType": "a",  
  "txtContent": "@currentField",  
  "attributes": {  
    "target": "_blank",  
    "href": "='https://****.sharepoint.com/sites/sitename/Lists/listname/AllItems.aspx?FilterField1=MasterID&FilterValue1='+[$ID]"  
  }  
}  

Thanks,
Echo Du

===========================================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

SharePoint hyperlink columns does support the JSON column formatting.

Check list of supported columns at: Supported column types

@john john ,

For answer to your question, check my answer given at: Can I define a default value for a HyperLink site column to include the item ID