• Kathi
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 2
    Replies
Hi everyone,

We want to create a new custom button on our opportunities, which copies some fields of an exisiting opportunity and adds other values as well. Below is the code, I've generated so far. The problem I have is, that the merge fields are not shown in the newly created opportunity. All other values are entered correctly. I've tried for hours, but i just couldn't make the button work correctly. Your help in this is much appreciated.

Thanks

Best wishes
Kathi

/006/e?retURL=%2F006%3Ffcf&RecordType=012L0000000Crg9&ent=Opportunity
opp4_lkid={!Account.Id}&
opp4_lkold={!Account.Name}&
CF00NL0000002uD17_lkid={!Opportunity.Contact__c}&
conid={!Contact.Id}&
opp3={!Opportunity.Name & ' - Extension'}&
opp5=Extension&
00ND0000005gFYM={!Opportunity.Sector__c}&
opp9={!Today()}&
00ND0000005gFYD={!Opportunity.Opportunity_Number__c}&
opp11=Identify&
opp12=10&
opp7=0&
00ND0000005gFY2=Not Required&
opp6={!Opportunity.LeadSource}&
opp17={!Opportunity.Campaign}&
opp14=Extended Project ({!Opportunity.Description})
  • December 03, 2013
  • Like
  • 0

Hi everyone,

 

we are trying to find a way on adding optional products on quotes. Since you cannot change the quantity to "Zero" we've tried to find a way in displaying "not offered" in the total price for those products. I've created a text field formula, that would work perfectly, if we weren't using 3 different currencies in our company EUR, GBP, USD).


Unfortunately the formula is too long (Error message: Compiled formula is too big to execute (5,341 characters). Maximum size is 5,000 characters).

 

Therefore we need to find a way to shorten it. Unfortunately we've couldn't find a way internally, that's why I'm asking the community.

 

The formula, that needs to be shortened is the following. SP_Q__c is a currency formula field totaling the price of a product incl. any discounts. The formula should convert the number into a text, while keeping the decimals.

 

CASE(Description,

"Optional", "not offered",

 "optional", "not offered",

 CASE( Quote.Opportunity.CurrencyIsoCode ,

"EUR",  ( "EUR"  & " " &

 

IF(FIND(".",TEXT(SP_Q__c))=0, TEXT(SP_Q__c)+".00",

IF (LEN(TEXT(SP_Q__c))-FIND(".",TEXT(SP_Q__c))=1, TEXT(SP_Q__c)+"0",

     LEFT(TEXT(SP_Q__c),FIND(".",TEXT(ROUND(SP_Q__c,2)))+2)))),

 

"GBP",  ( "GBP"  & " " &

IF(FIND(".",TEXT(SP_Q__c))=0, TEXT(SP_Q__c)+".00",

IF (LEN(TEXT(SP_Q__c))-FIND(".",TEXT(SP_Q__c))=1, TEXT(SP_Q__c)+"0",

     LEFT(TEXT(SP_Q__c),FIND(".",TEXT(ROUND(SP_Q__c,2)))+2)))),

 

 ( "USD"  & " " &

IF(FIND(".",TEXT(SP_Q__c))=0, TEXT(SP_Q__c)+".00",

IF (LEN(TEXT(SP_Q__c))-FIND(".",TEXT(SP_Q__c))=1, TEXT(SP_Q__c)+"0",

     LEFT(TEXT(SP_Q__c),FIND(".",TEXT(ROUND(SP_Q__c,2)))+2))))))

 

Your help is really appreciated.

 

Thanks

 

Kathi

  • April 19, 2013
  • Like
  • 0
Hi everyone,

We want to create a new custom button on our opportunities, which copies some fields of an exisiting opportunity and adds other values as well. Below is the code, I've generated so far. The problem I have is, that the merge fields are not shown in the newly created opportunity. All other values are entered correctly. I've tried for hours, but i just couldn't make the button work correctly. Your help in this is much appreciated.

Thanks

Best wishes
Kathi

/006/e?retURL=%2F006%3Ffcf&RecordType=012L0000000Crg9&ent=Opportunity
opp4_lkid={!Account.Id}&
opp4_lkold={!Account.Name}&
CF00NL0000002uD17_lkid={!Opportunity.Contact__c}&
conid={!Contact.Id}&
opp3={!Opportunity.Name & ' - Extension'}&
opp5=Extension&
00ND0000005gFYM={!Opportunity.Sector__c}&
opp9={!Today()}&
00ND0000005gFYD={!Opportunity.Opportunity_Number__c}&
opp11=Identify&
opp12=10&
opp7=0&
00ND0000005gFY2=Not Required&
opp6={!Opportunity.LeadSource}&
opp17={!Opportunity.Campaign}&
opp14=Extended Project ({!Opportunity.Description})
  • December 03, 2013
  • Like
  • 0

Hi everyone,

 

we are trying to find a way on adding optional products on quotes. Since you cannot change the quantity to "Zero" we've tried to find a way in displaying "not offered" in the total price for those products. I've created a text field formula, that would work perfectly, if we weren't using 3 different currencies in our company EUR, GBP, USD).


Unfortunately the formula is too long (Error message: Compiled formula is too big to execute (5,341 characters). Maximum size is 5,000 characters).

 

Therefore we need to find a way to shorten it. Unfortunately we've couldn't find a way internally, that's why I'm asking the community.

 

The formula, that needs to be shortened is the following. SP_Q__c is a currency formula field totaling the price of a product incl. any discounts. The formula should convert the number into a text, while keeping the decimals.

 

CASE(Description,

"Optional", "not offered",

 "optional", "not offered",

 CASE( Quote.Opportunity.CurrencyIsoCode ,

"EUR",  ( "EUR"  & " " &

 

IF(FIND(".",TEXT(SP_Q__c))=0, TEXT(SP_Q__c)+".00",

IF (LEN(TEXT(SP_Q__c))-FIND(".",TEXT(SP_Q__c))=1, TEXT(SP_Q__c)+"0",

     LEFT(TEXT(SP_Q__c),FIND(".",TEXT(ROUND(SP_Q__c,2)))+2)))),

 

"GBP",  ( "GBP"  & " " &

IF(FIND(".",TEXT(SP_Q__c))=0, TEXT(SP_Q__c)+".00",

IF (LEN(TEXT(SP_Q__c))-FIND(".",TEXT(SP_Q__c))=1, TEXT(SP_Q__c)+"0",

     LEFT(TEXT(SP_Q__c),FIND(".",TEXT(ROUND(SP_Q__c,2)))+2)))),

 

 ( "USD"  & " " &

IF(FIND(".",TEXT(SP_Q__c))=0, TEXT(SP_Q__c)+".00",

IF (LEN(TEXT(SP_Q__c))-FIND(".",TEXT(SP_Q__c))=1, TEXT(SP_Q__c)+"0",

     LEFT(TEXT(SP_Q__c),FIND(".",TEXT(ROUND(SP_Q__c,2)))+2))))))

 

Your help is really appreciated.

 

Thanks

 

Kathi

  • April 19, 2013
  • Like
  • 0