- TerriHAsked on April 22, 2015 at 02:55 PMI posted this in the general forum discussion but am needing an answer pretty quickly as we are looking to implement this form soon. Thanks!
Asked by TerriH on April 22, 2015 at 01:44 PM
Here is what we'd like to have:
In Forms Central, our submissions grid view allowed us to insert additional columns. In those additional columns, we are able to label them as we'd like as well as fill in the columns once submissions are received.
For an example, please see the attached screen shot.
"Final Art Due Date" & "Person Completing Project" are columns we inserted ourselves. Each time a submission comes in, the grid is updated and it also retains those additional columns.
In those columns, we are able to then manually enter in the "Final Art Due Date" as well as the "Person Completing Project". In addition, we are able to color the lines. (Purple = project started, Green = project sent to field for review, Gray = Project complete.)
This allows us to know when a project is due, who is doing it and when it's complete. This information never goes away.
- JotForm SupportjonathanAnswered on April 22, 2015 at 04:13 PM
The data Submission View page is not modifiable as it is part of the back-system.
But base on the description of your current requirement, there are multiple different ways to achieve this also in JotForm.
1. Add a hidden field in the form during design using the Form Builder.
Since it is a hidden field, the end-user will not be able to see and fill-in the field. The hidden field will then appear in the View Submission page as an empty column.
You will be able to edit/update the submission and fill-in the empty field with your updated data. You can update by using the EDIT button in the submission page.
2. If you add the hidden field mentioned in option#1, you can also generate Excel Report and you will be able to see the empty column on the report. You can then manually update the report also.
Hope this help. Let us know if this will not work for your requirements.