This has been asked a few times, and I have looked through and tried most of those solutions. However, in my case it still seems not to be working, and I am not sure why. Here is an example of the cleanest script I have tried, an adaption of script given to another user for the same issue. #if( $AdPotentialCancellation_cList && !$AdPotentialCancellation_cList.isEmpty() ) #set( $firstItem = $AdPotentialCancellation_cList[0] ) #set( $lastItem = $AdPotentialCancellation_cList[$math.sub($AdPotentialCancellation_cList.size(),1)] ) #end$lastItem.Name Some things to note: AdPotentialCancellation is the name of the SFDC Custom Object being referenced. 'Name' is the field I am trying to get to populate in the email with the above script. I have other fields that I also need to populate in the email. These are the other fields I would like to populate in separate email scripts in the email: 'Declined_Amount__c' & 'Decline_Date__c'. I have done some work on formatting the amount field to be currency and the date to be a date -- it works only if I used the standard code that grabs the oldest field. Decline Amount Code: #set($amount = $number.format("$0", ${AdPotentialCancellation__cList.get(0).Declined_Amount__c}))${amount} Decline Date Code: #set( $dateOptions = { "formats" : { "userin" : "yyyy-MM-dd", "userout" : "MMMM dd, yyyy" }, "timezones" : { "userin" : "America/Los_Angeles", "userout" : "America/Los_Angeles" }, "locale" : $date.getLocale() } ) #set( $declineDatelike = ${AdPotentialCancellation__cList.get(0).Decline_Date__c} ) #set( $declineDate = $convert.parseDate( $declineDatelike, $dateOptions.formats.userin, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userin) ) ) #set( $declineDate_formatted = $date.format( $dateOptions.formats.userout, $declineDate, $dateOptions.locale, $date.getTimeZone().getTimeZone($dateOptions.timezones.userout) ) ) ${declineDate_formatted} An issue I keep seeingis that the email renders the $lastItem.Name, ${amount} or ${declineDate_formatted} instead of any data. I used the below code here to confirm that the data exists for the test lead on the object, and made sure to check all the fields I need in the right column to see the full list. I can see data is there for all fields. #if( !$context.contains("AdPotentialCancellation__cList") ) AdPotentialCancellation list does not exist in context. #else AdPotentialCancellation list exists. #set( $listSize = $AdPotentialCancellation__cList.size() ) #if( $listSize == 0 ) List is empty. #else List size: $listSize. List values: ${display.list($AdPotentialCancellation__cList,"<br>")} #end #end Can anyone help me understand where I might be going wrong, or other ways I can troubleshoot the code? Thank you!

What you've left out is any example of the data actually stored in these objects, and the errors/output you're seeing.What's the output (in the text part of an email, as that's easier to troubleshoot) of:$display.list($AdPotentialCancellation_cList,"\u000a")Anyway, there's nothing inherently wrong with your first bit of code, but if it doesn't match the shape of the ArrayList of objects then it's going to throw an error:Note you can order the list by any field (as long as it's checked off in Script Editor). For example, to order by your Decline_Date__c in ascending order:#set( $objectsByDeclineDateAsc = $sorter.sort($AdPotentialCancellation_cList,"Decline_Date__c") )#set( $firstItem = $objectsByDeclineDateAsc )#set( $lastItem = $objectsByDeclineDateAsc )

Your Achievements

0% to

Next /

to gain points, level up, and earn exciting badges like the new !

View All Badges

Open Alert Bar

Re: New to Velocity - How do I get the most recent object record?

I'm not sure I am following you. How are the two script checks working differently? Why would it work in one list display, but not the other? As far as I can tell, I am not doing anything different in terms of set-up, but one populates with an output and one is blank.