Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 17, 2021 03:14 PM
Hi,
I have 2 tables:
I’m trying to run an automation where when a director enters what she/he is looking for, it filters for all qualifying actors and sends an email to all qualifying actors.
Problem: the filter is showing an error. I’ve tried to only filter by age, only by gender but it always responds with an error like " Invalid filter on Min. Age".
Any idea what I can do to make the filter work?
Many thanks
Jan 24, 2022 12:50 PM
Reviving this question. I have the same issue where I’d like to check if a value lies between a min and max value of a list. Is anyone able to help figure out what’s causing the ‘invalid filter on {number field}’ issue?
Jan 26, 2022 09:00 AM
Welcome to the community, @Elisabeth_Schloemmer! :grinning_face_with_big_eyes: Could you describe your setup in greater detail? Screenshots would be very helpful (even if you have to mask out things for privacy).
Jan 26, 2022 09:38 AM
Hi, I figured this out. Can you share what you need and I’ll be happy to share the formula I used.
Feb 08, 2022 08:19 AM
Hi, thank you so much for the quick replies! I’ve been able to solve the issue with changing the trigger. It now runs on “When record is created” and the first action is to “Find records”. That way the error didn’t occur again.
I’ll take notes for what information to submit in a post next time, I can see that wasn’t quite clear.
Axel_Meta, I’d still be curious about your solution, perhaps it will help someone else down the line too.