General

Re: Assign textbox value based on dropdown control selection

Sajan Wadhwa — Mon, 04 Aug 2014 07:11:29 GMT

Hi Ted.. I have seen your attachment but i also want to see the code of this file..I am working on a php application and that attachment is not working..Just tell me in which format i will be able to see your script.. Sajan

Re: Assign textbox value based on dropdown control selection

samjohn2u — Tue, 18 Dec 2012 13:12:55 GMT

I sorted out the problem and now working fine. It is an issue with rules.

Re: Assign textbox value based on dropdown control selection

ErnestoM — Tue, 18 Dec 2012 12:27:50 GMT

Hi,

I would check your rules. Most likely, there is an error in the implementation.

Without seeing the form itself, it's a bit difficult to diagnose, but surely it's an issue in the rules. In future replies, feel free to attach the form via the Option tab when replying.

Re: Assign textbox value based on dropdown control selection

samjohn2u — Mon, 17 Dec 2012 09:47:00 GMT

I has followed as mentioned in this post. List box is populating id, textbox is populating 1st name. not populating based on id change. Please help.

Re: Assign textbox value based on dropdown control selection

CrystalA — Mon, 07 Feb 2011 19:35:06 GMT

Ted, thank you for the quick reply. I guess I am really a beginner at this and not sure how to go about doing this. My example...to better explain myself.....

Cost Center	General Name
CCRMD-KOSTL	CCRMD-KTEXT
CA06002202	Mat Logx LAC
CA06002203	Ret & Rep LAC
CA06002210	Pr Shop Indir LAC
CA06002211	Buf Indir LAC
CA06002212	Pnt Line Indir LAC
CA06002213	Assy Indir LAC
CA06002220	Tool Die LAC
CA06002221	Mfg Eng LAC
CA06002222	Build & Maint LAC
CA06002230	Purch LAC

I have cost centers that are linked to a general name. When a cost center is selected I want the Name to automatically show in another field. I do not have MS Access(or any experience in it) not sure how I would use Notepad and to be honest how to add another data source.

Re: Assign textbox value based on dropdown control selection

Ted Fitch — Mon, 07 Feb 2011 18:57:03 GMT

Hi CrystalA,

I created the secondary data source in MS Access and exported it as XML although you can create the XML resource file any number of ways (notepad for example). You can also use a SharePoint list as a secondary data source too.

Not sure what you mean by your second question though.

Ted

Re: Assign textbox value based on dropdown control selection

CrystalA — Mon, 07 Feb 2011 18:32:38 GMT

Ted, I came accross this in a web search and found exactly what I am looking to do in your example. I am not as advanced in InfoPath and did not know:

1. how you created the second data source

2. add the fields without taking up space on the form

Hopefully you can make it a little simple for me to understand, thanks so much for your time!

Re: Assign textbox value based on dropdown control selection

imstac — Tue, 16 Mar 2010 21:43:18 GMT

Hey, I got it working. I was copying and pasting the value formula into the value field and it didn't like it. I had to go through the steps of clicking on the icon, selecting my job_name field from my secondary data connection, clicking Filter Data and adding Job_no = ddl_jobno.

Thanks for your help guys!

Re: Assign textbox value based on dropdown control selection

imstac — Tue, 16 Mar 2010 19:44:45 GMT

What does '2DS' stand for?

I refreshed my datasource also that that didn't help.

Re: Assign textbox value based on dropdown control selection

ErnestoM — Tue, 16 Mar 2010 18:58:48 GMT

Hi Stacie,

Did the xpath (/dfs:myFields/dfs:dataFields/ns1:GetColumnsXMLStrQueryResponse/ns1:GetColumnsXMLStrQueryResult/Rows/row/Job_Name/ddl_jobno) on the 2DS change?

Re: Assign textbox value based on dropdown control selection

Ted Fitch — Tue, 16 Mar 2010 18:56:24 GMT

Hi Stacie,

I think you need to refresh your data connectin in InfoPath (just go through the modify options for the data connection and refresh it by following all prompts and saving). I think that should fix it up - you may need to adjust your rules though if fields have changed.

Ted

Re: Assign textbox value based on dropdown control selection

imstac — Tue, 16 Mar 2010 18:53:23 GMT

Ted,

I had to make a change to my Jobs data source and now I'm getting the following error with my rule:

"xdXDocument:GetDOM("Jobs")/dfs:myFields/dfs:dataFields/ns1:GetColumnsXMLStrQueryResponse/ns1:GetColumnsXMLStrQueryResult/Rows/row/Job_Name/ddl_jobno" does not point to a valid location path of a field or group.

My code is:

Job_Name[ddl_jobno = Job_No]

Re: Assign textbox value based on dropdown control selection

imstac — Tue, 16 Mar 2010 13:59:55 GMT

Awesome! Thanks Ted.

Re: Assign textbox value based on dropdown control selection

Ted Fitch — Mon, 15 Mar 2010 21:50:31 GMT

Stacie,

See attached, basically your scenario using a 2DS of jobs

The key is that the you need to filter the data this way:

JobName[ddl_jobno = ID]

This means that the job name shown in the text box is for the ID selected in the Main data source = the ID in the secondary data source

Ted

Re: Assign textbox value based on dropdown control selection

imstac — Mon, 15 Mar 2010 20:56:33 GMT

Ted,

I tried to change your code for my fields/data source and it kept giving me an error.

My data source is named Jobs. Fields are job_no and job_name

My dropdown list is named ddl_jobno and the value and display is set to job_no.

My textbox is named tbox_jobname

Just to clarify...when a user selects the job_no from the dropdown list the job_name value appears in the textbox.

Your code was: ID[Customers = FilterName]

I entered this for my code: Job_No[ddl_JobNo = Job_Name]

Not sure what I'm doing wrong.