Microsoft Access

Re: Auto populate - only adds data from first row in database

StuartBall — Mon, 16 Jul 2012 13:28:41 GMT

Resolved it.

When applying the filter in Infopath 2010, I needed to edit the XPATH statement to use "current()" instead of the fieldname for the row I was entering.

Off to find a cold pack for my sore head now, and put in a request for a new desk!

Stuart

Re: Auto populate - only adds data from first row in database

StuartBall — Mon, 16 Jul 2012 10:59:34 GMT

Hi,

I am using this method to populate information from a list of servers in an XML file. I have the rules set so that when I enter a server name it sets the OS field with the appropriate OS based on the Servername.

However whenever in the repeating table it gets to "Windows Server 2003", any entry after that row will have "Windows Server 2003" regardless of the actual OS in the XML file.

I'm really confused and been plaguing me for days now.

Rules are set as follows:

Run rule when this value changes
Query Data Connection
Set "OS" with "platform" where (Secondary)Server_Hostname = (Main) ServerHost

It does the Windows 2000 servers OK until you get a server with W2K3, then the rest are. So its not the "getting first row only from the DB issue" that people have had previously.

Any advice would be greatfully appreciated.

Kind Regards,

Stuart

Re: Auto populate - only adds data from first row in database

AaronB — Fri, 02 Mar 2012 14:40:34 GMT

For me, my issue was that InfoPath would only display the items that were visible in the default list view for the SharePoint list i was using. My default list view had filtered results, so my dropdown in InfoPath would only show the filtered results. I learned to avoid this issue be making sure that any SharePoint list that I use within InfoPath forms has all items displaying on the default list view.

Re: Auto populate - only adds data from first row in database

mubashshira — Fri, 02 Mar 2012 07:13:20 GMT

Hi Aaron,

I am facing the exact same problam. was wondering if you found any solution to your issue.

AaronB:

I am having this same issue, but using a SharePoint list as my secondary data source. I followed your instructions, but am still only getting back results for the first item in my list.

Thanks

Re: Auto populate - only adds data from first row in database

mubashshira — Thu, 23 Feb 2012 04:20:02 GMT

Hi Hilary,

I am facing the exact same problem. "you have chosen to bind a non repeating control to repeating field or group. this control will be bound to the first item in repeating table or group".

But in my case, I have to query a web service to retrieve data. and the fields are binded with repeating table in the web service which in my form i have to bind them with non repeating control.

so can u suggest me a way so that i can get the data of that row which i query using the ID and not just the first one.

Thank you

Mubashshira

Re: Auto populate - only adds data from first row in database

bmerrifield — Thu, 07 Jan 2010 19:17:43 GMT

Still struggling with this myself. Sharepoint list has site/adress/city/state/zip info, and is a secondary data connection to my InfoPath form. On the form, the user selects a site from a drop-down, which should auto-populate the four individual address/city/state/zip fields.

I have a single rule on the "site" drop-down with the following actions:

query using a data connection: site list
set a field's value: Address = @Site_address
set a field's value: City = @City
set a field's value: State = @State
set a field's value: Zip = @Zip_Postal_Code

When I preview the form and change the site drop-down, the four address fields only keep the first set of info returned from the SharePoint list.

Any thoughts on what I'm doing wrong? So close, yet so far...

Thanks,

Brian

Re: Auto populate - only adds data from first row in database

DerekB — Wed, 14 Jan 2009 21:32:36 GMT

Hello,

I followed your instructions and they did the trick quite nicely. I do have one further issue though, and a follow-up question. My senario is this:

I'm creating an infopath form to request new user accounts. Within this form, I'm using the task pane to display a .html script so the person filling out the form can query another user ID from Active Directory and it will bring up everything the user has access to (Applications and Network Shares). I want to be able to have the user select an application, and have the form automatically populate the application group and other information. The data will be stored in an Access Database, which I have connected to the Infopath form.

1) When performing this in a repeating table, when selecting an option in the first row, it works great. When selecting an option in the second row, it returns the value from the first row. Is there a way to make this work?

2) If I wanted to copy the application name from the task pane, and paste it into a field in a repeating table, is it possible t Validate the data based on the Access database, and have it automatically populate other fields on the form with data in the same line (application groups and licensing information to be precise)?

Re: Auto populate - only adds data from first row in database

Jo-Anne Alfafara — Fri, 07 Nov 2008 06:20:49 GMT

Hi Hiszorn,

Please try the following steps:

1. Double-click on your Dropdown 1 in the view.
2. In the ListBox entries section, select 'Look Up Values from an external data source', select Contracts as your Data Connection
3. Click the XPath button to the right of the Entries field. From the dialog box that appears choose your Contracts table and click OK
4. Click the XPath button to the right of Display Name, select the Contracts field as value to display, and then click OK.
5. Click Apply, and then click Rules.
6. Click Add and then click Add Action.
7. Select Set A Field’s Value from the action drop-down list, and then click the XPath button to the right of Field.
8. Select /my:myFields/my:<your Dropdown 2> from the list, and then click OK.
9. Click the formula button to the right of Value, click Insert Field Or Group, select your secondary connection for Contracts table in the Data Source drop-down, and select the node for SalesPersonID in the list and click Filter Data. Click Add
10. In the first dropdown, select SalesPersonID and leave the second dropdown 'is equal to'.
11. In the third dropdown, click 'select a field or a group' from dropdown and select Contracts field from your main data source. The formula will look like @SalesPersonID[. = Contracts]
12. Click ok on all dialog boxes and preview

When a contract is selected from Dropdown 1, the steps above should take SalesPersonID from Dropdown 1 and set it as value for Dropdown 2

Hope this helps.

Jo-Anne AlfafaraQdabra® Software – www.qdabra.com / www.InfoPathDev.com
The InfoPath Authority – Streamline data gathering to turn process into knowledge.™

Re: Auto populate - only adds data from first row in database

hiszorn — Wed, 05 Nov 2008 18:55:11 GMT

I am having issues with trying to get this to work.

I have two drop downs with two different Secondary data sources. I want to pick a selection from the first to auto select a choice on the 2nd.

Drop down 1: Contracts table with a Sales Person ID not on drop down, but in table.

Drop down 2: Sales People (Name as display, ID as value)

When I click a contract, I want to take a Salesperson ID from drop down 1 and set it to the value of drop down 2.

This scenario will only select the first choice with no filter, when I try to filter, nothing appears on DDL2.

Am I having problems due to havng 2 separate data sources?

Re: Auto populate - only adds data from first row in database

jslancas — Mon, 22 Sep 2008 19:22:02 GMT

I was looking into the same issue and your info worked for me as well. Thank you!

Re: Auto populate - only adds data from first row in database

JamieG — Sun, 27 Jul 2008 09:56:43 GMT

I have found the solution on one of Greg Collins' posts http://www.infopathdev.com/forums/p/3218/12339.aspx#12339

The answer was to set the rule to firstly query the datasource then set the field as described in this post.

Thanks Greg and Hillary.

Jamie

Re: Auto populate - only adds data from first row in database

JamieG — Sun, 27 Jul 2008 08:28:38 GMT

Hi Hillary,

Thanks for your post. It has got me half way there but im still having problems. In your scenario, I am trying to display the customer's phone number for reference, not to be submitted as a field in my form, but the number to display is still based on the customer name selected from a drop down box.

I have the dropdown box populated from a second seondary data source of customer names, ie not the datasource that contains customer names AND customer phone numbers which is used for the lookup. So far it works fine, I load up the form and in my drop down box i have all the customer names. i click on a customer name and that customer's phone number is displayed in a control bound to the customer name/phone number data source. Fine.

The problem comes when i try afterwards to select a different customer name. The phone number control just goes blank instead of being populated with the phone number of the new selection. I guess what is happening is it is not re-filtering the data source correctly.

Do you have any suggestions as to how i can fix this?

Many thanks,

Jamie

Re: Auto populate - only adds data from first row in database

AaronB — Sun, 27 Jul 2008 00:06:34 GMT

I am having this same issue, but using a SharePoint list as my secondary data source. I followed your instructions, but am still only getting back results for the first item in my list.

Re: Auto populate - only adds data from first row in database

workthatmatters — Wed, 23 Jul 2008 19:04:56 GMT

Awesome! I've spent hours trying to figure this out. Thank you!

Re: Auto populate - only adds data from first row in database

Rebecca — Sun, 13 Jul 2008 07:12:28 GMT

Perfect! Thanks a bunch for the help, I've been messing about with this for a while now!

Thanks again.