0

Searching not working as expected (new to Ninox)

I have a column with a Status. It has values like Complete, Partially Complete, etc.

I just want to show the values where it's "Complete", but I can't figure out how to enter that in the search field so the other "Partially Complete", etc., don't show up.

What's the proper way to search?

7 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    You can try:

    ="Complete"
    
      • ninox.1
      • 2 yrs ago
      • Reported - view

      Fred Thanks but that doesn't work. Appreciate your reply.

      • Fred
      • 2 yrs ago
      • Reported - view

      Mike Just to be clear. If the field a choice field then you would select the option like the picture Lars posts.

      But if it is a text field then my suggestion does work. In case others are wondering why it is not working for you.

      • ninox.1
      • 2 yrs ago
      • Reported - view

      Fred I tried your approach with several text fields. I had one with the text "None at Present". If I searched for ="None", I get nothing. I'm using the search window in the upper left.

      • Fred
      • 2 yrs ago
      • Reported - view

      Mike Oh, we are talking about different things. Sorry, I was talking about filtering your columns.

      Mike said:
      I have a column with a Status. It has values like Complete, Partially Complete, etc.

       So I thought you were talking about when you right click on a column name.

      Yes, that overall table search is not very helpful. It is better to filter. Or if you are constantly looking at records that are in various Status then maybe a dashboard would be more helpful.

    • Lars
    • 2 yrs ago
    • Reported - view

    If you use the "Choice" type for your status field, you can directly filter by value. Filtering is easier than searching. And you can still search for other keys on top of the filter

      • ninox.1
      • 2 yrs ago
      • Reported - view

      Lars Yep, thanks. I just found that. :)

Content aside

  • 2 yrs agoLast active
  • 7Replies
  • 89Views
  • 3 Following