Loop data in subject line
I am working on a transactional email where each record will exist multiple times in a data source.
CUSTOMER_ID_ | REQUEST_ID | REQUEST_DATE | REQUEST_TYPE |
---|---|---|---|
11111111 | 100001 | 10/1/2018 1:00PM | A |
11111111 | 100002 | 11/1/2018 2:00PM | B |
11111111 | 100003 | 12/1/2018 3:00PM | C |
11111111 | 100004 | 12/18/2018 4:00PM | D |
Each time the customer submits a new request, they receive an email with the latest data -- this is currently populated in the email body copy by a loop BIF.:
So here is the issue -- let's say the customer submits their request today. They receive the following:
Request Type: D
Request Date: 12/18/2018 4:00PM
Request ID: 100004
Since this data is setup by a loop, we are unable to pull the latest REQUEST_TYPE into the subject line, and Responsys instead defaults to the first record it can find.