Timestamp for Form Submissions | Community
Skip to main content
A
Anonymous
January 22, 2016
Solved

Timestamp for Form Submissions

  • January 22, 2016
  • 2 replies
  • 4583 views

Hi Marketo Community -- I'm pulling spreadsheets of form submissions over a specific period of time. We'd like to include the date (and time if possible) as to when the form was filled out. Is this possible, and if so, how? Thanks in advance for your help! Stephanie

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 JohnCl9

Hi Stephanie,

You'd need to have a flow step or campaign set up to populate that data at the time the form is filled out.  Basically, you'd have a custom field and a trigger campaign that would use the trigger Fills Out Form > Is Any.  The flow of that campaign would use a Change Data Value with the {{system.Date Time}} token to populate your custom field with the current date and time.  Then you could include that custom field in your spreadsheets to show when the most recent form was filled out for each lead.

The only issue is that this will only work for leads filling out forms in the future.  There isn't currently a way to export the day and time of a form fill-out en masse automatically.

John

2 replies

J
Adobe Employee
JohnCl9Adobe EmployeeAccepted solution
Adobe Employee
January 22, 2016

Hi Stephanie,

You'd need to have a flow step or campaign set up to populate that data at the time the form is filled out.  Basically, you'd have a custom field and a trigger campaign that would use the trigger Fills Out Form > Is Any.  The flow of that campaign would use a Change Data Value with the {{system.Date Time}} token to populate your custom field with the current date and time.  Then you could include that custom field in your spreadsheets to show when the most recent form was filled out for each lead.

The only issue is that this will only work for leads filling out forms in the future.  There isn't currently a way to export the day and time of a form fill-out en masse automatically.

John

SanfordWhiteman
SanfordWhiteman
Level 10
January 22, 2016

Stephanie, you can also stamp the form using JavaScript.  I'd do that instead to reduce the number of trigger campaigns and keep the handling on the client side.

MktoForms2.whenReady(function(form){

  form.onSubmit(function(form){

    form.addHiddenFields({ LastFormFilloutDateTime : new Date().toUTCString() });

  });

});

Bear in mind that both this and the server-side Change Data Value associate the timestamp with the lead, rather than with the activity.  As such there is only one value stored at any time.  If you want to see a "stack" of all the form fillouts over time, you can use a Change Data Value to append to a second history field.

The timestamp data at the activity level is available via the API.

Terms & ConditionsAccessibility statement

Loading footer...