You need to sign in to do that
Don't have an account?
beentohell
custom button with formula
Hi,
I am new to salesforce. I tried to search board, i was not able to find any solution.
I tried to create custom button to validate EU vat number. I have a field where Vat number inserted in this format: EU999999999999. to validate i have to separate first two letters and the rest. Tried this, but it is not valdiating.
Could you please help with this?
http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms={!LEFT( Account.VAT_number__c,2)&vat={!MID( Account.VAT_number__c ,3,12)}
Please help!
Thanks.
I just tried creating a detail page button in my sandbox with this URL and it worked:
http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms={!LEFT(Account.VAT_number__c,2)}&vat={!MID(Account.VAT_number__c,3,12)}
All Answers
You're missing a closing } at the end of the first parameter:
http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms={!LEFT( Account.VAT_number__c,2)}&vat={!MID( Account.VAT_number__c ,3,12)}
Hi Klam!
But it didn't help. When you click on the link it gives this result.
http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms={!LEFT(Account.VAT_number__c,2)}&vat={!MID(Account.VAT_number__c,3,12)}
http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms={!LEFT(Account.VAT_number__c,2)&vat={!MID(2,length(Account.VAT_number__c))}
Thanks
Utsav
I just tried creating a detail page button in my sandbox with this URL and it worked:
http://ec.europa.eu/taxation_customs/vies/viesquer.do?ms={!LEFT(Account.VAT_number__c,2)}&vat={!MID(Account.VAT_number__c,3,12)}
Thank you, Klam!! It is working!!!