Resctict field access upon calculation

[Paolo]

Is there any way to restrict the access to a field depending on the result of a calculation ?

[Ugo DI LUCA]

Yes, validate by calc. Have a look at RussBaker post in the Sample section. Note that if this field is a lookup, this would not work.

[Paolo]

thank you.

Write protection is easy, with validate by calc.

Read protection (hiding the field to some useres) is a bit trickly.

If I understood what RussBaker does, I have to hide the text with the same text in background color when the user is not allowed to see.

This is accomplished with a calc field that assumes the same value of the protected field when the user is not allowed to see.

Placing the clac field in bg color over the original field does the rest..

The bad thing is that I need a calc field for each protected field, and the layout (in layout mode) is not well readable.

The good thing is that I have compete control on record level and/or field level access.

[Ugo DI LUCA]

Hi Paolo,

I do not know if this could help, but there is another solution that I use in one of my layout, where I have my purchase price and selling price next together.

As some clients keep looking to the screen, all purchase fields (price, margin,...) in this layout are formated transparent (same background) and not allow entry.

See attachment