I would like to filter my registrations based on the weeks

  • ACFA_Edmonton
    Demandé le 28 mai 2024 à 19:12
    I would like to filter my registrations based on the weeks so that I can know how many children I have per week. Is there a way to do this in the spreadsheet?
  • Mightor Jotform Support
    Répondu le 28 mai 2024 à 19:29

    Hi ACFA_Edmonton, 

    Thanks for reaching out to Jotform Support. Check the steps and screenshot below on how to filter the dates in the submissions table:

    1. In the submissions table, click on Filter button.
    2. Set the dates by selecting Custom dates.
    3. Then set the fields and click on the Apply Filter button.

    I would like to filter my registrations based on the weeks Image 1 Screenshot 20

    Give it a try and let us know how it goes.

  • ACFA_Edmonton
    Répondu le 3 juin 2024 à 11:44

    Hello,


    I believe this only filters the dates for when the forms were submitted. I am looking filter submissions by what week a child is enrolled in camp. For example, I would like to be able to export an spreadsheet for all the children enrolled for week 1.


    Hope this clarifies things. Thanks


  • Gian Jotform Support
    Répondu le 3 juin 2024 à 14:06

    Hi ACFA_Edmonton, 

    Thanks for getting back to us. Please be advised that you can also choose a certain field to filter the results. Based on what you're trying to do, here's an example filter:

    I would like to filter my registrations based on the weeks Image 1 Screenshot 20

    Here's our guide on How to Filter Entries in Jotform Tables.

    Give it a try and let us know if you need any other help.