Page 1 of 1

Giving normal users access to modify forms

Unread postPosted: Sat Jun 12, 2021 7:00 am
by icoso
Is there a way to create a user that would have access to be able to modify a forms properties, such as the field properties that pop up when you double click the field name on a form? I want to give them the ability to modify the selection data on Select Fields.

Re: Giving normal users access to modify forms

Unread postPosted: Sat Jun 12, 2021 7:19 am
by kev1n
To give a user access to the object properties form, execute this SQL. Replace 5fe2ceed176ce09 with the Acess Level Id of that user.

Code: Select all
INSERT INTO `zzzzsys_access_form` (`zzzzsys_access_form_id`, `slf_zzzzsys_access_id`, `slf_zzzzsys_form_id`, `slf_add_button`, `slf_save_button`, `slf_delete_button`, `slf_clone_button`, `slf_new_button`, `slf_print_button`, `slf_data_mode`) VALUES ('nuobject', '5fe2ceed176ce09', 'nuobject', '0', '1', '0', '0', NULL, '1', NULL)


Note: This would allow the user to modify all objects of all forms.

To allow a user to modify just one (select) object, create a new form where it can be modified.