Query for unique items in Airtable

[Mesut_ADIYAMAN]

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.

[dora_paz (Dora)]

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

[Still-learning (1-2-3-4...)]

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

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

[Mesut_ADIYAMAN]

Thank you. I will try now.

[dora_paz (Dora)]

@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

[Still-learning (1-2-3-4...)]

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

[Mesut_ADIYAMAN]

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

Screen1 and Screen2

airquery .aia (4.8 KB)

[dora_paz (Dora)]

Change Table Name from list to Table 1

airquery_1.aia (5.1 KB)

[Mesut_ADIYAMAN]

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

[Kevinkun]

[FREE] KevinkunAirtable extension

V2 Update 2020/12/24 fix bug of “can not update value with space”, now in the formula, use " and " to quote the value with space. add perperty of FetchIdAndTime. if set to true, in the SelectFinished event you will get ‘id’ and ‘createdTime’ for each record. [2020-12-24_200204] add method ‘UpdateById’ and ‘DeleteById’ for update or delete one record, which is faster than by filter.[2020-12-24_200214] v1: Write a short description Why another extension about Airtable?Because this one is di…

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

[Mesut_ADIYAMAN]

Good working thank you for helping.

[Still-learning (1-2-3-4...)]

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