On sharepoint 2013 I have a list and one of the field is a Link and picture field, we use this for links only. I would like to set the description to some text e.g. "Click Here" whenever there is a link set in the field e.g. not blank. this should override anything the user may have entered for the description, not the link itself.
This is so we don't have long links showing in the list.
Can this be done in items validation field or else where?