JavaScript Snippet Help - Find NEXT Date in Related Model

Hmmmm… another solution would be to add a Child Relationship to the Event object from the Case object. Just set the limit of records in the child relationship to 1 and sort by the date field in DESC. No snippet required. 😃

Jason,

Instead of a JavaScript snippet, this seems like a good solution for a trigger to update the Case with the date of the next appointment.  Then you could sort by the date without a snippet and show this field on any page.

Thanks,

Bill

Oh yeah! Server side. Then how about Declarative Lookup Summary Tool to set the date. Set up the sort in the same way as the child relationship.

Great idea, but does not work if you want the column in the table to be “sortable”.  

Triggers are expensive in this org.  In a call center environment adding triggers may be more costly in terms of performance and scalability.  I will keep thinking on this. 

Jason,

Does the update have to be real time?  You could setup a batch class that would do the update.  It has much higher limits than triggers.

This is a ‘tricky’ requirement when you want to make the column sortable.

Thanks,

Bill

Then server side solution would be better as the value would reside on the parent record.

Is the child record Master-Detail? Then standard Rollups.

If not, can you make it Master-Detail?