InfoPath Dev

Hi is it possible to limit how many forms get submitted to a SharePoint form library.

here is the scenario, i work in a school, the students every term have to select what lunchtime sports activities they want to do, places for these activities are limited, so if an activity has 20 places I want the form to become read only when twenty forms have been submitted, is this possible......... thanks

Garry

Hi,

There are a large number of ways to do this, the easiest probably being to to add a data connection recieving data from the list the form is hosted on and then adding a rule in the open and save rules section to switch views:

The following is off the top of head so apologies if not totally correct.

1) Create new view, design tasks, views, create view. Flick back to the first view copy the entire form and poaste into new view. Now you to go through the text boxes etc and change them to read only on the new view. (If You have Date Pickers etc. Change them to text boxes first)
2) Create recieving data conncetion to list form is hosted on. Select ID and finish.
3) Creat Rule when form is opened. Tools\form option\open and save\Rule, click new rule, set condition to if max(@ID) = 21, than add action to switch view to the locked version.

Better still and easier is to create a new viewing saying this event is full rather than locking the form.

One thing you could do is look into the 'count' function as it would be accurate than max(@ID). The form will drop in and out of the full state view allowing students to register if someone drops out provided that form is removed from the list.

What you are doing is fun to play around with and I'm sure you'll find other more slicker ways of doing it in your exploits.

Good luck

Hi Thanks for this it has helped me, but was wondering is it possable to do a count on submission.

 Here is what i'm looking for, i have a Drop-Down List Box called Sport, one of the options in this list box is for example Squash, what i'm trying to do is see how many forms have been sent back with squash in the sport field so if there are already three forms with Squash in the sport field any person trying to submit a further form with Squash in the Sport field will not be able to.

Is this possable

 Thanks

Garry