Custom Form - Calculation Field + Dynamic Host
Hi all,
I am using a calculated field to provide a clickable, concatenated Workfront Document Project Link that users can click when it is attached to a document. Currently, the URL’s environment is hard-coded as “my”. I know that $HOST is available for External Lookup fields and can retrieve the environment dynamically, but I’m looking for a way to both build the URL and retrieve the environment value dynamically.
Currently showing:

What I would like to achieve (dynamic environment):

By any chance, has anyone had a similar use case or thoughts they could share?
Thanks!
Wyatt