How can I look up values from a table?

  • Profile Image
    PartyShirts
    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
    david
    Answered on September 22, 2014 at 02:13 PM

    Hi,

    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.  

    http://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    http://www.jotform.com/help/245-How-to-Setup-Webhook-with-JotForm

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