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

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.

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

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

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, 200520 yr by Guest
Added a welcome message to the file

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

Steven

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.

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

Steven