# Form Reporting - Existing contacts

**URL:** <https://community.hubspot.com/t/form-reporting-existing-contacts/21426>\
**Category:** Lead Capture Tools\
**Tags:** forms\
**Created:** [June 4, 2020, 4:57pm UTC](https://community.hubspot.com/t/form-reporting-existing-contacts/21426 "2020-06-04T16:57:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rpert](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rpert/32/2401_2.png) [@rpert](https://community.hubspot.com/u/rpert)\
**Post date:** [June 4, 2020, 4:57pm UTC](https://community.hubspot.com/t/form-reporting-existing-contacts/21426/1 "2020-06-04T16:57:29Z")

</div>

Hi everyone,

I am looking to run a report (or a list) which shows me **form submissions** by quarter/month/week. I know the form analytics shows the total number but I need to do a more detailed analysis to understand the percentage that are addressable to our SDRs - I can not do that unless I can report on submission date alongside other contact fields.

Importantly, I want to be able to report on new contacts that are created from that form submission **as well as** existing contacts that completed the form submission during their nurture.

Because I have a number of forms on the website, I would like to be able to do the above on all individual forms.

Thanks so much for your help!

@AM8 - appreciate any help on this 🙂

@AM8

---

<div class="post-metadata">

**Author:** ![AM8](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/am8/32/61904_2.png) [@AM8](https://community.hubspot.com/u/AM8)\
**Post date:** [June 4, 2020, 5:19pm UTC](https://community.hubspot.com/t/form-reporting-existing-contacts/21426/2 "2020-06-04T17:19:33Z")

</div>

Hi @rpert  
Thanks for tagging me. I think you can achieve this using lists:  
Create an active list for the form you need and select " refine filter condition" - is between and fill in the dates you need. Once you have this list created you can create a custom report using this list as a criterion to segment your database and get information specific to the contacts who submitted the form in your specified date range.

 ![27624i13E90328D95B223C.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/5/3/53af2574979e4ec13a92d06b7b271db70a9bbff7.png)

If you need to capture the exact form submission date in a custom property, this the workflow to achieve that is detailed in a separate thread here: [https://community.hubspot.com/t5/Lists-Lead-Scoring-Workflows/Use-workflows-to-set-a-date-stamp/td-p/251354 .](https://community.hubspot.com/t5/Lists-Lead-Scoring-Workflows/Use-workflows-to-set-a-date-stamp/td-p/251354)  
Use the " date of step" option to capture the date of form submission. Enrollment trigger can be - Any form submission on any page ( or customized as per your need)  
**To differentiate new contacts that are created from that form submission and existing contacts that completed the form submission during their nurture** - you can filter the list using the condition " create date" is before or after " form submission date" ( captured using the workflow described above )  
Let me know if you have any follow up questions.