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

    Visual Report Builder: Is there a way to combine multiple fields into a single column when using the visual report?

    Asked by davidgoebelstate on January 24, 2013 at 12:47 PM

    I have a form that has multiple hidden form collapse areas that open based upon what option the user selects.  However, some of the fields have similar items that I would like to combine when creating a visual report. 

    For example:

    open http://jotform.us/form/23464745102146

    select Appliance Hardware from the Issue field

    select LC from the GSA Model field

    scroll down and you will see 7007 Items

    scroll back up and select Mini from the GSA Model field

    scroll down and you will see another 7007 Items field which has some of the same options as those found under the LC model

    What I would like to do is to combine these similar fields into a single column for reporting purposes.  Currently, they are seperate entries.  Is there a way to do this?  If not by the visual report tool, is there a way to somehow do this via Excell or maybe Google Spreadsheet (CSV)?

    Page URL:
    http://jotform.us/form/23464745102146

    Screenshot
  • Profile Image
    JotForm Support

    Answered by idarktech on January 24, 2013 at 01:26 PM

    Hi,

    Sorry but it's not yet possible with JotForm's Visual Report Builder. We'll see if we can find a way to make this on excel, we'll get back to you once we found a way for this.

    I have also created a request ticket about this so our development would be aware of this function as it seems to be useful.

    Thanks!

  • Profile Image

    Answered by davidgoebelstate on January 24, 2013 at 01:28 PM

    That would be great, thanks.  If possible, Google spreadsheet would be preferred over Excell.

    Thanks again!

  • Profile Image
    JotForm Support

    Answered by idarktech on January 25, 2013 at 09:00 PM

    @davidgoebelstate

    Sorry for the delay. I have tried digging around and I can't seem to find any possible workaround. I'll ask around from my colleagues, hopefully they can help.

    My apologies for the inconveniences.

  • Profile Image

    Answered by davidgoebelstate on January 28, 2013 at 10:50 AM

    No problem.  Hopefully you can find a solution.  Thanks for the help.