Yet another Velocity question for Sanford Whiteman​ or someone with similar experience. We create URL's based on an ID of the most recently updated custom object. The issue is, even though the ID field is populated 100% of the time and there is no duplicate Contact, the variable doesn't load consistently. ##IF A NET-NEW ONBOARDING RECORD IS CREATED, PULL ITS ACCOUNT ID## #if ($context.contains("TriggerObject")) #set ($focusedObject = $TriggerObject) ##IF AN EXISTING ONBOARDING RECORD IS UPDATED, PULL ITS ACCOUNT ID## #elseif ($context.contains("OnboardingRelationship_cList")) #set ($focusedObject = $sorter.sort($OnboardingRelationship_cList,"updatedAt:desc")[0]) #end ##IF PHOTOGRAPHY ISN'T SCHEDULED, DISPLAY TEXT BLOCK, ELSE NOTHING## #if ($focusedObject.Photography_Scheduled__c == 0) <b>Photography</b><br> Please click <a href =" https://website.com/new/photos?flow=uk-s&sfid=$focusedObject.accountID ">here</a> to book your photography. We will upload your photos once they’re ready. In the meantime you can go ahead and start accepting orders!<br>## #else #end The website url actually shows the variable name instead of the ID. Yes, I've made sure the box is checked and I'm not using send sample functionality. Appreciate any thoughts or ideas. ... View more

I briefly touched on this with Sanford Whiteman​'s help onSorting a Marketo Custom Object with Velocity​ but we're now looking for a work-around due to Marketo not supporting $Trigger functionality on updated custom objects. Trigger Campaign: Send email containing login details when an API call either adds the Contact to or Updates a Marketo custom object Email Script: Only return the $Object.Username associated with the most recently updated row in the custom object We can either reference the Last Modified Date (which is pull from the original data source) or the Marketo Updated At field. I'm assuming we would do a sort and pick the most recent value from either field. Does anyone have any example scripts we could pull from? Appreciate the help in advance. ... View more

This topic has been briefly touched on a few other threads (e.g. Velocity Snippets #1: Sorts and seeks​) with Sanford Whiteman but hoping to further clarify. Use Case: Display a table for each store locations' order data if the store's order data is yesterday. Design: API upsert into Marketo Custom Object with triggered smart campaign which fires email Issue: Sometimes a franchise owner may sell a store an no longer be upserted into Marketo. Thus, old order data will live in the custom object. Our #foreach loop will bring back the oldest record instead of the custom object row which was updated. I realize from Kenny Elkington's response (Velocity: Sort Opportunities by date​), you can use $TriggerObject but we still need to load multiple rows instead of just the most recently updated. Therefore I believe a #foreach loop is still needed. I understand the .get(0) finds the first/oldest row in the custom object so we've dropped that but still looking for a way to sort and/or only load rows which have an order date = yesterday. Appreciate the help and please forgive my lack of Velocity understanding. #foreach (${mcDonaldsOrderSummaryV2_c.storeNumber} in ${mcDonaldsOrderSummaryV2_cList}) ##CONVERT CUSTOM OBJECT STRING DATE TO DATE FOR COMPARISON #set ($OrderDate = ${mcDonaldsOrderSummaryV2_cList.get(0).dateOfOrder}) #set ($parsedOrderDate = $convert.parseDate($OrderDate, "yyyy-MM-dd")) ##SET LOCAL VARIABLE FOR A YESTERDAYS DATE #set ($TodaysDate = $date) #set ($formattedTodaysDate = $date.format("yyyy-MM-dd", $TodaysDate)) #set ($dayago = $date.calendar) $dayago.add(5,-1) ##A Week Ago's Date: $date.format('yyyy-MM-dd', $dayago.time)<br> ##SET LOCAL VARIABLE WHICH IS THE DIFFERENCE BETWEEN ORDER DATE AND A WEEK AGO #set ($dateDifference = $date.difference($parsedOrderDate, $dayago).getDays()) ##IF THE ORDER DATE IS GREATER THAN OR LESS THAN A DAY, DON'T BRING IT BACK #if ($dateDifference > 2) #elseif ($dateDifference <= 2) ... View more