NNCheckboxes show preselected checkboxes when creating the record and don't load the data after saving/refresh

MscrmTools / PCF-Controls

Controls using PowerApps Components Framework

GNU General Public License v3.0

83 stars 42 forks source link

NNCheckboxes show preselected checkboxes when creating the record and don't load the data after saving/refresh #157

Closed scherle closed 1 year ago

scherle commented 1 year ago

Hi team,

I'm trying to use the NNCheckboxes for a many-to-many relationship and it actually works:

when I untick and tick again a checkbox, the sub grid adds the relation
when I untick it again, the relation is removed from the sub grid

But:

when I reload the page all checkboxes are ticked by default no matter which relation is existing or not
when creating the whole new record all checkboxes are ticked by default, but without adding relations

So overall, it just doesn't load the correct state of each checkbox.

It would be great if you could take a look.

Thanks, Steffen

PS: this is how it looks after refreshing:

scherle commented 1 year ago

Just to mention: I'm using the latest release v1.12.3.0 as a managed solution.

MscrmTools commented 1 year ago

I think I saw this behavior when the subgrid was added without ticking the checkbox "display related records" so it actually shows all records which renders as all records ticked in the PCF. Check if you added the subgrid correctly

scherle commented 1 year ago

Oh yes, this was causing it and it works now. Thank you very much! If you could add this as a note to the readme it would be great.

Another question about the Filter Attribute: what does it do or how does it work?

My goal is to filter the options down to the same related record (in my case: "Related Lead" which is related to "PV Arrays" and the table which is shown in the form "Offers"):

When I select "Related Lead" as the table column, it shows the wrong options. Do you have an idea how I can achieve this?

scherle commented 1 year ago

This screenshot will help to explain it a bit:

scherle commented 1 year ago

So following this tutorial I know how to set the right filter via JS, but I don't know how I can refresh the Checkbox List control.

Can you give me a hint?

MscrmTools commented 1 year ago

As mentioned in the documentation, even if you can select a filter of type Lookup, there seems a bug still exists that prevents the filter feature to works correctly. I added this type of filter hoping the bug would be fixed but it seems it's not yet

scherle commented 1 year ago

Ok, thank you. But is possible to refresh the NNCheckboxes control via JavaScript somehow?

MscrmTools commented 1 year ago

Note that I'm aware of

scherle commented 1 year ago

ok, thanks