How can I integrate multi-field questions with Zapier?

  • Profile Image
    EUSdata
    Asked 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 as 

    Slighly 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??

  • Profile Image
    Adrian
    Answered 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.