-
christophschemelAsked 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 SupportReplied 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.
-
christophschemelReplied 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_KReplied 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
-
christophschemelReplied on June 12, 2019 at 7:49 AM
Hi Victoria, yeah, that could help! Thanks alot for the idea!