SalesForce CONTAINS (LIKE) Function

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?

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

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

1 Like

Better:

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

See also:

1 Like