I’m quickly building an internal app to share daily revenue data and budget completion with our salesmen using google sheets (it was quicker for me as data comes from excel and power query).
The use case is an admin using the app. Admins can see the data of all salesmen.
Similar to the table block a softr , where we can add a search bar to filter the data, I want to create a custom search bar that stays at the top of the page and allow admins to search for each salesman and have data in all tables and all graphs be filtered accordingly.
Is it possible with custom code and google sheets data?
Thanks in advance!