Is there a way to display the submission data by date?

  • Profile Image
    sportingcolumbus
    Asked on April 11, 2019 at 09:05 AM

    I created a form where people can pick one or more days to attend a program.  Is there a way to display the data by date?  i.e. Tuesday is shows the four people signed up; Wednesday it shows the two people who signed up and Thursday it shows the 6 people who signed up? So ideally it is easy to see who is attending?

  • Profile Image
    AndrewHag
    Answered on April 11, 2019 at 09:36 AM

    In the submission page, click on the gear icon at the top right corner. Then select custom from the Time Frame dropdown and set the date range to see the submission date between that range.

    1554989734chrome_nHqPA9lhYK.png

  • Profile Image
    sportingcolumbus
    Answered on April 11, 2019 at 10:43 AM
    Thanks but I don't think you understood the question.  100 people fill out the form over the next month and everyone picks different dates they say they are attending. 75 say they can attend 6/520 say they can attend 6/644 say they can attend 6/72 say they can attend 6/8Is there a to list all 75 names on 6/5 and all 20 names on 6/6, etc.Thanks,Jeffrey WarrenSporting ColumbusPresident614.284.9746 
    ...
  • Profile Image
    Nik_C
    Answered on April 11, 2019 at 12:50 PM

    Actually, you can. In new submissions layout, Sheets, you can specify a filter:

    1555001267Screen Shot 2019-04-11 at 6.47

    So you could set your date to be equal to date you need and it will show only that data.

    To access your form submissions in Sheets, you can use URL: https://form.jotform.com/sheets/########

    Where ####### is your form ID.

    The additional way would be to export your data to Excel and filter the data there: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    Hope it helps.

    Thank you!