Created an custom field on Opportunities that gives the ID of that Opp in our ERP system. That custom field is a text field and its ID in Salesforce is Odoo_ID__c.
Now, I'm trying to create another field with a link. I've used a formula -> text field with the following line:
"https://aggreco.opencloud.pro/web#.id=" + Odoo_ID__c "&view_type=form&model=crm.lead&action=414&active_id=1"
Basically I want to replace the fixed Id with the one on the custom field. Above formula gives me an error. Can you please help me on this one?
Thanks.
2 件の回答
Hi Alex, Try this:
HYPERLINK("https://aggreco.opencloud.pro/web#.id="&(Yourfield)&"&view_type=form&model=crm.lead&action=414&active_id=1", "Aggreco Link", "self")
Replace Yourfield with your merge field and change Aggreco Link to whatever you want to display on the field.
