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

    REPORTS - Trying to make a report using Address field - CASE CLOSED

    Asked by AA_C on May 16, 2016 at 10:36 AM

    I'm trying to use information in the "Address" field of my Membership Form 52934584917973 but when I try and create a 'Pie' chart it dose not show the "Address" field as an option. I want to create pie chart showing applicants by provinces but I can't do it without the "Address" info.

    Why is it not giving me that option?

    Regards,

    Robert

    Reports Make a membership form chart create and
  • Profile Image
    JotForm Support

    Answered by liyam on May 16, 2016 at 12:18 PM

    Thank you for your question, Robert.

    The address field from the quick fields are not considered to be comparable for pie charts. If you wish to have such appear on the list to be selected, you will need to use a drop down menu field, or create a series of individual fields which should constitute as your address field.

    If you have questions, please do let us know.

    Thanks.

  • Profile Image

    Answered by AA_C on May 17, 2016 at 10:07 AM

    Ah NUTS! ... Just what I thought...

    Unfortunately the way you are setup if I change a field all previous data is lost so I have to create a new form and combine date and create a pie chart outside your application.

    Not Good planning on my part. I've been asked to create a report on memberships by province.

    I will have to go to our membership manager and get data from her to create the report.

    Thanks for the reply,

    Robert

  • Profile Image
    JotForm Support

    Answered by liyam on May 17, 2016 at 11:50 AM

    Hello Robert,

    But, just in case you need a chart but not necessarily in the JotForm reports tool, you can download the Excel file of the submissions. The fields there are separated by columns, so you can explicitly compare the province there using a charting tool such as pivot tables/charts of excel.

    Another alternative is to create a new form with the separated fields for address, and then you can import the data using import to jotform app (http://import.jotform.io/), or spreadsheet to JotForm app (http://www.jotform.com/spread2jot). You can also explore apps available on http://apps.jotform.com/ and see if you can find more apps there that may suit your needs.

    If you have questions, please do let us know.

    Thanks. 

  • Profile Image

    Answered by AA_C on May 17, 2016 at 09:16 PM

    Hi,

    Thanks for the options. I will find a way. 

    Regards,

    Robert

    PS

    I tried this link for spread2jot  with 3 different spread sheet forms and it failed with each. It would not let me get the right headings, if I highlight some then select another it would un-select the first ones, very annoying. The forms it created were uscless. For example formID=61378112042951. And shows 31 unread and it hasn't been posted? I looked at two and they are blank. What gives?

    (http://www.jotform.com/spread2jot

  • Profile Image
    JotForm Support

    Answered by liyam on May 17, 2016 at 11:15 PM

    Hello Robert,

    Thank you for your response.

    Regarding the concerns about spread2jot, I have moved it to another thread. We'll get back to you on that thread.

    Thanks.