web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How can I prevent a us...
Microsoft Dynamics NAV (Archived)

How can I prevent a user from modifying a record in NAV 2017?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

Scenario: I have 10 fields in a table. The FIELD2 is a drop down and can have two values CREDIT or CASH. 

//Questions

1. How can I make sure that only 2-3 special users can change FIELD2? These 2-3 users should be able to change all 10 fields.

//All users do not include 2-3 special users.

2. If FIELD2 is CREDIT then only FIELD8 and FIELD9 are editable by all users. Other fields should be uneditable for all users.

3. If FIELD2 is CASH then only FIELD5, FIELD6, FIELD7 and FIELD9 are editable by all users. Other fields should be uneditable for all users.

Thanks,

Umair

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Umair,

    One way to do is add a boolean on the user setup table and enable that permission only for the users who has permission to edit the field, and then on Validate of the FIELD2 check the user setup for the permission and throw appropriate error for users.

    Making fields editable based on permission and other field value follow same logic, you need to assign other fields Editable Property to a variable with IncludeInDataSet property set to true and then make that variable true or false based on your condition.

    For example check the customer card contact field it will editable only when the primary contact no. is filled. The logic is on the ActivateFields Function

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,891 on at

    Zulfi ,

    i think Suresh Kulla mention the easiest way addition to his comment  i suggest to create separate permission set for them

    you can have another solution by separate little customization with another new table but i think this would be enough

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans