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

    Submission page: Adding notes, without needing hidden form fields and editing submissions

    Asked by pardop1 on September 01, 2015 at 11:21 AM

    Are there any updates planned for the backend of your program? the submissions grid is extremely limited in function and downloading the information to an excel spreadsheet doesn't solve the issues bc any new forms received after the download are obviously not included. My specific concerns include the limited number of columns that can be viewed at a time. I also would like to add info (like office notes) as forms come in. I am currently using the hidden form field work about, but this is not time efficient and I consistently have issues with the hidden fields displaying out of order on the form when I edit a response with the info for the custom field. I know you developed tools to import forms that former adobe forms central users used to import the forms. It would be great if you could also evolve your software to adopt some of the features of that program's back end that were really great.

     

    Thanks,

    Pam

    submission grid Submissions excel office hidden hidden note add note submission note
  • Profile Image
    JotForm Support

    Answered by Boris on September 01, 2015 at 01:49 PM

    If I understand you correctly, you would like to have the ability to add your hidden notes to each submission, without having to use a hidden field on that form and edit your submissions in order to attach the notes.

    If this is correct, please let us know, and I can raise it to our developers as a feature request for possible implementation in the future. We can't offer any estimates on when or if it might be implemented, but it would get on our developers radar and would be tended to according to the workload of our developers.

     

    Until such time that this feature would be implemented, and if you don't like to edit submissions to enter this information directly on the form, I would like to let you know that you can also integrate your form with a Google Spreadsheet, which would be automatically updated when new submissions occur.

    Then you can use the Import Range function to have your own spreadsheet populate itself with data from that integrated spreadsheet, and make notes in your own spreadsheet.

    This is a workaround much like the one with a hidden field and editing submissions, but this one allows you to have an updated excel file with notes in it.

     

    Please let us know if I have understood your request, and if you would like us to raise it to our developers as such, and we will be happy to do so. Thank you.

  • Profile Image

    Answered by pardop1 on September 03, 2015 at 12:46 PM

    Yes, you did understand me correctly. If you could present to the developers, that would be great. Thanks for the work around, I will see if it does what I need. It sounds like it will.

    Pam

  • Profile Image
    JotForm Support

    Answered by Boris on September 03, 2015 at 02:09 PM

    Thank you for your confirmation, Pam. I am forwarding this thread as a feature request to our developers.

    As said above, we can't give any promises or estimates on when or if it would be worked on, but if it does get implemented, we will be sure to let you know through this thread.

    Thank you.

  • Profile Image

    Answered by dohafamily on September 18, 2015 at 04:03 PM

    Hi Boris -

    I would like to echo Pam's request for the ability to add fields that we can edit. In AdobeFormsCentral we could add fields and change submissions as needed - for example, we would add a field for our notes or several fields for other purposes, or when a registrant had provided the wrong email address then we could go in and make the changes on the form.

    I'll look into the Google Spreadsheet option as well but it would be nice to have a more user-friendly data interface on JotForm itself.

     

  • Profile Image
    JotForm Support

    Answered by BDAVID on September 18, 2015 at 07:59 PM

    @dohafamily, I will raised a request on your behalf here: http://www.jotform.com/answers/665616

  • Profile Image

    Answered by Curt Rode  on October 28, 2015 at 05:03 PM

    Let me add to this request.  The addition of this feature may positively influence our decision to subscribe.

    Thanks for looking into it.

     

  • Profile Image
    JotForm Support

    Answered by jonathan on October 28, 2015 at 08:53 PM

    @Curt Rode

    Thank you for letting us know. 

    A feature request ticket had been submitted already.

    Our developer will provide update on this thread once available.

  • Profile Image

    Answered by pardop1 on October 28, 2015 at 09:55 PM

    @Curt Rode

    @dohafamily

    I've used the integration with google sheets (GS) and although it is better than the grid on the submissions page and super easy to add to any form, unfortunately, there are known issues with it and for no apparent reason, data from fields stop being delivered to the GS. I also find the features of GS far limited compared to excel so it would really make sense to upgrade your back end into something that allows meaningful interaction, easy editing of the fields, etc. Forms Central really got that feature right. 

    Thanks for escalating this issue.

    Pam

  • Profile Image

    Answered by Sammy on October 29, 2015 at 05:22 AM

    Thank you for the update Pam.

    In some cases the syncing of data may fail between the form and the spreadsheets, a re-integration usually resolves the issue.

    The feature request ticket has already been forwarded to our development team but we haven't received any updates regarding it, If there is any new information you will be updated via this thread.

  • Profile Image

    Answered by pardop1 on October 29, 2015 at 06:01 AM

    Thank your, Sammy. However, a re-integration, I believe, will then assign a new address to the Google sheet which has to be shared w those who need access to it. Less than ideal.