How to restrict field modifications on pages depending on the user and the new value

(0) Share

Report

Posted on by Community Member

Hello,

I would like to know if there is a way to allow or forbid a table field modification depending on the user and the value, for example:

User A should be allowed to modify the field "status" of the "customer-account" page from "active" to "blocked" but not from "blocked" to "active".

User B should be allowed to do the opposite, modify the customer-account status from "blocked" to "active" but not the other way around.

With the standard NAV permissions we can simply grant edit/read/... accesses to objects, but this kind of permission is not feasible.

I was wondering if there was a way of implemeting a modifications matrix or similar, that could allow me to do this in an elegant fashion...

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Mohana Yadav 61,001 Super User 2025 Season 2 on at

Like (0)

Report

The solution running in my mind at present is:

create 2 Boolean fields in user setup table and activate then as you needed.

Check the setup while validating the field.

Was this reply helpful? Yes No
Saurabh Shah 4,560 on at

Like (0)

Report

I agree with Mohana and also doing the same.

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

There is not standard functionality for this, you have to customize to achieve this. There is an add-on called Easy Security you can use to control which fields to be editable,hidden.. but i don't think that even has the option to control the value of the field.

The easy way is as Mohana mentioned control it by user setup but if you have this kind of requirement for other fields then you need to think of about creating some kind of customized permission setup for fields, tables and the values.

mergetool.com/.../easysecurity.html

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

As you wanted to have a setup for the user permission, my suggestion is to create a separate table or modify the user setup table. In the table, add two new boolean fields and at the time of user change the status (onValidate) write a code to check the user permission.

Was this reply helpful? Yes No