Elsa_Man3
Level 2
Vancouver, BC
Director of Consulting Services
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
yesterday
|
8
Posts
0
Likes
0
Solutions
04-29-2020
01:51 AM
Hi @SanfordWhiteman I came across your solution to this post challenge, which is similar to mine - I'm trying to pull a list of all the Order Names associated with a Contact, if certain conditions for those orders apply (i.e. Status is Processed, and the Program the order came in under matches its SFDC ID). Applying as best I could from your sample code I came up with the below, but in Marketo when I render the email with a test person, it displays empty. Did I apply your sample incorrectly? Let me know if you prefer I create a new post for this question. Thanks as always! #set( $processedOrders = [] )
#foreach ($Program_Order in $Program_Order__cList.get(0).Order_Line_Item__cList)
#if( $Program_Order.ProgramOrderStatus.equals("Processed") && $Program_Order.Program.equals("a0A4t0000001YO5EAM"))
#set( $void = $processedOrders.add($Program_Order) )
#end
#end
#foreach( $Program_Order.Name in $processedOrders )
${Program_Order.Name}
#end
... View more
04-28-2020
03:52 PM
thank you (again!) 😊
... View more
04-28-2020
03:51 PM
it works great now, thank you!!
... View more
04-28-2020
01:26 PM
thanks! I've edited the original post with the syntax highlighter, also below: <ul>
#foreach ($Program_Order in $Program_Order__cList)
<li>${Program_Order__cList.get(0).CreatedDate}</li>
#end
</ul>
... View more
04-28-2020
12:56 PM
We're trying to use the foreach directive in Velocity to list all the Order Dates that a contact had have, over time. For example, Joe Smith placed an order today and one yesterday, so in the email I want it to list out both dates. I've used this script: <ul>
#foreach ($Program_Order in $Program_Order__cList)
<li>${Program_Order__cList.get(0).CreatedDate}</li>
#end
</ul> But in the email outputs, it just lists out yesterday's date, twice. So it's recognizing that Joe has 2 order records attached to it, but only populating it with the first order's created date in the list. What am I missing in the script? Thanks!
... View more
04-28-2020
12:46 PM
thanks Sanford! I should note that the Contact --> Order is a Lookup relationship too, but we are able to successfully pull in fields from the Order object. Does the anti-lookup rule not apply here because it's directly tied to the Contact?
... View more
04-28-2020
11:02 AM
We have data stored in a SFDC custom object that is 2 levels down to the Contact record (Contact --> Purchaser Profile --> Ticket) and according to Marketo, that SHOULD pull through in Velocity Scripting (it's only 3 levels down that's a no-go). But we aren't able to for some reason. But if we go try to pull 2 levels down through a different route (Contact --> Order --> Order Line Item) we are successful. The only difference I can see from pulling data from Ticket vs Order Line Item, is that the Ticket is a Look-up relationship to Purchaser Profile, whereas Order Line Item is a Master-Detail relationship to Order. Does anyone know if that makes a difference? Thanks in advance!
... View more
04-03-2020
01:42 PM
Just came upon this discussion as I'm trying to solve for that exact issue in our email reporting, to easily track by email what the actual unsubscribe numbers are when we only use custom unsub fields. The solution to pass Email ID in as a query parameter thru the custom unsub form is great, but I got lost when you mentioned passing that info back into SFDC too and into a custom object. Can you explain why we would need that data in a custom object pls? If i just housed the field "Unsubscribed from Email ID" as a regular field on the Person/Contact object, could I not pull that into reports or smart lists the same way?
... View more
Public Statistics
| Date Registered | 12-02-2019 08:12 PM |
| Date Last Visited | yesterday |
| Total Messages Posted | 8 |
.png)