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

    Adding Columns to Submissions Results and Updating them

    Asked by inlinesolutions on June 03, 2015 at 03:13 PM

     

    Hello, we've recently migrated from Forms Central. A user has a situation where she needs to add columns to the form submission so she can update status of the requests that are coming in as work orders.

    Here is her e-mail.

    Assigned To        Status        Billable        Account for 8424

    In JotForms we also need columns with the following tab names and be able to type details in these columns as well.

    These aren't form fields to be filled out in the form...but those columns need to show up so they can be updated.

    How do we go about this in Jot Form.  


     

     

    Page URL:
    http://woodruffvolunteercenter.com/Custom/1.aspx

    Screenshot
    Submissions report
  • Profile Image
    JotForm Support

    Answered by BJoanna on June 03, 2015 at 04:47 PM

    Unfortunately that is not possible to achieve inside of form submissions.

    Possible workaround would be to add those fields (Assigned To, Status, Billable, Account for 8424) and hide them. That way they would not be shown inside of your form, you would have them inside of your excel report and then you can add your comments inside of excel report.

    Here is demo form I made: http://form.jotformpro.com/form/51535996152967? 

    Inside of this article you can find out how to create excel report:

    http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel 

    http://www.jotform.com/help/101-How-to-create-an-Excel-Report 

    Hope this will help. Let us know if you need further assistance.