Filters From Google forms

Hey i was building an Qualified Lead Automation for one of my client and i got responses from the forms basically all of the customer details one of which is revenue now i want to filter only those leads who has revenue $20000 or more but when i use native filter it does not pass through the filter.

Is it because numeric operator does not identify with β€œ$” ? what should be my filter?

Hey @Rohit

I think you can use this filter
Screenshot 2024-01-01 161457

1 Like

So mine should be replace(revenue; $; empty string )? Right

Welcome to the Make community!

To avoid us guessing what is going on in your scenario,

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to better assist you here. Thanks!

1 Like


So mine should be replace(revenue; $; empty string )? Right


and tell me it is working or not

1 Like

Hey @Rohit ,
Hope you are doing well,
try using the filter that i am providing below.

Let Me know if this helps.