General

Re: Repeating Section

Hilary Stoupa — Mon, 24 Jul 2017 23:45:56 GMT

Here's a modified copy of my default data form where I've changed the formula to set the serial number to handle for any number of digits after the dash. Instead of the "4" in the formula, you use the string-length of the substring after the "-".

Re: Repeating Section

Tukayoo — Mon, 24 Jul 2017 18:41:04 GMT

Ok, I was wondering about that. I think that is doable with a workflow. ok sounds good.

Re: Repeating Section

Hilary Stoupa — Mon, 24 Jul 2017 18:28:31 GMT

Oh man, hadn't thought of that - yes, as a list form, non displayed items will be submitted. You'll need to add a workflow to remove anything where display = false, I think. I'll think on the serial number thing later today & see if I can come up with an option.

Re: Repeating Section

Tukayoo — Mon, 24 Jul 2017 18:21:12 GMT

Awesome thank you so much. That works. Is there a way though to make it that no matter how many digits come after the "-" in the serial number that it will automatically use that number of digits. there are times that we may have xx-xxx and sometimes xx-xxxx. and just a quick clarification, if the sections are hidden they will not be submitted to the list correct?

Re: Repeating Section

Hilary Stoupa — Mon, 24 Jul 2017 15:52:43 GMT

I had an extra paren on that formula, sorry about that. Try the attached copy. Couple of things - the button needs to be outside the repeating section to act on all instances of set value. The default data needed to have display set to false for all instances except the first.

Re: Repeating Section

Tukayoo — Mon, 24 Jul 2017 15:39:10 GMT

I tried putting that in and it is still showing all of the sections when I preview the form instead of hiding them all. I don't know what I am missing.

Re: Repeating Section

Hilary Stoupa — Fri, 21 Jul 2017 15:13:00 GMT

I think the condition on your setvalue with the preceding sibling formula should be:

count(../preceding-sibling::my:SharePointListItem_RW) <= ../preceding-sibling::my:SharePointListItem_RW/my:NumRecAdd[. != ""])

Re: Repeating Section

Tukayoo — Tue, 18 Jul 2017 23:08:16 GMT

well I have been playing around with and seem to missing something. wondering if you might be able to take a look at what I have and see where I went wrong. much appreciated

Re: Repeating Section

Tukayoo — Tue, 18 Jul 2017 19:12:04 GMT

ok, I think I follow. I will have to play around with it a bit more and see if I can figure it out fully. not sure how to go about getting it to work with a list based form but you have set me on the right track. thanks

Re: Repeating Section

Hilary Stoupa — Tue, 18 Jul 2017 19:11:25 GMT

Here's an update that allows zero padding in the last 4 chars of the serial number

Re: Repeating Section

Hilary Stoupa — Tue, 18 Jul 2017 17:00:41 GMT

In a list form, you'd have to have a column for these helper fields - you could just not display it on the list views, I suppose. It is just that with repeating data, we need a field inside the repeating group to act on each item in the group. Make sense?

Re: Repeating Section

Tukayoo — Tue, 18 Jul 2017 16:52:33 GMT

so I figured out the optional attribute field (field attribute) deal. I can add that when creating a blank from or form library form but I don't see how to achieve that in a SharePoint list form. can this be done in a list form?

Re: Repeating Section

Hilary Stoupa — Tue, 18 Jul 2017 16:39:34 GMT

Wait - this is a SharePoint List form? Or a regular InfoPath form?

Re: Repeating Section

Tukayoo — Tue, 18 Jul 2017 16:37:16 GMT

Ok thanks, I will take a look at that. I look forward to the solution. So what I am asking is you mention that there were some helper fields in the form, and when I look in the list of fields in advanced view I see that they are gray in color rather than white like the normal fields. how to you add these helper/supporting fields? these fields are not submitted as data for the list.

Re: Repeating Section

Hilary Stoupa — Tue, 18 Jul 2017 15:57:49 GMT

I only added 20 rows to the default - Under the Data tab in the ribbon, look for the Default button and you can add more. Oh, zero padding is fun, I'll update the sample later today with that. I don't understand your last question - can you clarify?