What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can I import a csv and have the new records recognised by a unique question on a fieldAsked by dbis on March 12, 2016 at 03:20 AM
We have a booking form with times but teachers would like to block out some of the times en masse.
Rather than them putting a lot of dummy records in, I tried uploading the required records using the Import CSV. However when I try to add an entry using one of the blocked out times it still allows me.
How do I convince the system that these times are already booked?
If you are trying to limit some time slots, you may want to try using the Limit Dates feature of our DateTime fields:
This will allow you to disable certain entries automatically, without needing to create entries for each date/time you would like to disable.
Alternatively to that, if you are not using a DateTime field, you can use one of our widgets to allow your users submit only the amount of options that you would like to allow. For example, you can use any of the following widgets:
Inventory widget, allows an item to be selected multiple times (specified amount of times)
Gift Registry widget, allows an item to be selected multiple times (specified amount of times)
Appointment Slots widget, allows an item to be selected multiple times (specified amount of times)
You can simply set them up so that each available item/time slot can be selected only once, and not worry that there will be multiple selections of the same in your submissions. Here is a guide on how to add widgets to your form:
Please let us know if this will work to your satisfaction.
Thank you! I have used the Appointment Slots in the end.
Great to hear that Appointment Slots widget satisfied your requirements, thank you for updating us.
If there is anything else we can help you with, please don't hesitate to contact us again. We are here to help as much as we can, as always. :)
I need this same issue resolved but because these widgets are hosted outside of jotform, many organizations we work with block this content. They can see jotform content fine, but the widget content is invisible. Is there a way to set some kind of form limit that no more than 5 people can check a certain box, or choose a certain item from a dropdown menu? Could this be added?
@volunteeruwgc, in order for us to better assist you, your question has been moved to a support thread of its own:
We will be assisting you with it there, thank you.