Adding Columns to Submissions Results and Updating them

  • Profile Image
    inlinesolutions
    Asked 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.  


     

     

  • Profile Image
    BJoanna
    Answered 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.