Controls

Re: 2 Dropdowns, 1 to refresh the value on another help

ktitchard — Tue, 02 Apr 2019 09:21:19 GMT

Sorry for my late reply. That's done it! Many thanks Hilary you are amazing!

Re: 2 Dropdowns, 1 to refresh the value on another help

Hilary Stoupa — Fri, 15 Mar 2019 15:06:42 GMT

Try this one - Are both of these dropdowns using the same list? It looks like that from the filter, like the same list item would provide data to both? I also added a text box bound to the subnet mask field so you could see the value being set, in case that helps figure this out.

Re: 2 Dropdowns, 1 to refresh the value on another help

ktitchard — Fri, 15 Mar 2019 08:45:31 GMT

Hi Hilary thanks for the reply.

I previewed the form you submitted but the Subnet Mask box remains empty. If you click on it then you see the value as the only option. Its like the default value is always blank until you manually select it. If I set the default value as '1' for Subnet Mask, when I choose an option from custom spec it will refresh the subnet mask field and give the value (this is what I am trying to accomplish but without having to put dummy data as default value)

Re: 2 Dropdowns, 1 to refresh the value on another help

Hilary Stoupa — Wed, 13 Mar 2019 16:05:14 GMT

I added a rule on the Customization Spec field for you. Save the attached file locally. Right click and select Design to open in design mode, then you can preview and try it out.

Re: 2 Dropdowns, 1 to refresh the value on another help

ktitchard — Wed, 13 Mar 2019 11:18:35 GMT

Thanks for your reply. Sure see attached. Thanks

Re: 2 Dropdowns, 1 to refresh the value on another help

Hilary Stoupa — Tue, 12 Mar 2019 14:55:42 GMT

So - the rule is on CustomSpec? Can you attach a copy of your form under the options tab in a reply so I can take a look at how you have it set up?

2 Dropdowns, 1 to refresh the value on another help

ktitchard — Tue, 12 Mar 2019 11:33:43 GMT

Hi all,

I have 2 Lists I am working with which are.

NewServerBuildRequest List
CustomisationSpec List

My NewServerBuildRequest List has 2 fields I am trying to use. First is called CustomSpec (which is a lookup field that links to a text field called 'CustomSpecName' in my Customisation Spec List), My second is called 'Subnet Mask' (which is a lookup field that links to a text field called 'SubnetMask' in my Customisation Spec List)

In InfoPath I have added these 2 lookup fields as drop down menus. The plan is when a User Selects a 'CustomSpec' from the first dropdown menu, the second dropdown menu called 'Subnet Mask' auto populates the value based on the first selection. So far on my Subnet Mask dropdown properties I have set the value to ID and the display name to SubnetMask (but displays d:xmsr im not sure why but anyway). I have set a filter value of 'ID = CustomSpec'.

When I have selected my CustomSpec option, the value in Subnet Mask remains empty, but when I click on Subnet Mask the value is the only one available which is correct but I want to autopopulate it and to send the data to the 'Subnet Mask' field on the NewServerBuildRequest List. I believe Im not sure how to do this. Please help

Thanks