Forminator decrement counter automatically

Hi @andycucca,

I hope you are doing well today!

In order to understand correctly, you will have a one select field as the number of seats which the visitor wants to buy and you need it to start at the max limit as 200 and decrease this value after each submission of the form. So, it will start at 200 and if the first user visits and buys 10 seats then the next one will see this field maximum value set to 190 is this correct?

Kind regards,
Zafer

Yes, it is absolutely correct.

Thanks

You will find the form at the following link: https://app.box.com/s/2ffv2z95vzkhn0eve0jjlunqdr2y38y1

The field is {select-4} = pranzo convenzionato that can have a number of meals to decrement from 0 to 6.

Have a nice day, regards
Andrea

Hi again @andycucca,

Thanks for sharing the export. I imported and checked the form. We will need another confirmation to understand your request better.

Select field with ID select-4 is the number of meals and ELO which is the number field with ID number-1, maximum limit is set to 2900 and 1200 as default. Which field’s maximum limit value will be decreased on each submission? Are we going to decrease the maximum limit of number-1 as per the quantity of select-4 after each submission? Please clarify once more so that we can help you better. Thanks for your understanding.

Kind regards,
Zafer

Hello,

Actually in the form there is not a limt numer to decrement, I think I have add an hidden calculation-5 field fixed to 200 and you can use it to manage it.

Therefore the logic is that each submission made must decrease the calculation-5 field by the number of meals indicated in the select-4 field. When the number in calculation-5 reaches 0, we have to inhibit the selection of further meals in select-4 field.

The form with hidden calculation-5 field is avalaible here: :https://app.box.com/s/6ctku5jmnw8ekujkeh8ny7x7vsq6p9d0

Thanks in advance for your help and kind regards

Andrea

If inhibit the selection of further meals in select-4 field is too difficult, maybe it could be enough send an email warning that the number of 200 seats has been reached or, for example, that at 190 seats the system warns that 200 it is probably about to be reached soon.

Thanks again

• This reply was modified 1 year ago by andycucca.

Hi @andycucca

Thank you for your explanation.

Unfortunately, without some custom coding, it wouldn’t be possible but what about using Google Sheets to control it?

You can integrate the Form in Google Sheets: https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#google-sheets then in select-4 change the value to 0, 1, 3,4 …

https://monosnap.com/file/zc3HrzUJpWewLGQuQq28KODYdGjhXC

Then you can sum your column using Google Sheets to control it, it would still need to keep eye on it though but Google sheet has some automation https://www.groovypost.com/howto/google-sheets-send-email-based-on-cell-value/

Let us know if that would help your needs.
Best Regards
Patrick Freitas

Thanks, you can close the ticket.