Hello! So I have a Table called "Status Official Data Table Official" and a View called "Feed" that shows a person's availability throughout the day. I have another Table called "People Contacts Manager 3" and a View called "Friends" that shows the user's friend list.
So I want people to add their own friends and allow them to see their data, but there isn't a "Friend Request" feature on AppSheet and I need a good formula for the Security Filter on Table "Status Official Data Table Official".
My best attempt is creating a "Friend Key" row that is a Unique ID that allows a user to see someone else's status updates using the Security Filter:
IN([Friend Key], SELECT(People Contacts Manager 3[Friend Key], [Friend Key] = [Friend Key]))
The only problem with that is that if that "Friend Key"(UUID) gets leaked to others, then any user on this platform can see another user's status updates.
SO, I am trying to make a security filter that has a condition: If "User1" is on your contacts list (People Contacts Manager 3) and YOU (User1) are on "User2"'s contact list (People Contact Manager 3), THEN the status updated from the Table "Status Official Data Table Official" are SHOWN.
This is essentially... you have your friend on your friend's list. They have you on their friend's list. When this happens, you can see their Status Updates and they can see yours. IF you take them off your contact list (or friends list), then they cannot see your status updates anymore.
SOOO does anyone have a good Security Filter formula that could do this?
LinkedIn
Twitter
