Forum Discussion
Solved
List Form Formatting - can't get title and hyperlink from Hyperlink column
I have a Hyperlink column and trying to display it within the footer of the List Form using JSON formatting. However, I can't seem to split the Title and URL of the Hyperlink value. If I just try...
Hi grant_jenkins, You are right; the Hyperlink column value behaves differently in column formatting compared to form formatting.
Fortunately, you can use the following function to retrieve Hyperlink column information in form (header or footer) formatting:
- Url
"txtContent": "=substring('[$FieldName]',0,indexOf('[$FieldName]', ','))"and title
"txtContent": "=substring('[$FieldName]',indexOf('[$LinkTest]', ',')+2,indexOf([$FieldName] + '^', '^'))"
Hi michalkornet
i'm not entirely sure what I need to do. Do I need to add column formatting AND row formatting?
i'm not entirely sure what I need to do. Do I need to add column formatting AND row formatting?
Hi LauraDaisy, in the last post, I meant that the column formatting works, but unfortunately, it is not working in view formatting.