Another Custom privilege-view field by user type

[goanna300]

I'm trying to enable users to view fields according to their values. I don't want to make the field inaccessible altogether.

something more elegant than this untested calc field:

If ( Left ( g.CurrentUser 6="doctor"), "Blood Test shows"&bloodtestresult , "CONFIDENTIAL" )

I'm sure this has been covered before, if so please just indicate previous post.

Steve

[Zero Tolerence]

Its not actually possible to "hide" the field, however, if you create a separate field, and put a calculation in it that does:

If( Left (g.CurrentUser; 6) = "doctor"; "Blood Test shows " & bloodtestresult; "CONFIDENTIAL")

Then just remove the bloodtestresult field from your layout and insert the new one with the calculation, that should work the way you want it to.

[comment]

Why not create a privilege set for doctors, and assign it to all doctors' accounts?

[goanna300]

Sorry, my fault for not making myself clear:

The calc field answer I got was the same as my suggestion of what I know how to do anyway;

comment's idea of doctor's priveleges was more of what I am trying not to do.

I'll try to be clearer:

In my solution of few layouts but many users, each user has the impression that the layout they see is their own (own name, colour,department).

I cannot define privileges by layouts because there would be too many layouts.

But I still need to hide certain field values from some users. Neither forms of permission will do the trick. I was thinking of something more elegant than a calc field.

(Oh bugger, this is starting to remind me of the old "show different fields on the same layout" wish-list item).

Steve

[comment]

You can define access privileges on FIELD basis - irregardless of layout.

You can also hide the confidential field/s from unauthorized users, using the visibility trick.

The attached file demonstrates both. Examine the Personnel privilege set, under Records (custom privileges) > Table Name ("Data") > Field Access.

DoctorsOnly.fp7.zip

Edited October 27, 2005 by Guest
Added a welcome message to the file

[Steven H. Blackwell]

Just a cautionary note. Mostof the visibility tricks will fail if the user can go into Find mode.

Steven

[comment]

In my file you are not allowed to go into Find mode. And you cannot see data in Find mode, anyway. But it is a good point to keep in mind in general.

[Steven H. Blackwell]

If you are using the portal visibility trick, going into Find mode will expose what is hidden behind the portal.

Steven