Solved: Re: Reset fields that are part of cascading on val...

neil396 · ‎08-13-2022

Dear all,

I'm working on a model driven app where I have 'Province', 'City' and 'Health center' tables. There a relationships active between these tables. (One province has many cities, one city has many health centers.)

When creating a form filtering the options down from Province to City to Health center works great with the help of Related Records Filtering but after I have selected a health center I can still change the Province and or City. This results in an invalid combination of health center / province / city.

Is there a way to solve this issue? Would it be possible to 'reset' the fields after a value is updated for example? Open for any other solutions.

Your help is much appreciated, thanks in advance.

Best,

Neil

AhmedSalih · ‎08-20-2022

@neil396, all logical names must be between single quotes or double quotations:

function DisableFields(executionContext) {
    var formContext = executionContext.getFormContext();
    var healthCenter = formContext.getAttribute('adit_healthcenter').getValue();
    var province = formContext.getControl('adit_province');
    var city = formContext.getControl('adit_city');

    if (!healthCenter) //Check if Health Center is Selected
    { province.setDisabled(false); city.setDisabled(false); }
    else { province.setDisabled(true); city.setDisabled(true) ;};
}

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

View solution in original post

Drrickryp · ‎08-13-2022

@neil396

Check out this thread to see if it applies to your situation https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Table-relationships-Delete-Parent-without-de...

neil396 · ‎08-14-2022

Hi @Drrickryp,

Thanks for your swift response. I've read the thread, unless I'm mistaking (what defenitely could be the case), I don't think it is applicable to my situation. Maybe it helps if I try to explain my issue in other phrasing. Let's say that I've created a model driven app that contains a table that tracks distribution of products. I have the following relationships:

One to many from distribution to provinces
One to many from distribution to cities
One to many from provinces to cities

Now, for the distribution table I have created a form with two lookup fields: Province and City. I'm trying to achieve two things:

If I select either Province or City first, the values that I can select for the other field should be filtered.
1. If I select a province first I should only be able to pick the cities that are related to that province (this works via related records filtering).
2. If I select a city first I should only be able to pick the province that is related to that city.
Invalid combinations of Province / City should be prevented.
1. The related records filtering makes sure I can only select cities that are in a specific province. My issue is that after both fields are filled, I can change the province field whilst the city field doesn't change.
2. The above results in an invalid combination of province and city
3. I would like to achieve that If once update the province field, the city field value gets deleted and I need to reselect a new city that is linked to the updated province.

I hope this makes it better to understand. If the solution is indeed towards the type of relationships maybe you can point me a bit into the right direction?

Thanks again and best,

Neil

Drrickryp · ‎08-14-2022

@neil396

Could you post a screenshot of your form please?

neil396 · ‎08-14-2022

Hi, @Drrickryp

Of course, happy to! Please find the following screenshots below.

States
Cities (that are related to states)
Related record filtering settings on the distribution form
Related record filtering in action on the distribution form
Saved a distribution record with matching state and city
Updated the state whilst I did not have to update city, result is an invalid combination of state and city
State_City relationship details
Distribution_City relationship details
Distribution_State relationship details

Hope this helps, please let me know if you need more input. Thanks again!

Best,

Neil

StatesCitiesRelated record filtering settingsRelated record in action in formInitial saveUpdate state

City - state relationshipDistribution - city relationshipDistribution - State relationship

Drrickryp · ‎08-14-2022

@neil396

This could be done easily in a canvas app form simply by blanking the city field when the state field is changed. I am not as familiar with the mda form. Perhaps @AhmedSalih , who is more familiar with model driven apps has a simple answer for you.

neil396 · ‎08-14-2022

@Drrickryp

Thanks for getting back to me and the referral to @AhmedSalih, I hope he maybe has a solution. Yeah I can imagine this is easier done with a canvas app. I did quite some Googling before reaching out to the community, most hits were related to canvas apps.

It seems like a rather 'simple' issue so now I'm annoyed with myself that I haven't found the solution yet and I'm determined to figure it out! 😉

Anyway thanks again for your input and I hope someone else has an answer.

Best,

Neil

AhmedSalih · ‎08-14-2022

Hello, @neil396, you will have to create a web resource using JavaScript to Disable/Hide the Province and or City Fields once the Health Center is Selected. You will need to run the function on the OnChange event of your Health Center Field.

Use this code for your web resource: (Use your Logical Names of the Fields when Mentioned)

function DisableFields(executionContext) {
    var formContext = executionContext.getFormContext();
    var healthCenter = formContext.getAttribute(HealthCenterFieldLogicalName).getValue();
    var province = formContext.getControl(ProvinceFieldLogicalName);
    var city = formContext.getControl(CityFieldLogicalName);

    if (!healthCenter) //Check if Health Center is Selected
    { province.setDisabled(false); city.setDisabled(false); }
    else { province.setDisabled(true); city.setDisabled(true) ;};
}

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

neil396 · ‎08-15-2022

Hi @AhmedSalih,

Thank you for reaching out so quickly and your help offered! I'm travelling for the next couple of days and probably won't have time to check out your solution before Friday.

It makes sense and I'm sure it will work, I will get back to this thread latest by Friday and of course accept as solution then.

Thanks again.

Best,

Neil

neil396 · ‎08-20-2022

Hi @AhmedSalih ,

I've followed your instructions and created the web resource that is triggered by change of the Health Center field. When I pick a value for the Health Center, I get the error message displayed in the screenshots. I've also included the error log.

I've double checked the logial names and also tried both 'function DisableFields(executionContext)' and 'DisableFields(executionContext)' as funtion for the event.

I have no experience regarding JavaScript so it might be something simple. One last push in the right direction would be much appreciated!

Thanks again.

Best,

Neil