Query for unique items in Airtable

Hello to everyone,

I’m in the community but couldn’t find a solution. I would like it to query for unique items on the list and prompt yes or no, I would love it if you could help me.

Try something like this , when no entry - No data found, unique item - Yes, else No

If you want only true or false mean you can try this too


Sorry, this will check whether the text box name is present in the airtable or not. Sorry for that

Thank you. I will try now.

@Still-learning above code will only return that given name is stored in airtable or not but won’t query if given name is unique or not

Oh… What happened to me? i though he want to check whether the input name is present in the list or not it seems…

1 Like

Hello I tried both ways but neither of them happened. Can you look at my blocks?

Screen1 and Screen2

airquery .aia (4.8 KB)

Change Table Name from list to Table 1

airquery_1.aia (5.1 KB)

1 Like

Thank you very much for your with devotion helping. Its ok

Use this extension, SELECT block, set filter as name=textbox1.text,then in AFTERSELECT event check if count=1

Good working thank you for helping.

If it works, kindly mark on the reply as solution to help others in future

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.