Skip to main content

Good morning all 🌅


I’m wondering if there’s any method to filter a MarkDown Long Text field that contains checked and unchecked tick boxes? Interestingly enough, I can write regex formulas columns that return various values - but I’m unable to run a filter directly on the Long Text Markdown field.



Filter returns empty;



As a workaround I’ve employed the below formula - but would be far better if we could simply filter for this condition directly without the need for funky-formula.



REGEX_MATCH({Status}, "\\u \\]")



REGEX_MATCH({Status}, "\\ux]")

EDIT: Almost forgot, this check count formula;


(LEN({Status}) - LEN(SUBSTITUTE({Status},"t ]","")))/LEN(") ]")



(LEN({Status}) - LEN(SUBSTITUTE({Status},"tx]","")))/LEN(")x]")


Keen for any ideas.

I’ve never thought about this.


Can you filter by 0 or 1?




I’m sure some of the scripting magicians here would have a solution.

I’ve never thought about this.


Can you filter by 0 or 1?




I’m sure some of the scripting magicians here would have a solution.


Yah, absolutely you can. Filters and formulas are amazing, and make up for all the shortcomings of filters (but I won’t derail this thread with my other filter wants and needs 😛 ).


Example below of filtering the formula that calcs off of the Tick-box Markdown - which work well for a solution, but the problem is I don’t want to have to build formulas anytime I need to filter Markdown check-boxes.


Reply


Terms & Conditions