Form Filtering and Population

  • Profile Image
    Prashant 
    Asked on November 07, 2014 at 07:36 AM

    Hello,

     

    I am a free user and planing to migrate to paid user. I need to create a filter where in if my form data (one particular field) belong to any of these numbers in the list, It should populate in sheet 1 of google, else sheet 2  etc.

     

    For e.g if first 4 digit of mobile number of a form response user belongs to any of the following:

    9739

    8432

    9999

    0000

     

    The entire form data should populate in google doc 1.

     

    Let me know whether you provide some tools similar to this.

     

     

  • Profile Image
    Welvin
    Answered on November 07, 2014 at 08:54 AM

    Hi,

    Unfortunately, we don't have a feature that would accomplish this one. But we have a Google Spreadsheet Integration. 

    http://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    A workaround would be to add a custom script in Google Spreadsheet sheet that would filter this data and move it to a new sheet which is according to your preference. However, we don't provide such script here. You need to find it in the list of Google functions.

    Thank you!