Microsoft Dynamics 365 | Integration, Dataverse...

overriding table properties visible allowedit

(0) Share

Report

Posted on by drhex_365

Hi,

I'm looking for a way to create a form that can show fields which have "visible=no" on the table properties and edit fields that have "allowedit=no" on the table.

The form is intended to operate on a dynamically selected field and table and is meant to be used by technicians/developers for analysis and emergency bug fixing

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ziyao on at

Like (0)

Report

The possible way to this is to create a security role group and assign all the technicians/developers to this group. Write your Visible logic under field property with some pseudo code like: "UserGroup"="Analysis". Do the same thing to Editable logic as well.

Was this reply helpful? Yes No
drhex_365 10 on at

Like (0)

Report

The "making it work only for technicians" part is no problem, it is bypassing the table properties I don't know how to do. What property is it you are referring to? (i.e. the form field's Visible property is already Yes, but it wont show as the table field's Visible is no)

Was this reply helpful? Yes No
Suggested answer

Ziyao on at

Like (0)

Report

Hi,

There are two layers of visibility exist on table and form. Table field is the highest priority for displaying in form. Therefore, in you case, I will recommend you set the filed visibility in table as true, then write the visible logic under form control. If you set the visible as no in table field, no matter what you have been done in the form layer, the field will be always invisible.

Was this reply helpful? Yes No
drhex_365 10 on at

Like (0)

Report

As I don't have a particular field in mind, but am looking for a general solution it would not be feasible to alter every table that has too restrictive properties on some field. I'd prefer all the code local to one form and its handling class.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

Yes, that should be possible. If you manage to get table name and field name from the user as input, you can definetely write code that reads this field from the table and shows it on the form.

But most of the time you can see enough data via existing forms and table browser.

And you can always copy prod database to test in a couple of hours and analyze it there.

If you insist on seeing this info, I would look into extending/copying the table browser so that it shows also hidden fields. Or use some community add-on that someone else has already developed.

Was this reply helpful? Yes No
drhex_365 10 on at

Like (0)

Report

Yes, I was thinking of extending the table browser.

On a table buffer, there is a method overwriteSystemfields() that lets you go around the usual limits, I was hoping there was something similar on forms. Well, I guess it will have to be unbound form controls with some generic eventhandler code that works for most datatypes,

Was this reply helpful? Yes No