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.


  • Profile Image

    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.

    Merci d'avance.

    Page URL:
    http://www.golf-coders74.org/inscription-sortie/

    excel sheet
  • Profile Image
    JotForm Support

    Answered by jonathan on January 22, 2016 at 01:09 AM

    Hi,

    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.

    Thanks. 

     

     

  • Profile Image

    Answered by cris74 on January 22, 2016 at 03:45 AM
    Hello,
    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 :
    ...
  • Profile Image

    Answered by victor on January 22, 2016 at 08:40 AM

    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.