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.
