To controle value of area, how associate a list of options who is in Excel sheet ?

  • Profile Image
    Asked 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.

  • Profile Image
    Answered on January 22, 2016 at 01:09 AM


    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.




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