I have my company database where a table stores the employee (they are also users) data, namely Employee Name, Employee Email and Phone Number.
Each employee logs in with his/her respective Email.
Now I want to create a menu view named ‘Profile’ which when tapped will take the particular person to a view that contains only his/her data from the Employee table.
I have added the Employee table in my appsheet and included it in the “Profile” view. When the profile view is tapped, it takes one to the complete list of employees rather than the concerned one.
It needs an action that will filter out other users, like ( if useremail()=firstname.lastname@example.org, linktoview(abc’s profile)).
Is there a way to just show the employee data from his/her particular row from the ‘Employees’ table?
I need help, please.