Input validation - Field input validate against a huge list of codes - Spreadsheet to Form Widget

  • Profile Image
    Michael Burkert
    Asked on February 28, 2020 at 07:15 AM

    Hi,

    Is it possible to validate a field input vs a list of values? I am looking to use your mobile forms app in kiosk mode for event sign ins. Each attendee has a unique ticket code. I would like to include a questions in the form asking for the attendee code. Attendees specify the code and it is checked against a list of codes. Only if the code exists, the form can be submitted.

    Michael


  • Profile Image
    DawoodMD
    Answered on February 28, 2020 at 11:02 AM

    Hello Michael,

    Thank you for contacting us!

    You can achieve your expectation using the 'short text entry' element, by setting some 'conditions' to validate attendee codes. I have demonstrated the step using a screencast, below:-

    1582905253Edit Submission.gif

    Using 'conditions', please set up some codes for your users to validate. Unless they enter a valid code, they wouldn't be redirected to submit their submissions. This can be a good workaround to your requirement.

    I hope it helps. Please do not hesitate to reach out to us if you have additional questions.

  • Profile Image
    Michael Burkert
    Answered on February 28, 2020 at 11:14 AM

    Thanks for the update. The issue is that there are hundreds of codes. Unless they can be uploaded as a list in one go, this workaround is not feasible.

    Michael 

  • Profile Image
    DawoodMD
    Answered on February 28, 2020 at 01:11 PM

    Hi Michael,

    I will escalate this for a good to have feature request.

    If we add it to our platform, we will get back to you on this thread.

  • Profile Image
    AgilityAssoc.Canada
    Answered on February 28, 2020 at 01:46 PM

    Just a thought, could Sheet to Form Widget work.

    You have all your valid codes on a spread sheet and entries are compared to the valid ones. Valid are accepted others not accepted. I use this widget for a number of forms to validate membership.

    Robert


  • Profile Image
    intoTRI
    Answered on February 28, 2020 at 02:02 PM

    Awesome Robert, that works exactly as required. Thanks a lot for your help! 

  • Profile Image
    DawoodMD
    Answered on February 28, 2020 at 02:54 PM

    Hello @Robert,

    Thank you for this excellent suggestion!

    I am sorry @Michael. I couldn't have said it better myself.

    The widget supports the short text entry field.

    Please find the complete guide hereSpreadsheet to Form Widget


  • Profile Image
    AgilityAssoc.Canada
    Answered on February 28, 2020 at 04:20 PM

    You are very welcome...

    Robert