Data Value Change based on timestamp | Community
Skip to main content
September 22, 2016
Solved

Data Value Change based on timestamp

  • September 22, 2016
  • 1 reply
  • 2505 views

Hi there,

I want to be able to change a data value based on the time stamp another data value is changed.

We will have data syncing from Salesforce that I want to create a timestamp for - is this possible?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jessica_Kao3

Smart Campaign 1

Smart List

     Trigger Data Value Change:  Attribute = Lead Field; Constraint Previous Value is empty; Constraint New Value is not empty

Flow

     Change Data Value:  Lead Field Date = {{system.date}}

A couple of things on the SFDC side

If you still intend to access the data after a lead converts to a contact, I would make sure that both these fields are on the lead and contact object and they are mapped together in SFDC and they map to a single field in Marketo. It is much cleaner that way. 

1 reply

Jessica_Kao3
New Participant
September 23, 2016

Hi Veronica,

It's possible but sounds like a series of trigger campaigns.  It might help to understand what your ultimate goal is and maybe there is an easier way to accomplish what you want.  Can you give me an example use case?  Depending on what it is there might be a simpler way. 

September 23, 2016

Hi Jessica,

Once a lead field from Salesforce is populated (previously blank) I would like to be able to populate another field with the datestamp of when the Salesforce data was populated (when that data value changed)

Does that give you enough information?

Jessica_Kao3
Jessica_Kao3Accepted solution
New Participant
September 23, 2016

Smart Campaign 1

Smart List

     Trigger Data Value Change:  Attribute = Lead Field; Constraint Previous Value is empty; Constraint New Value is not empty

Flow

     Change Data Value:  Lead Field Date = {{system.date}}

A couple of things on the SFDC side

If you still intend to access the data after a lead converts to a contact, I would make sure that both these fields are on the lead and contact object and they are mapped together in SFDC and they map to a single field in Marketo. It is much cleaner that way.