JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
To controle value of area, how associate a list of options who is in Excel sheet ?Asked by cris74 on January 21, 2016 at 05:56 PM
And when the list is upgraded , the list of options also upgraded.
En français : Comment associer une liste de valeurs contenues sur une feuille d'un classeur Excel pour contrôler les valeurs permises d'un champ du formulaire ? Et à chaque actualisation de cette liste, le contrôle doit automatiquement s'adapter aux nouvelles valeurs.
If my understanding of your inquiry is correct, I think you are looking for the Excel Report. Please check this user guide: How-to-create-an-Excel-Report
The Excel Report gest updated every time there is new submission on the form.
Hope this help. Let us know if this not what you were looking for.
Sorry but you aren't understanding my question.
On a form, I want to control a seizure information belongs to a list of
values that is on an Excel workbook. Is this possible on my JotForm form?
Le vendredi 22 janvier 2016, JotForm a écrit :
If I understand you correctly, you would like to verify that the information entered in your form is also in your excel file. I am assuming that if it is not, form should not be submitted.
If I am not correct, please let us know.
Unfortunately, this is not possible. You would need to use the source code and add code so you page can link to your excel file and make the verification.
The other possible option would be to integrate your form into a google spreadsheet and using formulas make the verification you are looking for.
Please let us know if you require further assistance.