Can I Apply the Updated Calculation to the Existing Entries on the Spreadsheet?

  • Sherrynp
    Asked on March 23, 2023 at 1:41 AM

    Hello,
    I have a jotform integrated with a google sheet. I have several hidden calculated fields on the jotform that use data from tables. During validation of my google sheet I realized that some of the calculations are incorrect. I need to redo the calculations in the jotform. I have 2 questions.
    1. Is there a way to make the new calculation apply to all of the submissions already submitted? and will that push over to the google sheet?
    2. If the answer is no to #1. Can I edit the data in the google sheet for existing cells and will my edits there stay? Or will they be overwritten when the integration refreshes?
    Thank you
    Sherry

  • Nora JotForm Support
    Replied on March 23, 2023 at 4:21 AM

    Hi Sherry,

    Thanks for reaching out to us for help. If you'd like to apply the new calculation to the former entries, you can edit the submissions so that they will be updated with the new calculation you've set up. Once you've done that and refresh the integration, your submissions will be pushed to an updated spreadsheet entirely. Let me show you how to edit submissions:

    1. Go to your Tables page from the dropdown list next to the Jotform logo on the upper left side of the page.
    2. Click on the Vertical Ellipsis icon on the left side of the entry, and select Edit Entry.
    3. Once the form opens, click on Submit as the form will be calculated automatically over again according to the new calculation formula.

    1679559613 641c0bbd14611  Screenshot 10

    As to your second question, whenever you make changes to your form, integration with Google Sheet breaks, so you'll need to refresh the integration by removing it and adding it back. Once you've refreshed the integration, you can manually update the existing cells, and they won't be overwritten as long as you don't refresh the integration again.

    Reach out again if you have any other questions.