Is it possible to validate data with JotForm?

  • Profile Image
    Monique van Zundert 
    Asked on April 08, 2019 at 03:56 AM

    Hi,


    Is it possible to validate data with JotForm? For instance that a field only can be filled with certain EAN codes.

  • Profile Image
    jonathan
    Answered on April 08, 2019 at 08:24 AM

    Thank you for contacting us. I also recommend creating an account first if you haven't yet.

    You can sign up using your email account here https://www.jotform.com/signup

    As to your inquiry, some fields already have data validation properties.

    Example the Short Entry field (Textbox)

    1554726114zzz 2019-04-08 20.18.43.png


    By EAN codes I think you meant the barcode.

    Please check this similar discussion thread for information.

    https://www.jotform.com/answers/1072798-EAN-13-check-digit

    Let us know if you need further assistance.



  • Profile Image
    Monique van Zundert 
    Answered on April 08, 2019 at 09:43 AM
    Hi Jonathan,
    That's not quit what I mean; for instance there are 100 valid serial numbers, and I want someone to fill in a valid serial number, I only want them to be able to finish the form of the serial number matches one of the hundred. Is that possible?
    Met vriendelijke groet / kind regards,
    Monique van Zundert
    Marketing manager
    Smartwares Group
    ________________________________
    ...
  • Profile Image
    Kevin_G
    Answered on April 08, 2019 at 11:19 AM

    I think the only way to do this may be with the Spreadsheet to Form widget, you may add the list of codes to your sheet and link it to the form, then ask the user for the code and set conditional logic to allow the submission for that. 

    This guide will help you with the widget: https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    This guide will help you with conditional logic: https://www.jotform.com/help/316-How-to-Show-or-Hide-Fields-Base-on-User-s-Answer