What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    I want to somehow sort the form submissions so that submission from same form go to different people

    Asked by Elimmee on March 11, 2016 at 04:42 PM

    Hi,

    Thanks for all your help that the jotform staff have given over the last two weeks!

     

    I have a goal that may not be possible but here goes:

    We get lots of volunteers applying to us for different programs which each have different staff overseeing them.

    I have already made it so the form after submitted will go to the right staff member.  But I also want to help them collect them in a report of their own volunteers.  Right now, of course, the report is of ALL the volunteers.  I don't want all the staff to see info of volunteers who are not theirs.  My question is what is the most effective way to get a report differentiated on the program ( which is a field in the form, called staff guiding you)

    Page URL:
    https://www.jotform.com//?formID=60704490201242

    Submissions different same form same
  • Profile Image
    JotForm Support

    Answered by Boris on March 11, 2016 at 05:25 PM

    This will depend on the type of reports you are looking at.

    I'm afraid that at this moment, we do not have a way for filtering Excel/CSV or Table/Grid reports based on a form field. However, we do support this on Visual Reports:

    http://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-your-Form-Submissions

    You will need to use the Visual Report Filters, and filter your submissions based on Question And Answer:

    http://www.jotform.com/help/281-How-To-Use-Visual-Report-Filters

    If you are looking at some other kinds of reports, I'm afraid that we do not have such a way for filtering. The two workarounds that come to mind would be to (1) download the Excel file of your submissions and manually filter out the data that you do not want others to see, or (2) to use different forms for each of the ministries that they are applying for.

    In the latter example, you would have a very short main form where they select which ministry, and upon submitting it they are redirected to a different form with questions specific to that ministry. This way, each specific form would have its own submissions page, and its own submission reports.