Hi All,
I was wondering if anyone could help, I have a scenario on Forms which I can't find a solution to.
I need to filter lookup results based on the user who is logged in and it is critical from a security standpoint that users don't have any means of seeing data intended other users. As a basic example, I would have a number of rows in SQL and a column identifying what users can see those rows.
At face value, I can achieve this by adding a hidden field populated with {/_currentuser} or {/_currentuser_display} and have that as part of the lookup rule, however as far as I can tell, this won't work from a security standpoint because a user can inspect page and modify the value of that field using the browsers dev tools.
Is there a way to pass verifiable session information rather than just the username? My problem with using the username is that it is static, highly guessable and isn't linked to the fact they have actually authenticated as that user.
In terms of the backend, is the session information stored in the forms database? Can I use javascript to add values from the authentication header into the lookup field which could be checked against the forms DB?
(for reference, this question is related to on-prem forms rather than Cloud)
Thanks for your help,
Alistair