Newbie Questions

Re: Insert new item in repeating section removes data from the prior item

Hilary Stoupa — Thu, 05 Jan 2017 16:00:49 GMT

Just emailed you via the forum - you can reply to my email w/ the form attached & I'll take a quick look later today. :)

Re: Insert new item in repeating section removes data from the prior item

agtmak — Thu, 05 Jan 2017 15:55:54 GMT

I will send you the .xsn through a PM. Appreciate you looking at this!

**edit**: Seems I can't send it through PM. I tried to attach it to this post, but it is greater than 500kb.

Re: Insert new item in repeating section removes data from the prior item

Hilary Stoupa — Thu, 05 Jan 2017 15:45:53 GMT

Oh - is the sample name in its own repeating section that is bound to a different data source? If so, that may explain the issue. Do you mind attaching a copy of your form under the "Options" tab & I can take a quick look at it?

Insert new item in repeating section removes data from the prior item

agtmak — Thu, 05 Jan 2017 15:17:48 GMT

Hello,

I have an InfoPath form I'm working with that is used for an internal R&D process around product cuttings. The data model I have created in SharePoint is 3 lists: Cuttings, Samples, and Evaluations. So how it works is the person in R&D will create an item in the cuttings list, create samples linked to a cutting in the samples list, and employees will give their feedback in the evaluations list. The InfoPath form I have created is on the Evaluations list.

On the form, an employee has to select a cutting (data source: cuttings list). Once a cutting is selected, employees have to select a sample #. The sample #s are filtered to the selected cutting (data source: samples list w/ selected cutting as a filter). Below the sample # dropdown, I have a repeating section which just pulls back the name of the selected sample #. Afterwards, there are some fields to evaluate the sample. All of these are in a repeating section as sometimes a cutting can have multiple samples we need to evaluate.

Now here's my issue: when an employee evaluates multiple samples (insert new item), the sample name disappears from the prior item.

Example:
Cutting: Bacon
Sample #: 123
Sample Name: Thick cut (this is in its own repeating section, I used this to pull back the name from the sample #)
Color: 3
Texture: 3
Saltiness: 3
Overall Liking: 7

*insert new item*
The prior item will now say:
Cutting: Bacon
Sample #: 123
Sample Name: (blank)

If I select a sample # in the new item, it will change the sample name for all of the prior and current items.

Any ideas?