Edit - Limited - Field

[Questions King]

Hi all, I want to do is: Can I create a password can only edit one of the field in records (I call it Date field)?

1) Password A --> Admin = access all

2) Password B --> User = can create record and can only edit the field (Date field)

Any idea for me?

[transpower]

There is no Boolean access method for fields, just for records. You could make two separate layouts, one for Admin, one for User. The one for User could display all fields, but only allow entry to the Date field. But other forum members dislike using (near) duplicate layouts; they use a complex set of overlays to get the same effect.

[Vaughan]

You might be able to do something with field level validation, with the calculation looking at the current user's privilege set.

[transpower]

Hmm...maybe a validation by calculation like Get ( AccountName ) = "Admin"

This would have to be added to every field other than Date. Neat.

[LaRetta]

Transpower said ...There is no Boolean access method for fields...

Actually there is. You can restrict this User to View Only, Questions King, but still specify that they can edit only one field (your date field) and also only create new records. You were on the right track ... you need a new Privilege set.

On this new Privilege set, select Records > Custom Privileges. Select your table (which contains this date field).

View: Yes

Edit: Limited

Create: Yes

Delete: No

Field Access: Limited

On Edit (Limited), enter your calculation, such as: Get(AccountName) = "ThisPerson." This is where the boolean logic is applied. Then on Field Access (Limited), set the Privilege on your date field to Modifiable (the other fields should be left as View Only).

Much 'neater' than adding a validation to every field but the date (major pain) and more resource-friendly and easier to maintain that duplicating layouts; which I don't believe in either.

LaRetta

[transpower]

It's Field Access | Limited | View Only for all fields other than Date. Neater.

[LaRetta]

Field Access | Limited | View Only for all fields other than Date ...

Well, that would be the around-about way to do it. If you duplicate a read-only access privilege set, the Field Access automatically selects 'Limited' & 'View Only' for ALL fields. Then you would just change the one date field to Modifiable.

If you duplicate a data-entry privilege set, Field Access will flag 'All' and 'Modifiable' for every field - and you would have to change every single field in your table back to 'View Only'.

I'm glad, Transpower, that you duplicated the wrong set - it allowed me to catch other's possible mis-thinking on this. I always start with a privilege set similar to what I want to achieve (in this case Read Only) and I suppose I should have mentioned that.

[transpower]

Thanks, LaRetta. Very enlightening.

[Questions King]

Hi all...thanks for your help! Look like after my holiday all the problem solve!