How can I look up values from a table?

  • Profile Image
    Asked on September 22, 2014 at 12:43 PM

    The user will enter a 5 digit code. I want to then return a dollar value by looking up that 5 digit code in a table that I will create. Each code has it's own dollar value. For example, code 29888 = $3,200. There are over 1,000 codes, so it's not reasonable to manually enter the values.

  • Profile Image
    Answered on September 22, 2014 at 02:13 PM


    Unfortunately, manually entering each code is the only solution available inherently with JotForm.  Unless you would like to use your forms source code and link it to a database, there is no way to reference a list of number to grab the associated value.

    This would take a fair bit of setup and customization outside of what we support but it is possible.