Hi,

I am trying to limit the fields that a user can use and I don't know what I am doing wrong.

In privileges under records I have clicked limited and in the calc box titled "Records can be edited when" I have entered

Get(ActiveFieldName)= Comments

I have made sure that editing is allowed on the layouts but it doesn't work. I have tried using a if statement

if(get(ActiveFieldName) = Comments;1;0)

but that doesn't work either. What am I doing wrong?

Please Help

Thanks

It's a bit of a catch-22. You can't get into the field unless you have access, and the field won't be active unless you're in it.

Instead use the Field Access section of Custom Privileges to restrict which fields can be edited.

As it stands now the field access is set to all. The calc is in the edit portion. The cursor goes into the field, but if I try to type into it, it tells me the privileges won't allow me to. I want the user to be able to view all fields but only edit the comment field.

Change Edit access to "yes" and Field Access to "view only" for all but the Comment field. The Comment field should be "modifiable".

never mind I get it thanks Ender I appreciate it.

You could also look into Merge Fields if this is for some kind of Report.