Integration with different google docs based on dropdown selection.

  • Profile Image
    plott
    Asked on August 09, 2015 at 12:43 PM

    Is it possible to write to a specific google doc based on the value chosen from a dropdown?

    For example, if my dropdown contains states: MA, NY, and CA - can I write to mysheet_MA, mysheet_NY, and mysheet_CA ?

    Thanks!

  • Profile Image
    EltonCris
    Answered on August 09, 2015 at 06:31 PM

    Sorry but this is not possible with Jotform. We do support conditions with any of the available integrations including google spreadsheet. You can however do this on the spreadsheet like if the a certain cell contains that value, copy the cell to another sheet.

    This article may be of help http://stackoverflow.com/questions/13126129/google-docs-formula-auto-copy-and-display-cell-if-contain-a-specific-word.

    Thanks!