How can Google Sheets display different data to different users if they are on the same sheet?

Question

Google Sheets

There is a need, if the user enters a certain page, put an inputbox / search cell and display the results to him in other cells.
But if another user logged in, then he will see the result of the request of user 1, which he does not need.
Is it possible to make, using Google sheets, what would one table at the same time be displayed differently for different users?

Answer 1

Good afternoon!
Perhaps the system of personal filters will help in solving the problem.
https://support.google.com/docs/answer/3540681?aut...
see filtering modes

Answer 2

All this allows you to make google sheets and API triggers
. You need to write a script.
Use the onOpen trigger
As soon as someone opens the table, you can pull the user property where the account will be known, for example [email protected] . Next, write the logic of the table based on the received user property.