Adding Columns to Submissions Results and Updating them

  • inlinesolutions
    Asked on June 3, 2015 at 3: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.  


     

     

    Jotform Thread 581465 Screenshot
    Page URL: http://woodruffvolunteercenter.com/Custom/1.aspx
  • BJoanna
    Replied on June 3, 2015 at 4: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.

    Adding Columns to Submissions Results and Updating them Image 1 Screenshot 40

    Adding Columns to Submissions Results and Updating them Image 2 Screenshot 51

    Adding Columns to Submissions Results and Updating them Image 3 Screenshot 62

    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.