HTML Example of URL
First, create two ‘single line of text’ columns, each containing the following text as default value
Then, I have two versions of syntax you can use. Make sure you change “The data type returned from this formula is:” to Number (1, 1.0, 100) This will convert your column to html.
Calculated Column Version 1
="<a "&jscript1&""&FileName&""&jscript2&" href='#' title='Title' target='_self'><img src='"&Thumbnail&"' alt=''></a>"
Calculated Column Version 2
=CONCATENATE("<DIV><a ",jscript1,"",FileName,"",jscript2," href='#' title='book' target='_self'><img src='",Thumbnail,"' alt=''></a></DIV>")
So from the examples above, each “jscript” column will be replaced with it’s code and which will use the “FileName” column as it’s URL.
Any questions if it doesn’t work and would like assistance, please comment below.