How can I access pre-store information or file?

  • eastcoastec
    Asked on March 1, 2016 at 11:38 PM

    I would like to create an entry to take the input. Based on the input, I would like to display the results taking the input as key. For example, I have pre-defined information, key-value pairs, like this: 

     

    123ABC: 24;

    456BCD: 35;

    232DBD: 32;

     

    And the form take the input from the entry, for example, 123ABC, the page would display 24. If the entry is 456BCD, the page can display 35. If the input is not recognized, display "Not found!"

     

    How can I achieve that?  

  • Elton Support Team Lead
    Replied on March 2, 2016 at 6:29 AM

    You can achieve that by defining all the pairs in the calculation condition.

    Here's how:

    1. While on the form builder, click Conditions and select Update/Calculate Field

    How can I access pre store information or file? Image 1 Screenshot 30

    2. Then create the following condition.

    How can I access pre store information or file? Image 2 Screenshot 41

    3. If you want to add a different value, you can repeat the same condition and then define the new pair of value.

    Hope this helps!

     

  • eastcoastec
    Replied on March 2, 2016 at 10:55 AM

    Thanks so much for your information. But if I have thousands, or hundreds such pairs, does it mean that I have to add thousands or hundreds such logic conditions? Could I save the information someway so that it can read directly? 

  • Nik_C
    Replied on March 2, 2016 at 1:35 PM

    Hi,

    Unfortunately, you will have to create conditions for every pair as my colleague already suggested.

    if you have some number pairs that are repeating you could create a range of conditions that could cover specific range of pairs.

     

    Please let me know if i can be of some assistance to you.

    Best regards.