Selecting One Field based on Selection of Another

[proctors]

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

[Anil_Babu_Samineni]

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])

[marcus_sommer]

To control the data-access within an application there is a feature called Section Access.

- Marcus