**Matthew Graves**Hi there i would like to cretae a really simple form for people to book onto different workshops listed, each workshop would have a quantity limit that once submitted the limit reduces relative to what each person selects?

so it will have 20 workshops each workshop has 9 places people can enter a max of 2 places per workshop per form and can onyly submit the form once.

But if they have a family of 5 they can palce each person in different workshops - so multiple workshops can be choses at a time.

i have tried to figure this out but i cant see how i can add a product whith a limited quantity? ot multoiple products on one page each with thier own quantity.

The form will only ever be filled out one person at a time.

can this be done?

Thanks

- JotForm Support
**jonathan**Hi Matthew,

Have you checked already the purchase order field? It is among the payment tools.

You can use this field as the "workshop" for products/item in the booking form. There is an

**option**for 'quantity' so, you can use that option for the number of booking per workshop.What it cannot do out-of-the-box however is, diminish an existing total/number, just like what your form idea was about.

But if you can use the form integration feature to google spreadsheet, you can perhaps compose some formulated worksheet along with

**form's integrated sheet**wherein the quantity field of the booking form will be included in the formula to subtract to an existing total. Everytime there is a submission on the form, the formula on the spreadsheet will be triggered and thus, the quantity will substract to the total.Hope this provided some help. Please feel free to contact us if you have further details to add.

Thanks.

**ecomatt**Thanks for your reply - iv been trying out all sorts of things with google spreadsheet integration.

All i have been able to do so far is have a feedback HTML block code which displayes a sum function from the spreadsheet, of the total number of places left to be booked.

The problem is when the number reaches 0 places left there is nothing that stops the form from being submited with another request. unless you know of a way that the form can get the quantity back from the spreadsheet and and once all the places are gone the quatity will be 0.

I have also being trying to do if functions that would block anymore entries from being submited once all places have been taken. Problem is i dont know anyone who knows how to do this in spreadsheets or even how you feedback to the live form.

Please if you have any further ideas of how this could be achieved it would be so much appreciated.

Why does jotform not just have an inventory counter? would be so much nicer and easier to do that way.

Thanks again

- JotForm Support
**jonathan**Hi,

You can actually use the forms submissions limit feature. Check this guide How-to-Limit-Submissions-in-a-Web-Form .

It maybe a long shot, but if you make the initial available total booking equivalent to number of submissions limit, then perhaps both the booking availability and the submissions would stop at the same number.

If you do need to go extreme in customization, you may opt to use the form's source code and apply your own function when you embed the form in your own website. This would require you to do your own programming and available hosting.

Please check this thread where a colleague offered a solution that uses the source code and applied a custom function to achieve the numerical calculations needed.

Hope this help.

Thanks.

**neoswf**Hi Jonathan.

This post is old, sorry for waking it up from the archives, But I would love to know if you guys have implemented this feature by now.

Its crucial for me to integrate it in my order form. if users have bought my products and exceeded my inventory limit, I need to update the form.

Hope theres a simpler way than communicating with google docs and checking value and than implementing it in my JotForm.

Can be done, But I hope theres an easier way.

Thank you!

- JotForm Support
**EltonCris**@neoswf

Unfortunately, we still do not have an easy way to do this. We can add your similar request to our development so atleast this gives addition to the number of request similar to this. We consider number of user requested the same feature, the more request the higher priority they could put in on the requested feature.

Please open your question in a separate thread so we can add it to our feature request list.

Thank you in advance.

Regards!

**helpchrisplz**+1