Just wanted to share this trick to filter data in a DVL
For Example, if I have a sheet with numbers and names then I need to add another column to be the condition to filter by
In this example I have a number column and a name column and the 3rd is the search column.
In a separate sheet have the same two column headings
In the row immediately below the heading of the first column, enter this function
Now in Thunkable, add a DVL and bind it to the second sheet. Have a button to update the search column in the first sheet. When the value of this cell is updated the second sheet will reflect the filtered data.
You will need to refresh the DVL to get the filtered results
Hope you find it useful.