This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

SalesForce CONTAINS (LIKE) Function

Posted on 04-27-2021 05:56 AM
Kipdodgr
New Member
Reply posted on --/--/---- --:-- AM

Using SalesForce as my data source and I need to perform a CONTAINS function, however, SalesForce SOQL doesn’t recognize a CONTAINS function, only LIKE, which AppSheet doesn’t recognize.
Anyone encounter this problem or have a work around?

0 2 384
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Kipdodgr
New Member
Reply posted on --/--/---- --:-- AM

Well, I figured it out. You have to use the EXTRACTEMAILS function:

CONTAINS(EXTRACTEMAILS([AppSheet__c]), USEREMAIL())

Posted on --/--/---- --:-- AM
Steve
Platinum 5
Platinum 5
In response to Kipdodgr
Reply posted on --/--/---- --:-- AM

Better:

IN(USEREMAIL(), EXTRACTEMAILS([AppSheet__c]))

See also:

Top Labels in this Space