Skip to content

    • Variables

    Variables

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

    Member
    in Variables

    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.

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      Answer ✓

      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.

      Please 💡/💖/👍/😊 this post if you read it and found it helpful.

      Please accept the answer if it solved your problem.

    Answers

    • Member
      edited March 21

      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

    • Member

      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.

    • Member
      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"

      image.png
    • Member

      @zaclingen_fwm ,

      Great, I will give this a shot. Thanks!

    • Coach
      Answer ✓

      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.

      Please 💡/💖/👍/😊 this post if you read it and found it helpful.

      Please accept the answer if it solved your problem.

    • Member

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories