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: Can we create date field vs weight field in line graph?

    Asked by wsfarm on May 03, 2015 at 06:35 AM
    2  Can I graph, as in the example below, Weights over time within a Visual report? That is the Date field vs the Weight field?  I realise that I can graph it in a spreadsheet, but can I do it in Visual Reports?
    Visual report line graph
  • Profile Image

    Answered by Ben on May 03, 2015 at 06:48 AM

    I am not sure exactly what you are trying to achieve here?

    I presume that you would like to have a graph instead of the grid showing you this data?

    If not, could you please give us a bit more details in regards to this?

    Thank you.

  • Profile Image

    Answered by wsfarm on May 03, 2015 at 05:50 PM

    Hi Ben,

    I would like to be able to show both the table and the graph.

    Something like this:

    I don't think the current graph function can achieve this, but such a graph would be useful for showing how any numerical or financial data changes over time.

    Thanks for following up all our queries.

    Regards

    Charlie

  • Profile Image
    JotForm Support

    Answered by Charlie on May 03, 2015 at 11:28 PM

    I've cloned your form and made some test submissions in my end, unfortunately, it seems like we can't create a line graph with the "Action Date" as a comparison for the weight data.

    I can forward this to our developers and see if they can add these feature to the form visual report builder. Unfortunately, I cannot guarantee that the changes will take effect immediately anytime soon or if it will be considered, but we will update you through this thread when we hear any news. What I could recommend is that you integrate using the Google Spreadsheet instead, here's a guide on that: http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet. It will give you more options and advance features to create graphs for your submissions.

    Thank you.

  • Profile Image

    Answered by wsfarm on May 04, 2015 at 12:29 AM

    Hi Charlie,

    Thank you for trying out the graphing function. I was fairly sure it could not be done but, particularly as a new user, I still have plenty to learn and sometimes don't realise what is possible.

    I would appreciate if you could add it to the list of improvements to be considered by the developers, though I realise that even if it is acted on it may take some time.

    Regards

    Charlie

  • Profile Image
    JotForm Support

    Answered by Charlie on May 04, 2015 at 01:40 AM

    No worries, everything can be learned. I would advise that you check our "Support" pages so to learn more about our form builder. You can check our List of Comprehensive User Guide and our YouTube Channel for tutorials. You might also check our Apps and Widgets page for tools that you can use to make your forms more productive.

    Thank you for your patience and understanding, we'll update you as soon as we hear any news on this. But as I've mentioned earlier, I think the Google Spreadsheet integration would be the best solution for now.

     

     

  • Profile Image

    Answered by wsfarm on May 04, 2015 at 07:48 AM

    Thanks Charlie,

    The problem with Google spreadsheet, I think, is that I would have to go in and manually update the graphs, because new data (form data from JotForm), though automatically loaded into the spreadsheet, may not be automatically included in reports that I might construct similar to the JotForm Visual Report grids/graphs.

    My brain is a bit tired after working out workarounds for searching on two fields in Grids and Submissions, and for sorting by date in Visual Report Grids.

    Perhaps tomorrow I can tackle Google spreadsheet graphs!! Does anyone have any ideas on how to implement automatically updated graphs using filtered JotForm data in Google Spreadsheets?

    Thanks for all your help so far

    Regards

    Charlie

  • Profile Image

    Answered by Ben on May 04, 2015 at 09:08 AM

    We can not quite assist with Google Spreadsheet since we can only provide assistance to our Online JotForm Form Builder, but I would like to point you to the right guides Charlie: https://support.google.com/docs/answer/63728?hl=en

    That will show you how to create a chart and on the right you will see the links to other segments that can also be useful.

    Now the trick with the charts is that you do not need to give it specific A2+B2 cell addresses, but you can also give them a range where the data is, so knowing this, you can give it (for example) A2:D1000 range to look for the values.

    Hopefully this has provided you with enough data to use it.

    You can go a step further as well, by including filters and filter views that would help you sort things out a bit. You can see more about that here: https://support.google.com/docs/answer/3540681?hl=en

  • Profile Image

    Answered by wsfarm on May 04, 2015 at 09:30 AM

    Hi Ben,

    Thank you for your words of advice. I will try to tackle the Google graphs in the next few days.

    As always I appreciate your prompt service and courteous manner.

    Regards

    Charlie

  • Profile Image

    Answered by Ben on May 04, 2015 at 10:29 AM

    You are welcome Charlie and thank you :)

    Do let us know as soon as there is something that we can assist you with :)