Is there a possibility to send data to different sheets?

  • Profile Image
    christophschemel
    Asked on June 07, 2019 at 02:02 PM

    Hi,

    is there a possibility to send data to different sheets depending on conditions? I guess not, but this would be very helpful, please escalate.

    Thanks!



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

  • Profile Image
    Richie_P
    Answered on June 07, 2019 at 02:18 PM

    To clarify, do you want to create a different Google Sheet and send different data depending on condition?

    Can you please explain further how you want this feature to work?

    Looking forward for your response.

  • Profile Image
    christophschemel
    Answered on June 08, 2019 at 06:58 AM

    What I would like to do is as follows: Using the google Sheets integration I would like to send the form-data to sheet A if the user has clicked on X and to sheet B if user has clicked on Y.


    Thanks 

  • Profile Image
    Victoria_K
    Answered on June 08, 2019 at 11:00 AM

    I'm afraid multiple gsheet integrations are not supported for single form. I can suggest to check if you can implement conditional importrange function to copy data from integrated sheet to 2 other sheets. 

    Here are few links I've found:

    https://support.google.com/docs/answer/3093340?hl=en 

    https://stackoverflow.com/questions/41679844/importrange-with-conditions 

  • Profile Image
    christophschemel
    Answered on June 12, 2019 at 07:49 AM

    Hi Victoria, yeah, that could help! Thanks alot for the idea!