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.