Tables: Viewing Specific Data Updates and Revision History for Submissions

Is there a way I can see WHICH data was updated, only ask them to update specific data, and/or see the revision history? So far in tables I am only finding that the data was updated and it shows when the entire submission was updated. I am wanting people to update their data months later and I also still want to be able to see what they originally put. For example a volunteer group originally says they want to bring 50 people, and for their final information they are actually only bringing 35 and I want to be able to see both information. Is this possible?

Hi Program Director Esperanza,

Thanks for reaching out to Jotform Support. To meet your requirements, you just need to structure it so the original number is preserved and the final number is captured separately, instead of overwriting the same field. So you will need to add a hidden Number field that will only show when the form filler edits their submission.

Then set conditional logics that will show the field upon editing and disabling the original number field so they cannot change the value. With this setup, you can see both the original value and the updated value on Jotform Tables. Let me show you how:

1. In Form Builder, click on the Add Element button on the left side.

2. Add two Number fields then label them accordingly.

3. Now, click on the second Number field and click on the Gear icon.

4. Go to the Advanced tab, and enable the Hide field option.

6. Next, click on the Add Element button again, then go to the Widgets tab.

7. Search for the Get Form Page URL widget and add it to your form.

8. Go to the Settings tab at the top, then click on the Emails tab on the left side panel.

9. Hover your mouse to the right side of the Autoresponder Email and click on the Pencil icon.

10. Under Email Content, click on the Add Field button and select Edit Link from the options.

11. Once done, click on the Save Email button below.

12. While still on the Emails tab, click on the Conditions tab on the left side panel.

13. Select Show/Hide Field and Enable/Require/Mask Field elements from the options.

14. Set the recommended conditions below:

Check out the screencast below to see my results:

Give it a try and reach out again if you have any other questions.

This was a really helpful tutorial, I will give it a try! Thank you so much!!!

Hi Program Director Esperanza,

Your request has been answered and the thread is closed.

If you have another question or need more help, feel free to reply here and we’ll assist you right away.