InfoPath 2010

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Mon, 13 Feb 2017 00:32:50 GMT

Hilary Stoupa:
Sure, and if it turns out you actually only want to answer those questions 1x for the whole form, let me know, I have some tricks for that too (we can use some helper fields & populate your main data source repeating group fields on submit, for example)...

Hello Hilary :)

I hope you are well, I was wondering if you would be able to share with me those tricks you were mentioning earlier in order to answer some of the questions only 1x for the whole form?

Kind regards,

Nate

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Tue, 07 Feb 2017 21:26:35 GMT

Thank you so much for sending that through. I'm having some trouble accessing the file, so in the mean time I was wondering if you would be able to explain further on what you did? Maybe add some screenshots? Im terribly sorry for the hassles with this matter

Re: Inserting New Row on Repeating Table Ignores Rules?

Hilary Stoupa — Mon, 06 Feb 2017 15:47:59 GMT

Sent, and removed the email address from your post to protect you from SPAMmers. :)

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Sun, 05 Feb 2017 22:03:25 GMT

Hello Hilary,

Unfortunately I still haven't received the file. Not sure why it isn't coming through now.

Re: Inserting New Row on Repeating Table Ignores Rules?

Hilary Stoupa — Fri, 03 Feb 2017 15:47:09 GMT

I resent - and changed the file extension from .xsn to .txt. Just change the extension back. Let me know if you don't get it, or send me another email w/ an alternate email address, or I can upload to HighTail & send you a link.

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Thu, 02 Feb 2017 23:59:10 GMT

I appreciate that, once I get that answer confirmed and if that needs to happen, ill be in contact. I haven't seemed to receive the file yet through email. In the case that the network doesn't let the initial email through (can happen on occasion), would you be able to send through a second email, just in case? Thanks in advance, and sorry again for the hassle

Re: Inserting New Row on Repeating Table Ignores Rules?

Hilary Stoupa — Thu, 02 Feb 2017 23:33:27 GMT

Sure, and if it turns out you actually only want to answer those questions 1x for the whole form, let me know, I have some tricks for that too (we can use some helper fields & populate your main data source repeating group fields on submit, for example)...

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Thu, 02 Feb 2017 23:25:35 GMT

haha "copied the whole mess" that is an accurate description of the form. Thank you for spending the time to help me out with this, its greatly appreciated :)

Re: Inserting New Row on Repeating Table Ignores Rules?

Hilary Stoupa — Thu, 02 Feb 2017 23:21:58 GMT

Rebinding fixed the issue I was seeing & yah, I'll email the file to you. That wasn't a normal thing to have to do - I think it was because they were in sections bound to fields outside the repeating group, and then I just copied the whole mess into the repeating group section :)

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Thu, 02 Feb 2017 23:12:44 GMT

I really appreciate your help with this issue :) I will try and have a look at the sample and see how it is. However I wont be able to download the copy you attached, due to restrictions on my works network. Is it possible to email it to the same address you messaged me on earlier? I apologise for the inconvenience.

Did rebinding them sort it out? That seems a little weird that it is required to bind them incorrectly and then rebind them for InfoPath to work properly in that regard.

Re: Inserting New Row on Repeating Table Ignores Rules?

Hilary Stoupa — Thu, 02 Feb 2017 22:59:52 GMT

Here's a copy of your form set up w/ repeating sections - one thing I noticed was I initially had the same issue w/ your dropdowns, even when I had them inside appropriately bound section - I ended up rebinding the dropdowns (right click, change binding, select random field inside the repeating table, change binding again and select correct field). Save the file locally, right click and select design to open in design mode. :)

Re: Inserting New Row on Repeating Table Ignores Rules?

Hilary Stoupa — Thu, 02 Feb 2017 18:08:02 GMT

Well - later today I'll do up a sample based on the form you sent me so you have a couple options you can look at. :)

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Thu, 02 Feb 2017 02:48:11 GMT

I have also tried using repeating sections, and I have the same issue. I may be way off on how im laying this out

Re: Inserting New Row on Repeating Table Ignores Rules?

Nate003 — Thu, 02 Feb 2017 02:19:22 GMT

At this point in time, it is unclear if all of the answers will be required on all rows of the database. There is a possibility that some will be required over all rows, while others may not. I am aware that you can set a default value using the last() function to have a fields data be repeated on every row. But yes, my laying out is not great or efficient, I am only new with InfoPath and have been learning and teaching myself so I imagine a few of my issue lay within the sectioning

Re: Inserting New Row on Repeating Table Ignores Rules?

Hilary Stoupa — Wed, 01 Feb 2017 23:44:49 GMT

This is all related to how you've laid this out - you have the repeating fields in non-repeating sections, which I am sure is causing a number of issues. What is your desired outcome? That the user answers those questions only one time, but in the database, all rows have the same answer?