Hello everyone,
I am trying to make an app that will be published in different app stores.
In this app, I am trying to restrict access to certain data. I've been doing my research, and I have discovered both Private tables and security filters, but what I really need is a mix of the two.
I need something where users can only view their data in a lifestyle app, but where there are other people that can also view their data through a code that the user provides them. So I can't have private tables, but I can't figure out how to make this work through security filters.
This is my security filter code:
OR
(TEXT(Add General User[General Patient Code])=ANY(Generate Patient Code[General User Code]), NUMBER(Generate Patient Code[General User Code])=ANY(Add General User[General Patient Code]))
From my understanding, this code is saying that can be viewed if someone has input a user code that matches one in the database, and if a general user's code matches one someone inputs, they should be able to see the data of the person who has input their code (hope this kind of makes sense).
Does anyone know how I can achieve this goal?-
LinkedIn
Twitter
