Data Connections

Re: Auto Populate other fields based on Employee ID

jmed1994 — Mon, 20 Apr 2020 21:18:17 GMT

I was wondering if you can guide me on how to do something like that. I wand to be able to just type in the employee Id and for it to autopopulate the additional information like (name, title, department, phone, email etc) in a repeating table. Is it something that I can do in InfoPath 2013 using sharepoint online?

Re: Auto Populate other fields based on Employee ID

bjxj08 — Tue, 01 Apr 2014 17:46:50 GMT

I used a data connection to a SQL view to and queried the information.

Sorry took so long to respond.

Re: Auto Populate other fields based on Employee ID

Patrick Halstead — Fri, 02 Aug 2013 07:02:39 GMT

What was the solution?

Re: Auto Populate other fields based on Employee ID

bjxj08 — Thu, 01 Aug 2013 22:23:57 GMT

Thanks this has been solved.

Re: Auto Populate other fields based on Employee ID

Patrick Halstead — Sun, 28 Jul 2013 19:22:26 GMT

Hi Bjxj08 and welcome,

If you are using the browser, it may be as simple as right clicking the employee ID field and clicking Browser tab and selecting the option for "always" post back.

If that doesn't fix the issue, make sure the value exactly matches and that you are setting the query field before you query it.

Should be a quick fix.

Auto Populate other fields based on Employee ID

bjxj08 — Mon, 22 Jul 2013 22:01:33 GMT

I have a IP form list that I would like the end user to enter the employees id's(which is stored in a data connection library UDCX file) then have the other fields, employee name, managers name(stored in the same UDCX file) auto populate based on employees id. I have created the a query and set field values, but when I do a preview and enter an employee id the other fields are not populating. Any suggestions? Thanks for any help.