Jotform Approval: Forward the status of the approval on the integrated google sheet

  • Profile Image
    data577
    Asked on May 13, 2021 at 01:25 AM

    Hi

    I have added an approval workflow to my form https://form.jotform.com/211178622297459


    I want only approved submissions to be populated in google sheets.. is this possible? Thanks!


  • Profile Image
    Vanessa_T
    Answered on May 13, 2021 at 02:28 AM

    Unfortunately, no that is currently not possible.

    The integration is triggered everytime the form is submitted regardless of the data or status within.

    You may however filter your submissions within your Tables page then manually export it to an Excel file.

    https://www.jotform.com/help/1009-how-to-use-different-filters-to-easily-manage-your-data-in-jotform-tables

    https://www.jotform.com/help/44-how-to-export-form-data-to-excel

  • Profile Image
    data577
    Answered on May 15, 2021 at 07:22 AM
    Thanks..
    Will the approval status be seen in the google sheets?
    Regards,
    ...
  • Profile Image
    Billy
    Answered on May 15, 2021 at 10:26 AM

    Hello,

    No, the approval status will not be sent to the integrated Google Sheet as it is not yet supported. I honestly think that having the approval status forwarded to the sheet would be awesome so I've already submitted a feature request. Hopefully, it'll be implemented soon.

    You can easily find the status of the approval on your Jotform inbox.

    1621088745_609fd9e93042a_

    Should you need further assistance, please don't hesitate to contact us back.

    Regards,

    Billy

  • Profile Image
    Paras_Sood
    Answered on June 24, 2021 at 08:32 PM

    Hi,


    When we download the excel file, would we be able to see the approval status along with the comments added at the time of approval?

  • Profile Image
    Billy
    Answered on June 24, 2021 at 09:44 PM

    Allow me to check further. I'll reach out again as soon as I'm done testing. Thanks!

  • Profile Image
    Paras_Sood
    Answered on June 24, 2021 at 09:49 PM

    The reason why I ask is that jotform tables is getting slow as we are adding more data to it. If we want to refresh and download all of the data onto our file servers so that we can clear up the storage on jotform, we need the approval comments as well.


    If there is no way to extract the approval comments then we cannot store data on premise because it would be missing information.



  • Profile Image
    Billy
    Answered on June 24, 2021 at 10:10 PM

    The only information you can download from the Jotform table is the Approval Status along with other information. See screenshot below:

    1624586243_60d53803ad188_

    We're constantly improving our services to ensure that all features would work smoothly.

    Unfortunately, there's no automated way on how to extract the Approval Comments except by copying them and pasting them on your clipboard or storage somewhere. Hopefully, the feature request that I created will be approved sooner.

    Try reaching out to our API team to see if they have any workaround for this. Kindly send them an email to api@jotform.com. Please note that I cannot guarantee that they'd have anything to offer.

    We're very sorry for any inconvenience this has caused you.