How can I make a clickable URL on my accounts page that gets calculated from the value of another field?
We have the Professional Edition of ZoHo CRM.
I'd like to have a clickable link on the accounts page that incorporates parts of the content of other fields.
I've generated the URL using a formula, but it's not clickable.
I tried to use a workflow rule to update a separate URL field with the contents of the formula field by using ${Accounts.CalculatedURL} as the update value, but I get "Please enter a valid Value to Update." I've also tried using the formula used to calculate the URL there, instead. I've tried the same thing with Field Update Actions.
Is there something I'm missing, something else I can do?
It seems like maybe a Webhook could call a function in the cloud somewhere that would make an API call back, but that's a lot of overhead and complexity. I think I could probably do it in ZoHo Sheets, but I'd have to refresh it by hand periodically.
Is there a way to do this within the context of ZoHo CRM without relying on external code or manual processes?