Posts

Showing posts from May, 2026

Tall & Fall

This is a concept I fabricated. Sometimes users would ask me to create a saved search and have a filter for a checkbox. That seems simple enough. NetSuite does allow users to filter based on the checkbox status - either unticked or ticked. But users would sometimes request to be able to filter ticked, unticked, or both in the results. As a workaround, I recommended to use a formula (text) as an available filter, where users can type t , f , or all . The criteria filter would be a formula (text), returning tall or fall (true or false respectively). It worked I guess. When doing this however, I recommend not adding other formula (text) filters in the criteria. Doing so will apply AND logic, and can mess up search results.