How do I format a SharePoint list column input to complete a URL?

50 viewsSharePoint
0

I am trying to design a list column so that when a user types in the entry the entry is then automatically converted into a URL.  For example, the input is ProjectName and the final column output is https://company.sharepoint.com/sites/ParentSite/ProjectName.  Is this a) possible? And b) if possible how would I go about being able to do this?

Thank you in advance!

Answered question
Add a Comment
0

I hope this approach is useful for you:

You should have 2 columns, Title (Título, in my case) and URL.

The URL (use a text column, idk why do not work with the hyperlink) has a div, which shows an icon. The icon URL with the specified URL (in this case: https://www.google.com/search?q=), and concatenate with the title field text ([$Title] / ProjectName).

{
  “$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
  “elmType”: “div”,
  “style”: {},
  “attributes”: {},
  “children”: [
    {
      “elmType”: “a”,
      “style”: {
        “font-size”: “2em”,
        “text-decoration”: “none”
      },
      “attributes”: {
        “class”: “ms-fontColor-themePrimary”,
        “iconName”: “World”,
        “target”: “_blank”,
        “href”: {
          “operator”: “+”,
          “operands”: [“https://www.google.com/search?q=”, “[$Title]”]
        }
      }
    }
  ]
}

Edited answer
Add a Comment
>