Is there a possibility to send data to different sheets?

  • christophschemel
    Asked on June 7, 2019 at 2: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!

  • Richie JotForm Support
    Replied on June 7, 2019 at 2: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.

  • christophschemel
    Replied on June 8, 2019 at 6: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 

  • Victoria_K
    Replied on June 8, 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 

  • christophschemel
    Replied on June 12, 2019 at 7:49 AM

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