I have a list in my SharePoint Online site. The list has a single line of text column for email address. I want to make the values in this column clickable so that when a user clicks on the value it opens in Outlook. This is possible if a column is "Hyperlink" type but not if it is "Single line of text".
I have noticed that if a column is single line of text and you add a email address and open it with "Quick Edit", the value in the field is [email protected]. So, the email should be clickable but when you click on the link, nothing happens.
Do you know if there is a script that can be added to enable this functionality?