- EUSdataAsked on March 28, 2018 at 08:20 PM
I currently would like to integrate Zapier with google form; this has worked fine in the past, however there's one problem I'm running into. The results of input tables are concattenating into one response, e.g. a multitable with 6 questions will yield one bulk response asSlighly Disagree|Slighly Disagree|Neutral|Slighly Disagree|Slighly Disagree|Slighly Disagree
This is crucial for constant integration, and I can't seem to find an easy workaround :/. I do not want to add the "Form Calculation" widget for every answer, that'd be too verbose (we're talking about a 86 question survey). Any tips??
- JotForm SupportAdrianAnswered on March 29, 2018 at 07:58 AM
I am glad you have managed to find a workaround.
@jotform team, if your spreadsheet exports can parse input tables into multiple columns, so should zapier's api! Get on that team, I love your stuff!
Yes, it is true that the Input Table rows are displayed in separate columns when you export the submission data to Excel from the submissions page but I am not sure why Zapier cannot make that distinction. The pipe character between the answers seems to have helped you, however, extracting the data from the spreadsheet.