https://www.infopathdev.com:443/search/SearchResults.aspx?q=cascadingSearch results for 'cascading'en-USCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/p/40535/125600.aspx#125600Mon, 06 Jan 2025 15:48:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125600jaimeedexI love this! thank you! I just can't get my current user value to match my approver which is in display name form that is chosen from a cascading drop down within the form. Can I do the same but have the username formatted in display name? which currently looks like, Dexter, Jaimee, for example. ( my user name is jdexter) https://www.infopathdev.com:443/forums/p/40321/124700.aspx#124700Tue, 01 Feb 2022 17:41:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124700lou dHello, Not sure if this is cascading dropdowns, or if I need to create an XML data source, but I have two dropdowns, i.e, Dropdown A and Dropdown B. Dropdown B has only two values in the list - Material and Non-Material. If the user selects a certain value in Dropdown A, I want to force Dropdown B to default to a value of Material. If the user selects any other value, i want to provide the user with the ability to select either Material or Non-Material (i.e, just leave the second dropdown alone). I don't know if I need to use XML data source, or if there is a simple way to do this with rules. Thank you for any assistance. Louhttps://www.infopathdev.com:443/forums/p/40308/124642.aspx#124642Tue, 11 Jan 2022 17:09:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124642joshhudI dont think i actually have a repeating field. It is a mult-select box with filters to perform the cascading process for another multi-select box. Anything i can attach that would help?https://www.infopathdev.com:443/forums/p/40308/124637.aspx#124637Tue, 11 Jan 2022 16:25:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124637joshhudHi everyone, I have an infopath form with a cascading multi-select table that will not show up in the SharePoint Library. I found some ideas that 99% work but im stuck at one part. I have created a new text box control and used the below formula in the text box and as a rule in the multi-select box. Formula:eval(eval(group4, 'concat(., ";")'), ".") result Selection1Selection2Selection3; expected result: Selection1;Selection2;Selection3; Any idea why the semi-colon only shows at the end and not after each selection?https://www.infopathdev.com:443/forums/p/40285/124565.aspx#124565Tue, 09 Nov 2021 22:28:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124565Hilary StoupaSo - 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 State from the dropdown, if you need the ID.https://www.infopathdev.com:443/forums/p/40285/124564.aspx#124564Tue, 09 Nov 2021 20:18:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124564amanda123OK! 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?https://www.infopathdev.com:443/forums/p/40285/124561.aspx#124561Fri, 05 Nov 2021 18:12:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124561Hilary StoupaHi - 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 when you try to filter? Or attach a copy of your form to a reply under the Options tab?https://www.infopathdev.com:443/forums/p/40285/124553.aspx#124553Thu, 04 Nov 2021 16:19:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124553amanda123This may cover a couple topics, but I'm not sure of the language to describe what I'm looking to do to search. I have a form (Form A) that was built on a SharePoint List (SharePoint List A). When submitted, the information is logged in SharePoint List A. I have a second form (form B) that I would like to have use responses submitted to SharePoint List A to populate this form (form B) (and thus a SharePoint List B). For example, form A has an ID # associated with it. I am able to query that ID # from SharePoint List A to populate a drop down in form B, but I am not able to use that drop down selection as a filter for other fields later in form B. Do I need to create an intermediary list that creates "linked" fields (like a cascading drop down)? If so, how do I do this when data is going to be consistently added to SharePoint List A via submitted form As? Ultimately, I am trying to reduce entering the same data across forms that happen in succession by porting in submitted information from form A into form B via filtering.https://www.infopathdev.com:443/forums/p/40241/124348.aspx#124348Thu, 12 Aug 2021 05:54:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124348markikavHi InfoPathdev community! Hopefully someone has had similar use case to this and point me in the right direction. I have a service request process with the data stored in a sharepoint list and data entered via Infopath form on the sharepoint site (they have infopath 2013). The service request "case" can have multiple requests in it based on Service Line and Scenario, we allow them to enter 6 requests. Example Request 1 Service Line 1 = Transaction Queries Scenario 1 = One Payment - Additional Info Request 2 Service Line 2 = Transaction Queries Scenario 2 = One Payment - No Additional Info Request 3 Service Line 3 = Payments on Hold Scenario 3 = Email to Customer Request 4 Service Line 4 = Direct Debits Scenario 4 = Cancellation Request There are 25 Service Lines all with 5-10 Scenarios which I have configured using a sharepoint data connection with cascading dropdowns and works nicely (thanks to this forum!) Last part of this is that they want the ability to QA how the request was dealt with by an offshore team, so per service line they have defined multiple error scenarios that they want to rectify, these are multi select. So what I want to do is in a QA view in the form present them with one instance of the Service Lines errors multi select fields based on the Service Lines selected in the main requests. Example as per above , there was 4 requests but only 3 Service Lines, so I want to present the Error fields multi select boxes now for the 3 Service Lines.. E.G Service Line = Transaction Queries Errors = Incorrect Template , Incorrect info provided, No Follow Up and all 3 could apply or just 1 or 2 etc i.e. multi choice select and this would cover the 2 requests made There is probably a crude way to do it which I'm trying to avoid as I will need multiple extra fields with tons of sections to hide I would imagine! Any help here on a good approach appreciated. Thanks Mark https://www.infopathdev.com:443/forums/p/40150/123991.aspx#123991Mon, 29 Mar 2021 18:16:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123991DarthBruteI have a field named NTAG It is a lookup field from a list Called NTAG Lookup. This list has 3 columns: NTAG | TAOC | REGION Now I already have a data connection set up for that list as there is a dropdown for NTAG and a cascading dropdown for TAOC. I also have another lookup list called Region Lookup. It has 2 columns: NTAG | REGION What I would like to do is have a text field that auto-populates the REGION based on the selection of the NTAG. I have tried multiple things searching google and YouTube and nothing I have found works. I can't figure out what I'm doing wrong. I created the second lookup list in case it was an issue of having multiple entries of an NTAG in the first list. i.e.