Skip to main content
Level 2
Nov 23, 2020 6:40 AM UTC
Solved

Pesonalisation Limit with Custom Object Table

Hi Guys,

 

Apologies in advance if has been discussed previously but I wasn't able to find other related threads or discussions.

We found our last week that we are limited to the row of custom object data that we could use as part of our email (via a foreach loop).

This was only made apparently after feedbacks from live email sent, as the test and preview of the email all looks fine.

 

Our email consist of a section that list/loop through data within a Custom Object table, matching on the contact's email address.  In some cases, there would be more than 10 records for the same user (1:Many, based on email and product).

Our use case is to personalise the email with products purchased by the contact.  But with the limit of only being able to display up to 10 records from the Custom Object poses an issue for us.

The weird thing is that our test emails, and the view online link of live emails seems to work fine and displays more than 10 custom object records.

 

I'm just wondering if anyone else have experience this personalisation limitation and if there is a work-around solution available to handle this use case?

 

Thanks

Aaron

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SanfordWhiteman
SanfordWhitemanAccepted solution
User Group Leader
Nov 24, 2020 12:25 AM UTC

I guess the other only option that I can think of is to extend the core table with the required fields and flatten the data for personalisation. 

Yes, that's the only way. Was just working w/a client where we're doing exactly this today, concatenating string fields from a related object — of which there could be hundreds — into a textarea (long).

8 replies

SanfordWhiteman
User Group Leader
User Group Leader
Nov 23, 2020 6:59 AM UTC

Our email consist of a section that list/loop through data within a Custom Object table, matching on the contact's email address.  In some cases, there would be more than 10 records for the same user (1:Many, based on email and product).

Our use case is to personalise the email with products purchased by the contact.  But with the limit of only being able to display up to 10 records from the Custom Object poses an issue for us.


Yes, this is a known restriction. Are you using a Trigger SC or Batch SC?

Translate
AKT2Author
Level 2
Nov 23, 2020 9:59 PM UTC

Hi Sanford,

 

Thanks for the reply.  The email is a batch send and only on ad-hoc bases.

I guess the other only option that I can think of is to extend the core table with the required fields and flatten the data for personalisation.  But this would definitely make the table really wide.

Just curious if there is a work around even though it is a limitation and how others have dealt with similar use case.

 

Thanks

Aaron

Translate
SanfordWhiteman
User Group Leader
SanfordWhitemanUser Group LeaderAccepted solution
User Group Leader
Nov 24, 2020 12:25 AM UTC

I guess the other only option that I can think of is to extend the core table with the required fields and flatten the data for personalisation. 

Yes, that's the only way. Was just working w/a client where we're doing exactly this today, concatenating string fields from a related object — of which there could be hundreds — into a textarea (long).

Translate