Newbie Questions

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

Hilary Stoupa — Wed, 15 Nov 2017 16:48:47 GMT

Your rule on the Vendor Name dropdown was very close! But you had the current() function in quotes. :) You'll want to move your Company option buttons ahead of the Vendor Name, because if you are going to filter the Vendor Name query based on the selected Company, you want that selected first. I added rules to the Company field to set the query field & run the query. Save the attached file locally, right click and select design to open in design mode. :)

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

jenielle — Tue, 14 Nov 2017 21:50:13 GMT

Hi Hilary!

While I am not 100% functional, my IT got me (sort of) up and running. I have adjusted the form as you requested, adding Company as a list column. I have re-attached the form.

Thanks again for your help!

Jen

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

Hilary Stoupa — Mon, 13 Nov 2017 17:38:31 GMT

Yikes - I'll keep an eye out for you, hope they get it fixed!

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

jenielle — Mon, 13 Nov 2017 17:28:39 GMT

Hi Hilary,

I am now running into a new (separate) issue. For some reason I can no longer get InfoPath and SharePoint to talk. I keep getting an error message that says "We are unable to connect right now. Please check your network and try again later." So I have to reach out to my IT department to see what is going on and try to resolve this ASAP. Now I'm dead in the water! :(

May take a bit as I work from home (via VPN), so I am not sure how long this will take out IT team to respond and troubleshoot/resolve.

I will make the change and respond as soon as I can. Thanks so much for your willingness to help, Hilary. Much appreciated!

Jen

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

Hilary Stoupa — Mon, 13 Nov 2017 16:15:08 GMT

Here's a screenshot of the Vendor data connection - can you add the company column to that and re-attach the form? If we are going to query on that field, we need it in the data connection. And in the list, the values are GP, TAM and Symitar? Just double checking. :)

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

jenielle — Mon, 13 Nov 2017 16:09:58 GMT

Good Morning Hilary!

Yes, the Company is in the list (it's the first column) and the values are the same in both the form and the list. They are just plain text.

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

Hilary Stoupa — Mon, 13 Nov 2017 15:54:48 GMT

Is the Company in the SharePoint list? Is it just plain text? Are the values the same as the current values for your option buttons?

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

jenielle — Sat, 11 Nov 2017 01:43:07 GMT

Hi Hilary,

Thank you for responding! I'm definitely a newbie to this, so while I've reviewed the cascading drop-down posts, I just can't seem to set it up correctly. Thank you so much for offering to take a look at my form. I have attached it as per your request.

Thanks again!

Jenielle

Re: How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

Hilary Stoupa — Sat, 11 Nov 2017 00:53:36 GMT

This should just be the same filter logic for cascading dropdowns that you see in other posts - even with the same data source for all three items, the basic logic would be the same. Attach your form to a reply (under the options tab) if you'd like me to take a quick look.

How can I set a field's value based upon user's drop-down choice (single sharepoint list, non-repeating table)

jenielle — Fri, 10 Nov 2017 01:49:40 GMT

Hello,

I am creating a form in InfoPath Designer 2013 which will leverage a single SharePoint list as a data source for three of the fields. There are three columns within the single list that I would like to drive the user experience. The columns are Company; Vendor Name; and Vendor Number.

1. I would like the user to first select their company (option buttons). Selecting the company should filter the SharePoint list so that only vendors associated with that company are left.

2. I would then like for the user to use the drop down field in the form to select the vendor of choice.

3. I would then like for the corresponding vendor number for that vendor to be set and displayed in the Vendor number (text field) in the form.

I haven't had much luck figuring this out. Most of my research has a solution for this assuming I am using a repeating table or multiple lists, which I am not.

Can anyone assist? Thanks in advance!