Fields in Tablebox must be visible as per Role Specified

Stivan_dsouza21
Member Posts: 218
Form 18 - G/l Account List
Some Fields (Debit Amount, Credit Amount....etc) we have to make Visible as Per the Role Assigned to Specific Users.
Below is the Code written on Form 18:
Form - OnOpenForm Trigger
MemberOf.RESET;
MemberOf.SETRANGE(MemberOf."User ID",USERID);
MemberOf.SETRANGE(MemberOf."Role ID",'COA');
IF MemberOf.FINDFIRST THEN
BEGIN
CurrForm."Debit Amount".VISIBLE(TRUE);
CurrForm."Credit Amount".VISIBLE(TRUE);
END ELSE BEGIN
CurrForm."Debit Amount".VISIBLE(FALSE);
CurrForm."Credit Amount".VISIBLE(FALSE);
END;
Now the problem is that the Users who do not have Role assigned to his ID can do Show Column and make the Field Visble.
Can Somebody help me that the Others user who do not have role assigned should not see the Fields.
Thanks in Advance.
Some Fields (Debit Amount, Credit Amount....etc) we have to make Visible as Per the Role Assigned to Specific Users.
Below is the Code written on Form 18:
Form - OnOpenForm Trigger
MemberOf.RESET;
MemberOf.SETRANGE(MemberOf."User ID",USERID);
MemberOf.SETRANGE(MemberOf."Role ID",'COA');
IF MemberOf.FINDFIRST THEN
BEGIN
CurrForm."Debit Amount".VISIBLE(TRUE);
CurrForm."Credit Amount".VISIBLE(TRUE);
END ELSE BEGIN
CurrForm."Debit Amount".VISIBLE(FALSE);
CurrForm."Credit Amount".VISIBLE(FALSE);
END;
Now the problem is that the Users who do not have Role assigned to his ID can do Show Column and make the Field Visble.
Can Somebody help me that the Others user who do not have role assigned should not see the Fields.
Thanks in Advance.
Thanks & Regards,
Stivan D'souza
Stivan D'souza
0
Comments
-
Unfortunately you can not set permission for view--> show column,hide column for object type system.0
-
So any other wasy Around.Thanks & Regards,
Stivan D'souza0 -
try to put the code on both OnOpenForm and OnAfterGetRecord triggerMicrosoft Certified IT Professional for Microsoft Dynamics NAV
Just a happy frood who knows where his towel is0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions