Re: Checking Fields Against Repeating Table

Bre Huston — Mon, 08 Sep 2014 16:26:04 GMT

Hello FSU_InfoPathUser,

Thank you for you inquiry. In order to check the entries individually in the repeating table, I would suggest requiring the data source using a query value. Each time a user enters a value in the repeating group, the query field of the 2DS should be set and then required. If the entry exists then an error message should display. you can then disable the submit using the same logic.

Thanks,
Bre

Bre Huston | Form Designer

Qdabra® Software / InfoPathDev.com / FormsQuo / 877.544.2389 main / 425.318.7843 direct

Business Process Automation for Everyone – Streamline data gathering to turn process into knowledge.™

Checking Fields Against Repeating Table

FSU_InfoPathUser — Wed, 20 Aug 2014 13:37:13 GMT

I'm working on a room reservation form and one of the features I'm trying to include is to check to see if the room has already been reserved for a certain date/time.

My form pulls in all of the existing reserved dates and times from a separate SharePoint list. The dates and times go into a hidden repeating table. I have some conditional formatting set up to check to see if the user's desired time overlaps with any of the existing reservations in that hidden repeating table. It works for the first time slot in the repeating table but not for any others.

Any tips on how I can get my form to check against all of the rows in the table, not just the first one? If the solution requires code, can you point me in the direction of some sort of InfoPath code 101 resource?

Thanks and please let me know if I need to provide any additional information!

General

Re: Checking Fields Against Repeating Table

Checking Fields Against Repeating Table