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

    How to create a report that ONLY contains the records which contain a certain value in a specific field.

    Asked by ebizz on September 26, 2011 at 04:15 AM

    Hi,

    I want to publish online the results of a report generated from the database of a specific webform, but the report should not include data that has not been checked.

    example Database :

    Name - Address - Country - checkbox

    I want to edit the records and check or uncheck the checkbox, then generate a report that only contains the records where the checkbox is marked.

    if not possible this way, is there any other way to do this, perhaps with the flag field in the record database ?

    Thanks

     

     

     

  • Profile Image
    JotForm Support

    Answered by mliz on September 26, 2011 at 09:19 AM

    Hi ebizz,

    This option should be available, when generating a report in JotForm you can select which fields should be included in the file.  To create a report please do the following:

    1.  Go to My Forms
    2.  Click on the form that you want to generate a report of
    3.  Click the Reports button in the toolbar
    4.  Choose Add New Report. The Reports Wizard should appear
    5.  Choose from a variety of formats for displaying your report.
    6.  In the Reports Wizard you should see the fields created in the form, check those that you wish to be included in the report.

    Hope you find this information useful, let us know if you have questions.

  • Profile Image

    Answered by ebizz on September 27, 2011 at 06:55 AM

    Hi Milz,

    Thanks for your answer, but our intention was that a complete record would automatically not appear in the report depending of the value of some field (that we edit after reception of the form) (and that eventually stays hidden for the user).

    For example : this way the report could keep track of invalid, cancelled, non-accepted or refused forms and the html report would then only show the valid records.

    Meanwhile we found some negative forum answers to such question, but maybe a suggestion to put on the feature request list ?

    Instead of 'not appearing' it might be even more usefull to develop a function that moves a record to a new form and new report (that would automatically be created ). You could see this option as an editable status field (hidden for the user) where we could define dropdown status labels (refused, cancelled, etc...).

    Thanks,

  • Profile Image
    JotForm Support

    Answered by mliz on September 28, 2011 at 04:31 AM

    Hi ebizz,

    Thank you for the brief overview of what you wish to achieve, I do believe this is a good feature request.

    I will forward this request to our development team and have them consider this to add in their todo list. However I can not give out a time frame as to when this will be implemented we'll let everyone know if this is completed.

    Thanks and warm regards.

  • Profile Image

    Answered by ebizz on October 03, 2011 at 07:51 AM

    Hi Milz,

    We could really make great use of this option now.

    We would like to pay for this development (if reasonably priced ...)

    How much would it cost to us to develop the above option this week ?

    PS: you can mail us personally.

     

    Thanks,

  • Profile Image
    JotForm Support

    Answered by liyam on October 04, 2011 at 03:57 AM

    Hi ebizz,

    What I can do for you is increase the priority of your request.  They will respond to this thread whenever they have implemented this feature.

    Thanks for your patience.

  • Profile Image

    Answered by ebizz on October 04, 2011 at 04:30 AM

    Hi Liam,

    Thanks for your response and effort, though I do fear a bit the lenght of your priorities list ...

    Best regards.

  • Profile Image
    JotForm Support

    Answered by mliz on October 04, 2011 at 04:59 AM

    Hi ebizz,

    Thank you for your interest in this feature. We have already marked this request as important.

    We too would love to see this materialized

    Cheers!

  • Profile Image

    Answered by ebizz on October 04, 2011 at 05:15 AM

    Hi mliz,

    Sounds great.

    Looking forward to your implementation notification.

     

    Cheers!

  • Profile Image

    Answered by tlynk on January 27, 2012 at 04:39 PM

    Has this been implemented yet?

  • Profile Image
    JotForm Support

    Answered by Mike_T on January 27, 2012 at 05:40 PM

    @Tlynk, It has been already assigned to one of our developers, but it is not yet implemented.

    We will update this thread once the feature will be available.

    Thank you for your patience in this matter.

  • Profile Image

    Answered by ebizz on June 01, 2012 at 05:51 AM

    Hi mliz , liyam,  Mike_T and Aytekin,

    We really need this feature NOW and we definitely want to pay for it.

    PLEASE give us a PRICE for developing this feature now.

    We would really hate to have to switch to another webform system !

    On 28th September mliz already found it a good feature.
    On 4th October liyam the priority of this feature request and mliz confirmed it was marked as "important" and that "would love to see this materialized".
    But that's 8 months ago and nothing happened despite that
    Mike_T said (also 4 months ago already !) that it was already assigned to a developer !

    Jotform is a great product and has incredible clever developers, and we are happy premium users since 3 or 4 years, but please allow me to insist kindly (but firmly) that you mail me asap your price ?

    Thanks already,

    Jean-Marie
    eBizz !

     

  • Profile Image
    JotForm Support

    Answered by Mike_T on June 01, 2012 at 05:48 PM

    I would like to inform that our Developers have recently implemented Google Docs Spreadsheet integration. You can use that feature to send the form data automatically to the Google Spreadsheet.

    I hope that the following workaround based on our integration would be useful for you. I would like to recommend you to configure Google Docs integration for your form, and then use the Google Spreadsheet Charts feature to get needed reports.

    Basic example:

    1. I have created this form:

    http://form.jotformeu.com/form/21525878485365

    2. Configured Google Docs integration.

    This is the link to automatically created form spreadsheet:

    https://docs.google.com/spreadsheet/ccc?key=0AtNi5VL70_zqdGQ5M1I3OUllLXhWWk5BRk15OWtXdWc

    3. Added two columns "Refused" and "Accepted".

    4. Used COUNTIF function to count number of words "Refused" and "Accepted" in selected spreadsheet range.

    =COUNTIF(E2:E100, "Refused")

     

     and

    =COUNTIF(E2:E100, "Accepted")

    5. Selected my custom "Refused" and "Accepted" columns and rows, and insert the Chart based on them.

    Moved it to own sheet.

    You can find that chart on the following spreadsheet.

    https://docs.google.com/spreadsheet/ccc?key=0AtNi5VL70_zqdGQ5M1I3OUllLXhWWk5BRk15OWtXdWc

    Is that acceptable workaround in your case? We are looking forward to hearing from you.