Custom Form limit user choices

Ask the community
,
1

I have a custom form set up on my website. The form is connected to a dataset and submits the information to the dataset. In that form there’s a dropdown input. I want to create like a “formula” or something where once 2 people choose 1 of the options from the dropdown, that option will no longer appear to future visitors. It doesn’t need to be a dropdown, it can be a radio button or checkbox to display the options, but either way, once 2 people select that same option, it would no longer be pickable or disappear from the options listed. How can I do this?

Example: Every one who fills the form will pick a time slot from the dropdown, so once two people picked that time slot, it would no longer be available for the next person who fills the form.

2

You can add a field for each that keeps track of how many times that option has been chosen. When the field is equal to 2 you will then not include that option in the list of available options.

3

Hi Yisrael. Thank you for the tip. I’m very new to coding, could you please tell me how I would go about doing that in code? and in the database. Thanks!

4

@buenok You should first familiarize yourself with Wix Code basics . You can also play with the different database examples available here and here .

Best of luck and have fun