Google Sheets Integration: approval status

  • ahovious
    Asked on June 26, 2021 at 8:58 AM

    I have gone through all of the work of getting my approval workflows completed and my form designed. I am relying on my Google Sheets integration to capture the data so I can use Tableau to show dashboards. However, I only want to see Approved forms in my Google Sheets, or a way to filter them. Is it possible to include a field for Approval Status -or- to not move it into Google Sheets until it is approved? Or some other work around?


    Thank you!

  • Carlos_C
    Replied on June 26, 2021 at 2:25 PM

    Hello There!


    I'm currently looking at your form, I'll update you on this same thread as soon as I have some news.


    Regards

  • ahovious
    Replied on June 26, 2021 at 3:02 PM

    Here is the specific form I am referring to, sorry I didn't include in initial message.


    https://form.jotform.com/211744346691156

  • Carlos_C
    Replied on June 26, 2021 at 4:39 PM

    Hello There


    Thanks for contacting support.


    I've checked some options, but unfortunately, your request is currently not possible.

    The integration is triggered every time the form is submitted, regardless of the data or status within.

    However, you may filter your submissions within your Tables page and then manually export them to an Excel file.

    Please check the following links if you want to try that option.

    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

    Regards