Add a custom search function

Hi everyone, im new to glide.

I need to add a custom search function where i enter a value and it retrieves the remaining data of that row, only when i press a button. not a dynamic search. how do i do that? Thanks in advanced

You could use a text entry component that write to a user specific column. Then set the action on your button to write that value to a second user specific column. Then populate the value from the second user specific column across all of your rows of data using a Single Value column. Then use an IF column to return true when your data matches the value in the single value column. You can then filter your collection based on that IF column value.