- PrashantAsked 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.
- JotForm SupportWelvinAnswered 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.