• Marilyn Buresh
  • NEWBIE
  • 10 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
Can someone tell me where I'm missing the ')' ? This is a validation rule on a custom object. I'm adding the line with OMTOA but getting a syntex error that I'm missing a ')' - help!

AND(
OR( 
ISPICKVAL( Interview_Model__r.Interview_Type__c , "1"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "2"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "3"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "4")),
OR(
NOT(ISBLANK( Profiles__c )), 
NOT(ISBLANK( External_Predictions__c )),
NOT(ISBLANK( Internal_Predictions__c ))), 
OR(NOT( Interview_Model__r.Name  , "OMTOA")),
$User.Bypass_Validation_Rules__c =false)

Thank you!
Can someone tell me where I'm missing the ')' ? This is a validation rule on a custom object. I'm adding the line with OMTOA but getting a syntex error that I'm missing a ')' - help!

AND(
OR( 
ISPICKVAL( Interview_Model__r.Interview_Type__c , "1"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "2"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "3"),
ISPICKVAL( Interview_Model__r.Interview_Type__c , "4")),
OR(
NOT(ISBLANK( Profiles__c )), 
NOT(ISBLANK( External_Predictions__c )),
NOT(ISBLANK( Internal_Predictions__c ))), 
OR(NOT( Interview_Model__r.Name  , "OMTOA")),
$User.Bypass_Validation_Rules__c =false)

Thank you!
We have a custom object called Feedback that has lookups to both Contacts and Opportunities. Feedback records are created from Opportunities using a custom button URL hack.

The custom button populates the Opportunity lookup and Date fields on a new Feedback record but won't populate the Contact lookup.

The Contact entry should be coming from the custom lookup field on Opportunities called Primary Contact (which is auto-populated with the Primary Contact Role using flows).

My custom button URL is
/a0V/e? 
CF00N6E000000h3Cz={!Opportunity.Primary_Contact__c}
&CF00N6E000000h3Cz_lkid={!Opportunity.Primary_ContactId__c} 
&00N6E000000h2HU={!TODAY()} 
&CF00N6E000000h2ID={!Opportunity.Name} 
&CF00N6E000000h2ID_lkid={!Opportunity.Id} 
&retURL=%2F{!Opportunity.Id}

Any help would be greatly appreciated!