Form submission: a method to keep track of edits/updates

  • PDInc
    Asked on February 25, 2020 at 2:52 PM
     

    I've built a form for my managers to use to set goals for the people they manage.  When the managers complete and submit the form their employee receives their goals in a PDF via email.  The manager then follows up with their employee to see if they have completed their goals.  During this time, the manager uses the edit link to open the employee's form and selects "Hit" or "Miss" on the form for each goal that was set.  If all the goals were hit, new goals are added to the form and the form is re-submitted.  This process continues monthly.

    Everything works great except I want to track how many times my managers are conducting these Goal reviews with their employees.

    Unfortunately, editing the form does not show me how many times it has been edited.  

    Can someone help me with a solution?  I just need to track how many times a form is being re-submitted.

    A function to "Edit form and submit as New Entry"  is much needed!


    Thank you!




     
  • Girish JotForm Support
    Replied on February 25, 2020 at 6:46 PM

    I understand your concern.

    Unfortunately, at the moment the only way to keep track of the number of times a form was edited, is via the emails received. When you enable "Send on Edit" on the email Advanced tab, each time the form is edited, you will receive an email.

    The function that you have suggested is good one, but the reason why that function is not present is because, then each edit will increase the submission count.

    I have anyway forwarded this as a feature request to our back end team to check a method or system to track the number of times a form was edited.

    But we will not be able to provide an ETA of when or if this feature will get implemented. But, once it gets done, you will be notified via this thread.

  • PDInc
    Replied on February 27, 2020 at 5:37 PM
     

    Thank you.


    Do you know if I can accomplish my request by Google Sheet Integration?  Possibly push the submissions to a google sheet and then build a copy command to to another google sheet that would accumulate all original and edited form submissions?

     
  • Girish JotForm Support
    Replied on February 27, 2020 at 7:32 PM

    When you edit a submission, only the edited/final value is stored on the Google sheet. It does not create a new entry.

    However, when you integrate Google sheets, first you can copy over the original submissions to another spreadsheet file and after editing, you can copy over the edited submissions (the original submissions will be replaced by the edited submissions in the integrated Google sheet). So in your new file, you will have the original and edited submissions separately. But, this process can be tedious.