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!
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]”]
}
}
}
]
}
