Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to disable 'Ch...
Microsoft Dynamics NAV (Archived)

How to disable 'Choose columns' in a specific page

(0) ShareShare
ReportReport
Posted on by mbr 5,124

Hello Experts,

I have a page that has a combination text fields and list parts.  For this page, we want to disable choosing of columns.  I.e., we don't want users to personalize this page.  Is there a way to disable the 'Choose Columns' feature for this page only?  we still want to allow personalizing or choosing of columns for all other pages, but this specific one.  Please help!  I could use some suggestions as I had researched but didn't get any real solution.  I know I can disable personalization but I don't want to disable for all ...just this specific page.

*This post is locked for comments

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: How to disable 'Choose columns' in a specific page

    It is great that your solution worked and achieved your goal. However just check on the complete solution as user personalization is a one area that help users to get comfortable with the system. Once you disable it due to the solution provided, then users may feel that they have been stuck. (Just my view)

  • mbr Profile Picture
    mbr 5,124 on at
    RE: How to disable 'Choose columns' in a specific page

    HI Mohana! I did try the oninsert trigger in the user metadata table but it didn't run because most likely the Insert trigger of the User Metadata Page (I can't seem to find the Page that is being used to choose columns) is not running the insert trigger.  Since I am unable to find the Page source for the choose columns, I decided to write the SQL Server on Insert trigger for User metadata instead.  And that did the trick!  Now, users CANNOT customized specific pages ONLY.  thank you!

  • Verified answer
    mbr Profile Picture
    mbr 5,124 on at
    RE: How to disable 'Choose columns' in a specific page

    Hi Mohana,

    I ended up writing a code on OPEN of the specific page.  On OPEN of the specific page, I check the User Personalization table if users have  done any personalization on this page.  If a record exists, then delete the latter and pop up a message to the user that they are NOT allowed to personalize this page.  Then the next time they log on to NAV, all their personalizations to this page will be reset.  Note that our biggest problem is not that users can see columns (I could easily remove the columns if need be).  It's that we don't want users to rearrange the columns since that can impact the integrity of the given page.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: How to disable 'Choose columns' in a specific page

    Did you try last suggestion?

    any update on how you solved it?

  • Verified answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: How to disable 'Choose columns' in a specific page

    All the personalizations will be written to User Personalization table.

    you can write code in oninsert trigger of the table to show error while inserting record for that page.

    didnt try myself.

  • mbr Profile Picture
    mbr 5,124 on at
    RE: How to disable 'Choose columns' in a specific page

    Ohhhh! I was hoping there will be a way.  Ok.  thank you Mohana.  it was worth a try.  We don't want the users to rearrange the columns.  I can make some columns invisible....but with personalization enabled, they can still rearrange. :(  

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: How to disable 'Choose columns' in a specific page

    I think NAV Easy Security Add-on as this feature, but if it is just one page then i agree with other create a separate page for those users and remove the columns from it.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: How to disable 'Choose columns' in a specific page

    I believe and as other members said creating a new page would be easiest approach to manage this requirement.

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: How to disable 'Choose columns' in a specific page

    Hello,

    Read this SETTING DIFFERENT COLUMN LAYOUT FOR DIFFERENT USERS

    you will get some idea.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: How to disable 'Choose columns' in a specific page

    I agree with Rajasekhar Y

    I would create a new page, and put there only needed fields, and assign permissions to certain users to use this page.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans