InfoPath Dev

Generally, with cascading dropdowns, I add a rule to each field involved to clear the child field on change. So, Business Group needs a rule to set Sub Group to blank when it changes. And Sub Group needs a rule to set Equipment Detail to blank. This should be the first rule for each field. That way the now-invalid choice doesn't ...

Hi - as long as you have the ID number of the item from List A in List B (i.e., the user selects from a dropdown) you should be able to populate values in the List B form with data from List A. You'll need to use filters on your rules to set the values in your form, but shouldn't need any additional list. Can you tell me what is happening ...

Does the data source for A contain the abbreviation? If so, this can be done, but the filter is a little more complex. When you add the filter to drop down B, you'll add a filter where the region abbreviation is equal to the region abbreviation in the data source for A where the full region name is equal to the region selected in the form. It ...

So - if your dropdowns are in a repeating section, it is probably best to just query for all the data (as long as it doesn't impact load times for the form or cause other issues because the data load is huge). That's because if you requery the data source for the initial dropdown on each selection, you could end up with no data available ...

OK! It worked! It was the fact that the ID was missing somehow from the sharepoint list. Now I have another problem. In form A, there is cascading logic (e.g., region > state) and when i look at that field in the sharepoint list, "state" shows up as a number. Is there something I can do to make it show up as the state, not the ID?

Hey Hilary, Thanks for responding  :) I have attached the form in question.  Please note that in order to simplify my post before, I claimed "State" was the third tier of the cascading drop-down.  In actuality it is SalesOrg.  I just didn't want to go into explaining what that is, but it is a field specific to ...

Hi! I generally understand forms better than descriptions - is there any chance you could attach your template under the Options tab in a reply? If not - are the calculated values default formulas in fields in the form? Or actual calculated values w/ formulas in them? Could it be you need to have more specific XPath filters in those calcs?

CMD_Pulldown is a SharePoint list that is being used for the values of a handful of columns (that have no relationship as list items).  Formerly, it was being used for Country and Sales Org, but I have since created separate lists in order to tackle the cascading drop-down function.  Yes the values are the same between these two columns ...

So - my guess is that you are using a dropdown for that State, and it is set to store the ID and display Title or something in the form. You could change that to store the same value as what is displayed, so that you are submitting the text instead of the ID. Or you could add another field and set that to the text value when the user selects the ...

It may be a little more complex than that - in the condition builder for the filter on drop down b, you'd select the abbreviation from B. Then is equal to and in the third dropdown, use a formula. In the formula, you'd pick the abbreviation from data source A and add a filter - in that filter, you'd select the region in data source A ...