Hey there, is there any way to prevent users from adding new field in the table overview ? E.g. I made some field in an specific overview invisible, but the Users can easily insert those field again by using the “insert column” menu in the overview. Hope you have a slight idea what I am talking about Sven Best regards Sven Sauer Dolphin Communications GmbH Cycos AG www.dolphinct.de www.cycos.com email@example.com
Just create a form and do not add that column to the form. Then, Using View/Hide COlumns, the users won’t be able to add it since you never added it to you form.
hi, thanks for your clue but we cannot use a new form. and since there are two different groups of users who are using this form there’s no way to delete this columns. cause there’re still needed to be seen by one of the groups of users. We are now using this “solution”, which does the job but is not really satisfieing. We just use the OnTimer() Trigger to set the not wanted columns invisible every 0.5 seconds… Does anybody know which effect this method has on the navision server? For e.g. on the performance, or is this a client problem? Thanks and regards, Sven Best regards Sven Sauer Dolphin Communications GmbH Cycos AG www.dolphinct.de www.cycos.com firstname.lastname@example.org
Hi Sven! Maybe you can do that by “Rollen” and “Zugriffrechte” (“Roles” and “Accessrights” ?): Set for the relevant users the “right” System 3510 (“Ansicht Design” / “View Design”) to “no” (blank) (haven’t tested, but it should work) and the users can not modify the column-layout … but this will take effect to ALL objects! Regards, Jörg Joerg A. Stryk Apollo-Optik, IT/ERP
Right, thats the problem, it takes effekt to all objekts but we want only to restrict the rights on this special form… Best regards Sven Sauer Dolphin Communications GmbH Cycos AG www.dolphinct.de www.cycos.com email@example.com
We just use the OnTimer() Trigger to set the not wanted columns invisible every 0.5 seconds…
Well, if this causes performance problems or not depends on your hardware (server, clients, network, etc.) and the amount of users that are using this form at the same time … If some problems occur, maybe you could try to put the code in OnActivate()/OnDeactivate(): I assume that the form is deactivated when the user tries to set the columns visible, and so, if he returns to the form it’s activated again. In every case the columns should dissapear. Same result without using the timer!? Regards, Jörg Joerg A. Stryk Apollo-Optik, IT/ERP
Hello Jörg, we tried this also. But the problem is that the form alway stays activated. If the user returns from setting the colums he sees them in the form. If he closes and resarts the form they are gone of course. (Irgendwie erscheint mir mittlerweile der Time trigger als am besten geeignet, und da nur wenige User gleichzeitig darauf zugreifen sollte man damit leben können Best regards Sven Sauer Dolphin Communications GmbH Cycos AG www.dolphinct.de www.cycos.com firstname.lastname@example.org
Sven, I think the best place for your code is in the OnFormat-Trigger of your Field like this: OnFormat(VAR Text : Text IF NOT FieldCanBeVisible THEN BEGIN CurrForm.YourField.VISIBLE(FALSE); Reijer.