Skip to main content

How to filter the records by character in Airtable

  • October 10, 2019
  • 1 reply
  • 0 views
T

Hi I am new to airtable database. I need a help for the following problem I have a number of cities in a MetroAreas Table.In a name field contains the cities i.e; Pheonix,Denver, Detriot and etc… I would like to filter the records like if you have to enter the “D” character and search then it should shows the Denver and Detroit as well as “P” it should shows the Pheonix. I tried to get a record if user enters the complete name of the city for following query

https://api.airtable.com/v0/BASE_NAME/Metro Areas?filterByFormula=OR(LOWER({Name})=LOWER(‘Phoenix’))

How to get the records by characters or substring of the city.Please help me out of this problem.

Thanks in advance.

    1 reply

    Justin_Barrett
    Forum|alt.badge.img+5

    Welcome to the community, @Taruni_G! :grinning_face_with_big_eyes: Sorry to see that nobody has responded to this yet. :frowning:

    Is this still a problem, or have you found a solution? I can’t quite tell if you’re seeking a solution via the main application, or via the API, as your comments seem to refer to both.

    Reply


    Most helpful members this week

    Terms & Conditions