Putting Last Filled Out Form Field in Report | Community
Skip to main content
Nick_Nappo
Nick_Nappo
Level 4
January 23, 2018
Question

Putting Last Filled Out Form Field in Report

  • January 23, 2018
  • 1 reply
  • 2196 views

I have dozens of people who registered for an event.  They're appearing on the Registered smart list, and now I want to go back and populate this smart list with the dates they filled out the form.  What would be the best way to do this?

Thanks!

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

1 reply

Trevor_Parsell
Trevor_Parsell
Level 5
January 23, 2018

Hey Nick,

I would recommend setting up interesting moments and using a "Last Interesting Moment Date" and "Last Interesting Moment Desc" fields to track this kind of activity in the future.

If you are going to use this on a regular basis going forward, you could also create a "Last Form Fill Date" field and use a smart campaign to time stamp each time a form is filled out. However, I would recommend using interesting moments instead as they are more flexible and can show you the date of many different possible activities.

Thanks!

Trevor

Nick_Nappo
Nick_NappoAuthor
Level 4
January 23, 2018

Thanks, Trevor. I'll look to implement that moving forward.

In the meantime, however, do you have any suggestions for a smart campaign

flow that would regressively assign the Last Filled Out Form date to each

lead?

On Tue, Jan 23, 2018 at 12:35 PM, Trevor Parsell <

SanfordWhiteman
SanfordWhiteman
Level 10
January 23, 2018

This is far harder to do after the fact and why, like Trevor says, you should always have your Filled Out Form trigger(s) set up in advance (write {{system.datetime}} to a lastFormFilloutDT field and this would be all done for you).

You can't directly pull date values from the Activity Log in a batch.  Unless you're only talking about a short range of days -- you could create separate SCs and/or group-by SLs if you only had, say, < 7 days to work with -- you'll need to read these activities out via API and then write the lastFormFilloutDT field.

Terms & ConditionsAccessibility statement

Loading footer...