InfoPath Dev

Thank you. I was unable to open it earlier and opening it with Design was the key.

I am trying to piece together what you did. It is starting to make sense, but there are some pieces I need clarified. The Title_Lookup field on the Secondary data connection, is that something that I need to add? If I were to add it, I would need to know what it does. I also have been having trouble replicating the Career Summary field in the template you provided. I do not know how to make a lookup field without using the automated pulldown menus to select the value. When I look at the Control Properties, it shows only the Xpath. I am not sure how to create that.

Here is more about what I am trying to accomplish. I have a task list that is used to manage projects at various levels of development. The users submit a form that populates the Report List. A separate task list is used to track the development. The task list has a lookup field that pulls the ReportTitle from the Report List. I currenly have the ReportTitle linked to the item in Report List. I would like now to have the Title in the task list be calculated to display the ReportTitle.

I was able to pull in the Value for the ReportTitle to the Title in my task list, but unfortunately the Value set for the ReportTitle is the ID. I can change the Value to pull in the Title, but then I run into the error that the referenced field needs to be a positive integer. I also was able to create a lookup field that does not link to the item that did not have the integer error, but I would prefer for the item to be linked.

It is important to me to have the task Title use the text from the ReportTitle so that the task email sent makes sense. For instance, the subject line would say “Development – MTD Regional Sales Report has been assigned to you” versus “Development – 203 has been assigned to you”.

I have attached a copy of my task list form in case it would be easier to understand by looking. I appreciate any input you are able to provide.

 Okay - so, looking at your template, I see that there is a default value in the Title field - did you add that? InfoPath forms for SharePoint Lists sometimes add wacky things on their own is why I ask.

So - you have a lookup that already pulls the Report Title? Which field is that? Is that the Related Content field?

If so, I'd think the default you'd want for your title field would be:

xdXDocument:GetDOM("Report List")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title[../d:ID = current()/my:ReportTitle]

Hi Hilary,

I am experiencing something similar.  I have read most of the posts pertaining to multiple selection list boxes, but have yet to discover a solution to my problem.  I am populating a MSLB with a lookup column populated from an external SPL.  This list has only 2 columns (ID and SoftwareTitle).  When the MSLB items are selected, I want the sections to display and save into a list box on the form for later access. When I make the selection(s) in the MSLB the LB below it only displays the corresponding ID to the SoftwareTitle.  Is there a workaround for this.  Thanks!!!

 

Hi 2Blew,

Hilary is on sabbatical.

I don't quite understand what you are doing, but I'm guessing that the actual value of the selection is the ID and not the SoftwareTitle. You can use a calculated value to lookup the SoftwareTitle based on the ID.

Maybe I need more info to understand....

Good morning, Patrick,

I have a main list (Doc Projects) that uses a secondary list (SoftwarePrereqs) to grab software titles.  On the InfoPath form I have a multiple selection list box where the user can select one or more software titles.  As the users selects or de-selects titles, I would like for those selected titles to appear below in a list box and saved for future reference.  Currently, the form allows the user to select the titles; however, the list box below only shows the ID of the selected titles.  Is this explanation any better?  Thanks for your assistance.  

 My guess would be that in your multi select list box the value is the ID of the item. You may need to either change that to store the title instead, or perhaps display the secondary data titles that match the selected IDs.

hello everyone, so I am trying to use InfoPath to create my forms which reside in SharePoint online and currently I'm getting this two errors any help will be appreciate it and I have attached my form as well error: The form contains the following errors: Field or group: my:category Error: Only positive integers allowed Field or group: my:Application Error: Only positive integers allowed