Interest in Data Validation in Jotform (With Example)

  • Profile Image
    Klaus 
    Asked on September 05, 2019 at 07:11 AM

    Dear Jotform Customer Support Team, 

    I wrote you yesterday with a similar inquiry and got a very usefull answer after just a few hours, which was excellent. 

    After reading it through i realized that I do have some other questions so here goes:


    - Do you support Data Validation in Jotform? 


    Example:

    I have a concrete example where I would like to set up a form that includes a field asking the user about what brand they need a link for. Then based on their answer I would like for the form to automatically assign the brand-owner to their request in a hidden field. 


    So if the user say they need a link for BRAND X then PERSON A is tagged, and if another user responds with BRAND Y, then PERSON B is tagged. 


    We have a sheet of about 500 different brands (all with corresponding brand-owners) that we would like to upload ad include in the form for data validation. Is this possible? 


    Let me know if you need any further information. 
    Thank you - Looking forward to hearing from you.


    Best Regards, 

    Klaus

  • Profile Image
    Richie_P
    Answered on September 05, 2019 at 08:42 AM

    We do have a spreadsheet to form widget that can populate the data in your sheet into your form field.

    Guide:https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Sample Form:https://form.jotform.com/81225198727968

    You may hide this field when the user enters the Brand code in the Spreadsheet to form widget.

    Kindly check it out and let us know if this fits your requirements.