Adrian_Bivens

Adrian_Bivens · ‎07-26-2021

We are not familiar with velocity scripting and are trying to understand how we can format Time fields in our velocity token. We are referencing a Salesforce custom field on the Case object. We currently have this much completed: #if( !$Case__cList.isEmpty() ) #set( $sortedCase__cList = $sorter.sort($Case__cList,"CreatedDate:desc") ) #set ($latestSortedCase = $sortedCase__cList[0]) ${latestSortedCase.Meeting_Time__c} #end Any help is appreciated.

Adrian_Bivens · ‎04-27-2021

Life saver!!! Thank you.

Adrian_Bivens · ‎04-26-2021

Sanford, Let me first say thanks for taking the time to look into this as you do with many other posts. It's greatly appreciated. That code worked perfectly in retrieving the latest object. My next hurdle is isolating a specific field to be returned. Right now I get everything that's checked. For example, if I just want the Amount_c field from that latest object to be returned, what would that look like?

Adrian_Bivens · ‎04-23-2021

Let me start off by saying I have as much experience with velocity scripting as I do with underwater basket weaving. With that said, my goal is to be able to pull field values from the latest created salesforce custom object for a lead and reference them in an email. For example, we have a custom object called "Transaction Queue" which is created every time a payment is scheduled. I want to reference values such as "Amount" and " Schedule Date" in an email that's triggered to send when this record is created. I've tried various scripts based on what I've found in the community but nothing that is consistently pulling the latest record. Any help is greatly appreciated 🙂

Adrian_Bivens · ‎04-23-2021

Now I'm lost. I thought the previous request was regarding retrieving values from the latest object created in Salesforce. This is what I have now based on what I've found online, the problem is the values returned aren't consistent. I just need the latest record's values. ${number.format("${esc.d}${esc.h},${esc.h}${esc.h}${esc.h}", ${Transaction_Queue__cList[$math.sub($Transaction_Queue__cList.size(),1)].Amount__c})}

Adrian_Bivens · ‎04-22-2021

Do you know if the objects in the Array are ordered by created date or modified date? For example, I want the values from the latest created object, yet with the snippet of code you provided, I'm getting the values of the last modified record. For our trigger campaigns it's not that big of a deal but we have use cases where older objects could be updated and throw a wrench in any batch campaigns.

Online Status	Offline
Date Last Visited	‎07-28-2021 09:22 AM

Date Registered	‎01-30-2017 07:56 AM
Date Last Visited	‎07-28-2021 09:22 AM
Total Messages Posted	6

Top Badges Earned

Friendly Time Format Options for Velocity Scriptin...

Re: Reference Latest Salesforce Custom Object in E...

Re: Reference Latest Salesforce Custom Object in E...

Reference Latest Salesforce Custom Object in Email...

Re: Velocity script retrieving fields value from l...

Re: Velocity script retrieving fields value from l...