How to find and compare data from a form in a CSV?

I am creating an app that shows if you require a visa to visit a country depending on your nationality.

For this I have a CSV file with the data:

  • Nationality
  • Destination
  • Visa (YES, NO)

In my app I have a form, on the one hand a field asks for the nationality and the other the destination, but I can’t find a way to create a formula that compares and searches the CSV file to return the result.

For example, I have in column A (Nationality) = Argentina, column B (Destination) = Thailand, column C (Visa) = No

what I need is some way to perform a search and comparison:

If Nationality is equal to column A and Destination is the same in column B, the result is what is in the same row of column C.

Any ideas?

Hi @Maxiogas,

There are a few ways to do this:

  1. When the user logs in/creates profile, capture their nationality. Then filter all lists based on this and any country the select.

  2. You can have the user select nationality and country in drop downs, then filter based on those selections (like below)

Let me know if you have any other questions.

Erik