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

You cannot set default value using JSON Formatting. To create a hyperlink using JSON Formatting, use below JSON:

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
   "elmType": "a",
   "txtContent": "Click to filter list view",
   "attributes": {
      "target": "_blank",
      "href": "='https://abc.sharepoint.com/lists/test/allitems.aspx?FilterField1=MasterID&FilterValue1=' + [$ID]"
   }
}

Answer 2

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]"
  }
}

Here is a similar case for your reference:

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

========================== Updated Answer ======================

If you want to display the Hyperlink's URL and Alternative text in the Display Form.

Please following steps:

1.Create the following columns in the list

• TestID: Single line of text (TestID must be equal to ID)
• MasterID: Single line of text
• PrimaryName: Single line of text
• PrimaryURL: Calculated (calculation based on other columns)

Formula:

=CONCATENATE("https://***.sharepoint.com/sites/sitename/Lists/listname/AllItems.aspx?FilterField1=MasterID&FilterValue1=",[TestID])

• TestLink: Single line of text

2.Column Formatting

3.Paste the following code:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "txtContent": "[$PrimaryName]",
  "attributes": {
    "target": "_blank",
    "href": "=[$PrimaryURL]"
  }
}

4.Hide Column