Salesforce Pack Documentation
Share
Explore
Formulas

icon picker
Formula Builders

For column formulas

Choose Object
Lead
Choose Field
Email
Choose Operator
=
Salesforce::LookupLeads( [Auth Account], filter: Concatenate("Email = '",[COLUMN],"'") ).First()
Copy to clipboard


For Records table SOQL filter

The example below is for the Case object

You can choose to sync any object, but you will need to choose the correct object when you create the sync table. For this example, we included the “Case” records object type for the example sync table below.

Where to add SOQL filtering

You can either name the formula and then reference the formula or you can copy/paste the full SOQL statement in the Filter field shown below.
image.png

Choose the ObjectType:
[  ]

NOT?
Field
Operator
Value
Join
1
Case Type
=
Electrical
AND
2
Closed Date
>=
N_YEARS_AGO:5
AND
3
NOT
Contact Email
LIKE
%edge.com
There are no rows in this table
Type = 'Electrical' AND ClosedDate >= N_YEARS_AGO:5 AND (NOT ContactEmail LIKE '%edge.com')
Copy to clipboard
Refresh Cases table
Cases
0
Not synced yet
Record
Case ID
Case Type
Priority
Closed Date
Contact Email
Engineering Req Number
1
500Dn000003mq0PIAQ
500Dn000003mq0PIAQ
Electrical
High
10/27/2021, 11:59 AM
767145
2
500Dn000003mq0UIAQ
500Dn000003mq0UIAQ
Electrical
Medium
10/27/2021, 11:59 AM
j.davis@expressl&t.net
653780
3
500Dn000003mq0bIAA
500Dn000003mq0bIAA
Electrical
Medium
10/27/2021, 11:59 AM
347209
4
500Dn000003mq0jIAA
500Dn000003mq0jIAA
Electrical
Medium
10/27/2021, 11:59 AM
237645
5
500Dn000003mq0mIAA
500Dn000003mq0mIAA
Electrical
High
10/27/2021, 11:59 AM
265794
6
500Dn000003mq0oIAA
500Dn000003mq0oIAA
Electrical
Medium
10/27/2021, 11:59 AM
572546
There are no rows in this table

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.