Retrive data from Airtable. Are the data "case sensitive"?


I have a list of cities in an Airtable base and I’m trying to retrive data with a VF capture block.
Obviously all the city names start with a capital letter.

I have noticed that if the name starts with a capital letter, Airtable doesn’t retrive the data.
I wrote several names with lower case and they are properly recognized and Airtable retrives all the related data correctly.

Is it an Airtable “correct” behaviour or a bug?
What can I do to avoid to edit all the city names?

Thanks in advance for the help.

Something you might do is use a code block and convert the first letter of each word comprising the search term to uppercase, to match what is in your Airtable.

Structurally, a variable with the city name is coming out of the capture block, and it is all lowercase. For example, “london.” A city could also be multiple words, such as “new york,” and in this case there might be a failure if it is “New York” in your Airtable.

After the capture block you can add a code block. A bit of Javascript similar to this example shown in this web page can be added:

This would convert your search terms to “London” and “New York.”

Once the variable is converted, it can be used as a search term in a “filter by formula” URL to find the row with the associated data via your API call to your Airtable.

Another situation is that you might need to do encoding for the space between two words or in case there are special characters, to help make your search term more URL-friendly. This tutorial might help, if you scan through it there should be some tips on how to go about this.

1 Like

Thanks for your reply Mark.