How can I produce a list of prior forms that have been filled out by my customers?

  • StrawberryDesi
    Asked on August 23, 2015 at 1:22 PM

    My customers use my Jotforms to order products from my company.  I'd like for the system to create a list of each customer's previous submissions (listed by date & time submitted).  How can I do this?

  • Boris
    Replied on August 23, 2015 at 5:51 PM

    If you are simply looking for a way to take a quick look at this data, you can go to your form's Submissions page, and enter your customer's name into the filter field. It will automatically filter to show only submissions on that form that contain the filtered (customer's) name.

    How can I produce a list of prior forms that have been filled out by my customers? Image 1 Screenshot 20

    If you are looking for a way to have this data created programmatically for you to download and have in something such as excel format, I would advise you to either (1) set up an integration with Google Spreadsheet, (2) to set up an Excel Report, or (3) to simply export your submissions into Excel manually.

    This would forward all submissions from your form to either a Google Spreadsheet or an Excel Report respectively, from where you can sort and filter your submission data as you normally do in Excel spreadsheets. Here is a guide for filtering data in Excel spreadsheets:

    http://www.excel-easy.com/data-analysis/filter.html

    I hope this helps. Please let us know if you need further assistance.

  • Henry Long
    Replied on August 23, 2015 at 10:04 PM

    Thanks for your answer. But, I would like for the list to be created automatically and I would like for it to always appear on the form that my customers use.  How can I make that happen?

  • Kiran Support Team Lead
    Replied on August 24, 2015 at 4:19 AM

    You may create an HTML table listing report or Grid listing report so that you can embed the report on your JotForm using iframe embed widget.

    1. You can get the report URL once you have generated the report

    How can I produce a list of prior forms that have been filled out by my customers? Image 1 Screenshot 50

    2. Place the Iframe embed widget on your form

    How can I produce a list of prior forms that have been filled out by my customers? Image 2 Screenshot 61 

    3. Now, place the report URL in the wizard.

    How can I produce a list of prior forms that have been filled out by my customers? Image 3 Screenshot 72

    4. Finish the wizard and save your JotForm.

    The report with previous submissions will be displayed on your form.

    How can I produce a list of prior forms that have been filled out by my customers? Image 4 Screenshot 83

    Hope this information helps!