Hi,

I have the following formula which produces a QR code for exhibitor badges which works fine. I need to produce just the last 10 digits of the PA ID, can you please advise what I need to complete that with ?  I was adding , (10) but I get a syntex error.  Please advise.

"http://chart.apis.google.com/chart?cht=qr&chs=125x125&chld=H&chl="&  SFDC_Project_Attendance_ID__c

Thanks

Hi,

I have the following formula which produces a QR code for exhibitor badges which works fine. I need to produce just the last 10 digits of the PA ID, can you please advise what I need to complete that with ?  I was adding , (10) but I get a syntex error.  Please advise.

"http://chart.apis.google.com/chart?cht=qr&chs=125x125&chld=H&chl="&  SFDC_Project_Attendance_ID__c

Thanks

Hello

I'm looking for some help on some formula code that sits within an opp validation rule which pre-existed in the organisaiton that I work for, but that we now want to try and amend in order to get any record with a newly added opp record type to ignore.

The formula code is as follows: 
---------------------------------------------------------------------------------------------------------------------------------
AND(

OR(ISPICKVAL( StageName , "Complete - Won"),
ISPICKVAL( StageName , "Complete - Won (Products Dropped)")
),

OR(ISPICKVAL( Contract__r.Status, "Draft" ),
ISPICKVAL( Contract__r.Status, "In Approval Process" )

),

OR (RecordTypeId <> $Setup.RecordTypeID__c.Opportunity_Consulting_Opportunity__c,
RecordTypeId <> $Setup.RecordTypeID__c.Opportunity_MC_Credit__c)
)
---------------------------------------------------------------------------------------------------------------------------------

We added the "RecordTypeId <> $Setup.RecordTypeID__c.Opportunity_MC_Credit__c" line to try to get the formula to ignore any opps that come through with a record type of "Opportunity_MC_Credit__c".
 
The test record that we’re struggling with has the following values:StageName = "Complete - Won"
Contract__r.Status = "Draft"
RecordTypeID__c = “Opportunity_MC_Credit__c” 
When the record goes through this code it fires an error message and stops us closing the opportunity that its on.
 
What we want to know is - does this code make sense in terms of its logic? Which of the three blocks of code is actually running when we pass our record through with the above parameters? Just one of the blocks? More than one? Does the code run in a particular order? If the criteria is met on the first block of code does it then stop there? Or does it continue until its checked all three blocks?
 
Really hoping I’m making some sense! and many thanks in advance for your help.