General

Re: Text Box with Only Positive Integers Allowed error (ASAP Help)

sajan — Wed, 24 Jan 2018 18:56:38 GMT

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

Re: Text Box with Only Positive Integers Allowed error

Hilary Stoupa — Mon, 02 Sep 2013 15:44:22 GMT

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.

Re: Text Box with Only Positive Integers Allowed error

2Blew — Mon, 12 Aug 2013 12:09:46 GMT

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.

Re: Text Box with Only Positive Integers Allowed error

Patrick Halstead — Sun, 11 Aug 2013 05:11:01 GMT

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....

Re: Text Box with Only Positive Integers Allowed error

2Blew — Thu, 08 Aug 2013 20:02:50 GMT

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!!!

Re: Text Box with Only Positive Integers Allowed error

Hilary Stoupa — Thu, 28 Mar 2013 22:02:51 GMT

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]

Re: Text Box with Only Positive Integers Allowed error

Aimee Jacobson — Wed, 27 Mar 2013 21:31:57 GMT

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.

Re: Text Box with Only Positive Integers Allowed error

Hilary Stoupa — Wed, 27 Mar 2013 18:53:06 GMT

There are some sample templates in this thread - try saving one of them locally (right click - save as) and then from the local copy, right click and select design to open - see if that helps. If not, let me know & I'll review the thread (it has been a while & it is not fresh in my mind...)

Re: Text Box with Only Positive Integers Allowed error

Aimee Jacobson — Wed, 27 Mar 2013 18:24:19 GMT

Would you be willing to post the formulas you used to calculate the value? I spent the majority of my day yesterday trying anything I could think of, including trying to calculate the value and still only managed to pull in the ID.

Hilary Stoupa:
Okay, but you see, the thing is the underlying data type is an integer - that's why if you set the value to the ID, the error goes away.

Instead of displaying the form field in the form, you could use a calculated value that shows the data you want based on the ID in the field. Attach your template under the Options tab in a reply if you'd like me to show you what I mean. :-)

Re: Text Box with Only Positive Integers Allowed error

SustainableOn — Wed, 18 Jul 2012 17:27:47 GMT

What a pain in the cranium! Solution, Finally! Step 1 - Add multiline text columns in the SharePoint list. I named mine close to the Lookup Column field. Ex. Summary (multiline text column) and LK_Summary (Lookup Summary column). Step 2 – Open InfoPath form to edit. Step 3 – If the new multiline text columns did not come over already on the form, simply add them to your form by dragging them over from the Fields (should show up on the right side of the InfoPath program). Step 4 – With the Text box selected in the form, go to the Fields right click on the Lookup Field that correlates to your Multiline Text box (Summary and LK_Summary for mine). Open Drop-Down List Properties. This will add a new box under the text box in the form. Step 5 – With the new box added under the text box in the form, right click on the new box and open the Drop-Down List Box Properties. Step 6 – Connect your Data Source Step 7 – Make sure your Entries field is correct. Step 8 – Change the Value to d:ID Step 9 – Change Display name: d:ID Step 10 – Apply changes and hit OK to exit Step 11 – Go up to your Multiline Text box, right click and open Text Box Properties (or Rich Text Box Properties). Step 12 – Click on the fx (function) key to add a value. Step 13 - Select the Lookup Field for the data source at the secondary level. This is the SharePoint list that is driving the lookup values for the column. In my case it was Summary_Description as this is the original name of the custom list in SharePoint. Step 14 – Add any filters to auto-populate the field. In my case I am filtering based on a Title with a lookup to that same Title to filter content in the Summary Description table. Step 15 – Click OK to save and close out of all open boxes. Step 16 – Remove the Lookup box under your multiline text box. Say what? Yes you can remove the box and InfoPath will keep the connections that you built and it seems to work fine. Step 17 – Preview the form to make sure it works. Step 18 – Publish the form and take the rest of the day off!

Re: Text Box with Only Positive Integers Allowed error

Hilary Stoupa — Tue, 17 Jul 2012 22:52:23 GMT

You had a lot of default values - drag the main data source onto your form so you can see what fields are actually being set to (change the data source task pane to the advance view to make it easier for yourself). Again, the error is occurring (most likely) because you have set one of these lookup fields to a text string instead of a list item ID.

Re: Text Box with Only Positive Integers Allowed error

SustainableOn — Tue, 17 Jul 2012 22:36:39 GMT

Arghhhh! still back to the positive integer error. This time it is not highlighting the text area but comes up in a different error message box when you submit the form.

Re: Text Box with Only Positive Integers Allowed error

Hilary Stoupa — Tue, 17 Jul 2012 22:28:39 GMT

You bet - glad that was what you needed! :-)

Re: Text Box with Only Positive Integers Allowed error

SustainableOn — Tue, 17 Jul 2012 22:25:11 GMT

You rock! Yes this is what I was looking for! Thank you so much. The Summary Description field is doing what it needs to. I'll change out the other values in the form and I should be good to go. Thank you again for helping me out on this!

Re: Text Box with Only Positive Integers Allowed error

SustainableOn — Tue, 17 Jul 2012 22:16:32 GMT

the file will not open for me. Error says it has restricted read permissions on it. never mind, got it opened.