Using large csv file for form

I am building out a calculator using Formidable. I have a .csv file that includes electricity rates for every ZIP code in the US. The goal is for users to enter in the ZIP code, which would then be linked to a predetermined rate (which we would use for final calculations). I do not want the rates to be shown to the user. The functionality would be similar to that of the Dropdown with Separate Values option, but rather than choosing a ZIP code from a massive dropdown, the user would enter it in a text field.

Any ideas on how I can do this? I tried importing the file and linking the two fields but they import as entries. I am a little confused about this process so any help/insights would be greatly appreciated.

• This topic was modified 4 years, 3 months ago by tylerbeairsto. Reason: added a link to the site although the form is not live

The page I need help with: [log in to see the link]