I am new to AppSheet. I am making a simple employee time app. Every employee needs to enter a certain number of hours a year and the app is designed to measure how many hours they have, how many they need for the year, and how many per working day they need to enter to meet the minimum. I have all of the logic set up in the Excel O365 spreadsheet already.
I have 2 sheets. One is the user spreadsheet that has the users by name, email, phone, initials as well as their respective yearly hour goals, daily goals, … With the security feature, I have limited each user to see only their information from this sheet/tab based on their email address matching how they signed in.
The other sheet contains the hours and lists those hours by initials (the same ones in the user sheet) and date. Here is an image of that sheet:
What I want to do in the app is have each user see only their own daily hour data, not the data of all of the other users. I think I need to reference the initials from the user and hour tabs together and then have it limit the view in the hour tab to only that which matches the signed in user. Sounds simple, but I cannot get it to work no matter how hard I try. I’m sure the fix is simple, but I can’t seem to get it.
Thanks in advance for the help.