I have denied access to some fields for some users in my Filemaker
database. When I log in as those users, these fields display a "No
access" text. Is it possible to hide the field completely instead, ie.
make it invisible for those users who do not have access to it?

I'm on Filemaker Server 8, Mac OS X Server 10.4.

--
Thomas Hansen : th(at)ambolt.no : http://www.ambolt.no/

One way would be to have two layouts, one without the "secret" fields
and use scripting to determine the users and load the correct layout. An
example of this came with FM8 (search help for startup script):

Go to Layout ["Welcome layout"]
Pause/Resume Script [Duration (seconds); 3]
If [Get( AccountName )= "Lynn"]
Go to Layout ["Simple layout"]
Else If [Get( AccountName )="Ann"]
Go to Layout ["Complex layout"]
End If

Michael Paine


Thomas Hansen wrote:

In article <violon-3731CE.13581324102005 (AT) sunsite (DOT) dk>,
Thomas Hansen <violon (AT) online (DOT) no> wrote:

You could deny them access to the layouts containing those fields. That
might mean you need to make new layouts that only contain the fields you
want them to see.

Bill Collins

--
For email, remove invalid.

In article <bbcollins-8C9F7A.09290324102005 (AT) news1 (DOT) east.earthlink.net>,
Bill <bbcollins (AT) invalid (DOT) earthlink.net> wrote:

Yeah, that's what I figured. The problem is, if I ever want to make some
changes to the layout, I'll have to do it two places.

--
Thomas Hansen : th(at)ambolt.no : http://www.ambolt.no/

You can use hidden portals to hide fields. Define a calc field that has
a case() statement so that if the current user's groups or privilege
sets are good enough, the calc will equal the record ID field. Create a
relationship from this calc to the same table's record ID field. Base
your new one-row portal on this. Draw the portal around the group of
fields you want to hide -- or do it one field at a time. When the user
is of the right group, the fields will show.

Thomas Hansen wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance