Google Sheet integration: option to update values in Excel.

  • Profile Image
    DV3 Citrine
    Asked on September 14, 2022 at 07:54 PM

    Hi, I want my form to intergrate with Google Sheet and update my values in Excel, only if one specific field is clicked(checkbox). Is that possible and how?
    Thank you.



    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Rene
    Answered on September 14, 2022 at 09:34 PM

    Hello dv3Cit,

    Thanks for reaching out to Jotform Support. Could you please give us an example in a screenshot so we can understand the requirement and respond accordingly? This guide will show you how to do that. Also please share with us the link to the form that is related to your concern.

    Once we hear back from you, we'll be able to help you with this.

  • Profile Image
    dv3Cit
    Answered on September 15, 2022 at 02:49 AM

    I haven't made a form yet, but let me explain.

    In a form I will have a checkbox for users, for accepting to sign up in a newsletter.
    The checkbox will not be required.

    So if the user accepts the newsletter, only those who have accepted will be saved in the google sheet.
    Is this posible to create a condition for this?
    Others will be notified only with a thank you email.

  • Profile Image
    Chae_R
    Answered on September 15, 2022 at 05:27 AM

    Hi there,

    Thanks for clarifying.

    Unfortunately, that's not yet possible. With Google Integration, all submissions will sync to the integrated sheet once the form is submitted. I've submitted a Feature Request to our Back-end developers. Please note that we cannot provide an exact ETA on when it will become available but rest assured that our developers will work on it.

    In the meantime, do let us know if you have other concerns.