Add "created at" and "updated at" in constraints for custom objects | Community
Skip to main content
Catherine_Cham1
Catherine_Cham1
New Participant
July 9, 2018
New

Add "created at" and "updated at" in constraints for custom objects

  • July 9, 2018
  • 3 replies
  • 3714 views

When creating a custom object in Marketo, 3 fields are automatically created: Marketo GUID, Created At and Updated At.

These fields are not available in the contraints when using a filter to which this new custom object is linked. These could be extremely useful if you are planning on using these to track custom activities in CRM so you can leverage the "before" or "after" in your date ranges based on the Created or Updated at values.

    3 replies

    B
    BTAndiCockbill
    New Participant
    January 4, 2024

    This would be super useful for us. Please can this be implemented. The data is already there by default. I couldn't believe these fields weren't available to filter on.

    K
    kh-lschutte
    New Participant
    February 4, 2020
    No text available
    SanfordWhiteman
    SanfordWhiteman
    New Participant
    July 10, 2018

    I sort of like this Idea, yet sort of not... in some systems it's important to have system mod stamps that you cannot be tempted to use in filters, because they can be unexpectedly reset as side effects of other actions.

    For example, if you detach and reattach an object (necessary in some workflows) you'll have a new record with a new createdAt. But that field doesn't necessarily have any semantic meaning: the other, user-settable DateTime fields on the object determine its actual business properties.

    Catherine_Cham1
    Catherine_Cham1Author
    New Participant
    July 11, 2018

    Hey Sandford,

    I completely agree. But there are cases for which it can be extremely useful. In this particular one, I have a High Ed client who creates activities in DCRM when students ask for information via a form on their website (not Marketo form, not linked through API). We want to then target these students based on when they made the request so I'd need to know the created at date. Simply knowing that an activity exists isn't enough. We need a time frame.

    In this case, the object will never be detached. It's engrained in workflows and processes to a point where it cannot be decoupled. That being said, if anything were to reset the date, it would be part of said workflows and processes and would still be of high value to the marketing team. Does this make sense?

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    July 11, 2018

    Sure, but why can't they add the form fillout timestamp as a DateTime field?  That's the typical way to do it.

    Terms & ConditionsAccessibility statement

    Loading footer...