Form Filtering and Population

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



    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:






    The entire form data should populate in google doc 1.


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



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


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

    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!