Solved: Hide or show column based on view of another colum... - Page 2

Miguel_Azevedo · 05-08-2024 10:29 AM

I want my 'Code' column to be blank, and only become visible again if the user searches in the search bar for a code that is present in my 'Code' column in the database.
Rule: The lines containing this code should only become visible again if the user types a complete code. If he searches or filters using only part of the code, the lines containing the code should not become visible again.

With this in mind, if the user types a complete code found in the database, the 'Code' column must be visible and show the lines that contain this code, consequently I want my other columns 'Name' and 'Status' be visible too.
Example: All columns are hidden, a user searches for a complete code found in the database, the line with the code becomes visible and so do the other columns.

lynchk21

I don't believe you can do this using the built-in search bar.

You can create a column for "Search" on another table and have the user enter the code in that column and then have a slice where [search]=[_thisRow].[Code] and you can navigate to a view of that slice on submit of the code. Something like this tutorial: https://www.youtube.com/watch?v=5lQ3roJG0Hw

View solution in original post

Hide or show column based on view of another column