How do I get all my different form results on one window to sort by a certain type of form?

  • Profile Image
    cbcbellevue
    Asked on May 10, 2011 at 07:16 PM

    I have several different forms that deal with different types of media. I want to be able to have all those forms on one spreadsheet, and sort by the "due date", or the "type of media". Is this possible? 

    I know I could export all the different forms to separate spreadsheets, and than combine them, but this seems redundant. Any suggestions? Thanks!

  • Profile Image
    NeilVicente
    Answered on May 10, 2011 at 07:55 PM

    Hi,

    I don't mean to offend but what you're trying to achieve seems impossible, seeing that not all your forms have the same structure. Even using Excel might cause headaches because your forms have different fields.

    Now if the structure of your forms is uniform, there could be a workaround. You can instead use a single form and deploy them into different websites (or media, if you may have it). To be able to tell which website a submission entry came from, you may want to look at this thread

    You can use hidden fields for the media type and then use Excel filtering to be able to sort your submissions by "type of media" or "due date".

    Hope you find this information useful. Let us know if you have further questions. Thank you.


    Neil

  • Profile Image
    cbcbellevue
    Answered on May 11, 2011 at 01:44 PM

    Neil - 

    Thank you for your quick response. We've fixed the issue, we're up and running. 

    I do want to comment on your reply. It didn't seem professional to me, and I felt talked down to. 

    I'm very new to JotForm, and wondering if this is a typical response from your support department? 

    We were interested in purchasing the 2 years today, but now we'll start with the monthly just to see what type of responses we get from your team over the next month.

    I also want this response and yours forwarded to your manager.

    Thank you!

  • Profile Image
    aytekin
    Answered on May 11, 2011 at 02:08 PM

    There is no feature to join the data from all forms into a single report. So, there is no perfect solution for this. You can try to merge the responses in Excel, but that's also very hard when the forms are different from each other. 

    I was not able to find anything offending in Neil's response. He seems to have thought through your question and was not able to find a solution. That happens. Sometimes there is no solution. He seems to have researched the web and provided some useful links and ideas.