How can I set up a text box Variable that can search for a text string in a field?

levi_kim

Hi Domo Community,

Like the title says, I'd like to set up a Variable to be used in a dashboard where users can input text and it will search for the text string in related reports and return the results. For example, I have a "Description" field for items. I'd like to search "6mm bolt" in the Variable/text box and have it return any attributes in the "Description" field that contain "6mm bolt".

I know how to set up a Variable. My biggest struggle is how do I implement in the Beastmode of a Card so it will work successfully? Thanks in advance.

DavidChurchman

For the original question, I have done something like this using a BeastMode as a card filter for every card on the page, filtering for 'Include':

CASE

WHEN Text_Variable IS NULL THEN 'Include'

WHEN Text_Variable = 'Default Text' THEN 'Include'

WHEN LOWER(Description) LIKE CONCAT('%', LOWER(Text_Variable), '%' ) then 'Include'

ELSE 'Exclude'

END

I set conditions for the Control variable either being null or for whatever default text I have set for that control variable so that it only filters the data after someone has entered something into it.

zaclingen_fwm

We use the Searchable Filter Card to let users search through a DomoStats dataset of Cards, Dashboards, and Datasets to find what they are looking for.

If you point that filter card to the dataset containing that "Description" field then it should work pretty easily.

Edited to remove the link to my instance. Search for "Searchable" in the app store to find it

levi_kim

Hi @zaclingen_fwm ,

Thanks for your response. Can you elaborate more on the search filter card and/or provide pictures? Your link takes me to your company's Domo domain which I cannot access.

zaclingen_fwm

https://community-forums.domo.com/main/discussion/comment/101126#Comment_101126

Yeah I realized after the fact that the link wouldn't work for you.

Navigate to the App Store and search for "Searchable Filter Card"

levi_kim

@zaclingen_fwm ,

Great, I will give this a shot. Thanks!

DavidChurchman

For the original question, I have done something like this using a BeastMode as a card filter for every card on the page, filtering for 'Include':

CASE

WHEN Text_Variable IS NULL THEN 'Include'

WHEN Text_Variable = 'Default Text' THEN 'Include'

WHEN LOWER(Description) LIKE CONCAT('%', LOWER(Text_Variable), '%' ) then 'Include'

ELSE 'Exclude'

END

I set conditions for the Control variable either being null or for whatever default text I have set for that control variable so that it only filters the data after someone has entered something into it.

levi_kim

@DavidChurchman Thank you for sharing your BeastMode! It worked perfectly for me. Much appreciated.

MegChambers

@DavidChurchman I hope you don't mind, but I am trying to do something similar to the OP. I am new to Domo and have been tasked with creating an expense dashboard. I was able to find my way through creating a massive ETL to get the proper dataset in place. But now I find myself stuck wanting the Management Team to be able to type "conference" and have the page filter to all expense records that contain conference across 10 different columns. I tried the Searchable Filter App, but it seems to compete with itself. I have now moved to creating a second ETL where I get the value from each column into one, then split it and do a dynamic unpivot to create a new dataset where I have a column for unique id and a column for the text. I just can't figure out where to go from here as I also attempted a Filter card, but let's say I have 225 rows containing that text, the user has to select each one. Ultimately, I am looking to have the user type a search term and hit enter, then the dashboard auto filters for them.