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

  • Profile Image
    davidgoebelstate
    Asked 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)?

  • Profile Image
    idarktech
    Answered 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
    davidgoebelstate
    Answered 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
    idarktech
    Answered 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
    davidgoebelstate
    Answered on January 28, 2013 at 10:50 AM

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