Using include with Tables: Apply Filter
Is it possible to filter a table using the str.includes() method as an advanced filter.
Pretend my table includes these values in a table:
- Gala apple
- Fuji apple
- Green apple
And I want to pull all records where the field contains "apple". How would I go about doing this?
Thanks,
Adam
Best Answer
-
Hi @Adam_636382 - you can't do that directly in "Tables: Apply filters" but what I'd recommend for that case is to first add a column to the table, then run "Tables: Apply formulas" to run the advanced logic you want to fill out that column with true or false and finally filter on that new column. Let me know if that helps!
6
Answers
-
I recommend upvoting the related Idea for "Applying an IS IN filter to rows in a table using the advanced filter for tables."
Tables: Apply filters - Contains text
https://community.pushbot.com/discussion/405/tables-apply-filters-contains-text1 -
I've shared a pattern that does exactly this in Show and Tell. It is available here.
0