Nickname comapre New Users' and alredy saved nicknames in Airtable DB

[jumalcom222]

How do I create the function to see if there is something like the Nickname of New User(in Text field) and others have already saved in Airtable DB?

[tatiang]

You can loop through the rows of an Airtable column and compare values or you can use the Airtable API to filterbyformula. It’s complicated but very powerful.

[jumalcom222]

I want to know/see code block

[tatiang]

Does the link I shared here help?

I want to search in DataSources and get the column ID

Here’s a demo of how to do this: https://x.thunkable.com/copy/c05336660d538ffec6e818808a64ed92 (See the screen with your username.) You should never have a join block connected as a row id. Row IDs are either integers or they are long text strings like “H@#7d9E0&n3kL2!m”. You either use a whole number or you look up the ID itself using the list of values block: [image]