Fields spread out across different custom objects | Community
Skip to main content
L
LCENTENO
New Participant
May 30, 2023
Solved

Fields spread out across different custom objects

  • May 30, 2023
  • 2 replies
  • 1218 views

Hi everyone,

Quick question. I have a set of 7 different criteria that I am investigating to setup a smart list for a recurring campaign. The data fields do exist, however they are spread out across different custom objects.

For example, one custom object (we will call it "Balance") has the "Tier" field, while the other custom object (we will call it "Rating") has the "Rate" field, and the last custom object (we will call it "Acquisition") has the "Acquisition Date" field. 

What would be the best way to setup a campaign smart list to include these fields? Thanks in advance for your help.

Best,

Lucas

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darshil_Shah1

You can use the Has xyz custom object filter for CO and its field is abc in the SL, but that won't guarantee you're referencing the records in different COs in relation to one another (e.g., this logic won't guarantee that the qualified records have all the records in different COs added in the same timeframe). This will just check whether the people have each CO record with the respective field as per the constraint in the Has CO filter set.

2 replies

Katja_Keesom
Katja_Keesom
Community Manager
May 31, 2023

@darshil_shah1 is absolutely right. The only thing I find many people struggle with is the double negatives in setting up filters like this, as you need to combine your "has or does not have a Custom Object record" that "does or does not meet" the constraints.

As an example: Has Balance with Tier is not X and Does not have Rating where Rate is Y translates to the fact that there does noeed to be a Balance record with Tier being equal to anything but X and there cannot be a Rating record with value Y (so there can be a Rating record as long as the value is not Y).

You can combine your different CO filters with the normal All/Any/Advanced filter logic.

Darshil_Shah1
Darshil_Shah1Accepted solution
Community Manager
May 30, 2023

You can use the Has xyz custom object filter for CO and its field is abc in the SL, but that won't guarantee you're referencing the records in different COs in relation to one another (e.g., this logic won't guarantee that the qualified records have all the records in different COs added in the same timeframe). This will just check whether the people have each CO record with the respective field as per the constraint in the Has CO filter set.

Terms & ConditionsAccessibility statement

Loading footer...