Only show results after user searches key

AppSheet AppSheet Q&A
, ,
1

Hi,

I want to create a dashboard that will initially be empty. Then when the user login in and searches based on a key, the results of the dashboard will show up according to that key.

The data feed is from google sheets, where each row of the table has a key.

The reason for this is I’m building a customer portal where each customer can see the progress of their applications. But I want to ensure customers don’t see other customers applications, hence why I need to have the dashboard empty to begin with. After the user inputs their key, it will show the results of all their applications only.

2

I think it’s not working on the search bar. You must have a quick edit column; once the column was filled, then the result was shown to the user.

Try to put in the Show_If

Example:

IFS(
[Password] = Enter your password here, USEREMAIL() = example@gmail.com
)

USEREMAIL()