Use URL from a Custom Field as a Short Code to form an Active Link

I’m hoping to create an Active link in a listing using a Short Code that is generated from a Custom Field.

I notice that its possible to customize listing pages with short codes including short codes generated from custom fields.

However when I try to do this ‘a href=”[URL_shortcode]”>[linkname_shortcode] /a>’ the resulting URL is broken. If it were possible to create this kind of link from a URL stored in a custom field, that would be very handy.