InfoPath Dev

Here's a copy w/ a rule on the Submit button to disable it - it is basically the same XPath as the calculated value next to the text "At Limit" which I hope is currently displaying true / false correctly? In the first dropdown for the condition, you can select the repeating data row in the connection to the main list, then change ...

I think I understand. So how am I able to now compare the calculated value to the 'Attendee Limit' control. Calculated values are slightly different and do not display in dropdown of data/query fields right?

So, in general - here's what is going on. The list you submit to has all the attendees for a course. We query that very same list, using the query field to get back only data for the course the user has just selected in the form. That way we can count the rows returned (and also - we aren't querying for more data than we need!) and figure ...

This is awesome. You are correctly pulling the count number I am looking to compare in your "Count of List items for Course". Now I am just trying to wrap my head around & understand how all of this is being pulled so I truly understand it and know going forward. Then I can set my additional conditions ( i.e. Limit vs Count; if ...

Try this one - save it locally, right click and select design to open in design mode, then preview and select a course. Since I can't preview it, and am making a bunch of guesses about functionality, I put the new data connection on the form so you can try setting the course manually and clicking the query button to check the data results. I ...

Hilary, I've added the data connection. You will see 'Test Connection....' You'll notice some other customization in there, but if you could assist with what you've described above I would greatly appreciate! The Limit field is being pulled in from another SP list and is in a hidden field. It is being set when a user ...

Yah it is really baffling. But the columns you've promoted are in the Library > Settings > Columns in 1a, right? Just no data showing in them.... Are you using site columns for these? Maybe that's what's different - maybe you'd used site columns for the others, but not for these? Sorry - I'm just confused as to how this ...

The Course field is set as unique. So there can never be the same value in Course. For instance, if there are two sections of a Math course, they would have to name them differently such as "Math - AM" and "Math - PM" ........ Multiple people can register for each course, but there is a specific 'Limit' of people who ...

I should add - here's my guess of what would work here - add a data connection to the list with the grouped view that includes the course name field. Set the query to not run when the form opens (that's a checkbox toward the end of the data connection wizard). In the form, when the user selects a course, add a rule to set the course name ...

 Yeah, I recall trying to figure out how to use a content type for the form when we had to move to the three library set up, but didn't have the expertise to do it.  We were on a tight turn around as we previous were just using one library and it crashed on me (I could no longer publish updates due to timeout issues likely caused by ...