1

In Process Builder, I am writing a formula for a field value. I would like it to look at a newly created attendee record's preferred email field, see if the contents of that field match the email field of existing contact records, and, if so, write the first and last name of that contact into the contact field of the attendee record. When I try to save the formula below, I get this error message: "The formula expression is invalid: Syntax error. Missing '='" 

IF( [EventApi__Attendee__c].[EventApi__Preferred_Email__c] = [EventApi__Contact__c].Email, [EventApi__Contact__c].FirstName + " " + [EventApi__Contact__c].LastName, "no match found" )

Any tips on getting past the error message and getting the formula to work?

Improve this question

1 Answer 1

Reset to default
4

String concatenation in a formula use the & character instead of the +.

IF( [EventApi__Attendee__c].[EventApi__Preferred_Email__c] = [EventApi__Contact__c].Email, [EventApi__Contact__c].FirstName & " " & [EventApi__Contact__c].LastName, "no match found" )
Improve this answer
3
  • Made recommended modification and received same error message.
    – bblohowiak
    Commented Mar 2, 2017 at 19:47
  • Did you try [EventApi__Attendee__c].EventApi__Preferred_Email__c instead of [EventApi__Attendee__c].[EventApi__Preferred_Email__c]?
    – Martin Lezer
    Commented Mar 3, 2017 at 7:38
  • Recommended modification resulted in no longer receiving the same error message--thank you @MartinLezer. Interestingly, the new error message is a bit strange. The formula expression is invalid: Field Attendee.Email does not exist. Check spelling.
    – bblohowiak
    Commented Mar 6, 2017 at 18:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .