Is there a possibility to send data to different sheets?

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
Richie

Jotform Support

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.
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
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
christophschemel
Answered on June 12, 2019 at 07:49 AM

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