Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to limit a productivity such that the logged in user can look at only their data.
We are able to load the user name using OSUSER(). The table loads all clinicians (Clinician Name) and their emails (Email). I created a variable to determine if the OSUSER is equal to the email (the email contains the username before the @ symbol). For example USUSER () = jackson and my email would be jackson@email.hospital.edu. I can do some trim to just compare.
Anyway, I want to use an OnLoad trigger to have the Clinician Name Field selection box = the current OSUSER(), which would be Michael Jackson. How can I get the OnLoad trigger to select the full Clinician Name?
Thanks in advance
Perhaps you could try
SubFiled(email, '1', '@') as email_uname
And then,
If(OSUSER() = email_uname, 1, 0)
OR
If(OSUSER() = email_uname, [clinical name])
To control the data-access within an application there is a feature called Section Access.
- Marcus