I’m getting ready to go live with an app and am wanting to be sure I have privacy set up so that sensitive data is not accidentally compromised. I have a lot of “dependent” data that should only show if linked items are visible to a user but am not seeing any sort of feature in the privacy area that says something like “if linked value is visible to user.”
For example, let’s say I have the following tables:
Published to User? (e.g., Yes, No)
Item (e.g., Button, Text)
Item Position (e.g., 1, 2, 3)
Published to Report? (e.g., Yes, No)
In this scenario, the items are things like buttons, text, and images, but some of them are part of a draft while others are live. I’m wanting to ensure that a user can only see the Report Items if the related Report is published.
Is there some way to set this in privacy? I know I could enforce this via workflow logic, but I need to be certain a nefarious user couldn’t somehow get to data.