Sort Columns by Submission Date | Community
Skip to main content
New Participant
July 14, 2020
Question

Sort Columns by Submission Date

  • July 14, 2020
  • 1 reply
  • 1800 views

I am sorting out form entries by the column "Created" and also "Updated" but this doesn't  work for existing users who have filled out form previously.  Can you advise how I may set up a column that will sort form submissions by date. 

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

1 reply

SanfordWhiteman
New Participant
July 14, 2020

When you say "form entries" you mean fields updateable by form submissions, correct?

 

Because a Filled Out Form activity is only a "first-class" reportable moment in Marketo if you've extracted the Activity Log via API. Otherwise, you're looking at the results of form submissions.

New Participant
July 17, 2020

Form entries I simply mean when someone fills out the form whether they be an existing user or otherwise.  I work for a marketing department and all they want is to view all form entries and the data that was submitted in chronological order. IF this can be achieved only by API please provide instructions. Thx

SanfordWhiteman
New Participant
July 17, 2020

Right. Such a Report/Smart List is not possible in the Marketo UI. 

 

You may use either the Bulk Extract API endpoint (results in a single CSV file, multi-step asynchronous generation) or the Bulk Export endpoint (paginated JSON response, synchronous, 300 records/page) to get the Filled Out Form activities. See developer.marketo.com.