Firebase authentication with multiple data recording error in Airtable

[ABDILAHI_KHAMIS (ABDILAHI RASHID KHAMIS)]

Hello, sorry for this topic.
I have error after doing firebase authentication. I want to call emails list from airtable and if the user founds from airtable the new raw should not be created and the app should open another screen and if the user not presents a new raw should be created than app should open another screen after creating a raw. But problem is that the new raw created even the user is found in airtable and every number user inscrease it create a multiple or many raws of same user.
My blocks are the following.

And this appears in my airtable

Sorry for hiding some users because they are real users of my app.

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

try like this

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

instead of using compare text field, try like this,

[ABDILAHI_KHAMIS (ABDILAHI RASHID KHAMIS)]

Thanks you but the problem did not solved.
my blocks now appear as

But still not solved

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

When spreadsheet got c block Pls use the block that is in the list and try. If it exists divert the app to open another screen if not make it to create a row and then divert to open another screen

[ABDILAHI_KHAMIS (ABDILAHI RASHID KHAMIS)]

I have try both this

AND

but still the error did not solved

[ABDILAHI_KHAMIS (ABDILAHI RASHID KHAMIS)]

how I don’t understand you

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

try this block… It will work

[ABDILAHI_KHAMIS (ABDILAHI RASHID KHAMIS)]

I have try that but no raw created in airtable if user not found

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

It works for me with no issue…

[iamwsumit (Sumit Kumar)]

@ABDILAHI_KHAMIS your block are wrong for checking user email already exists or not
The problem are here

Here you have already put the data in Global email then why are you using values variable
And the main problem is that you are using for each no loop for checking email existence and also @Still-learning using loop for that I couldn’t understand why? that’s why the row is creating again and again

[ABDILAHI_KHAMIS (ABDILAHI RASHID KHAMIS)]

Thanks, so if was you how will you arrange this blocks?

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

He is using that loop to find the matching number, but instead why dont you try like this… i dint think this simple one…

Update:
Airtable get column is not working it seems. Only get all row shows data… Exsiting project is also not showing the data properly. Dont know the reason. I tested with very simple block to call particular column(api, base, table name are correct) but not showing data.

[ABDILAHI_KHAMIS (ABDILAHI RASHID KHAMIS)]

Thank you and I am so sorry It work perfectly. The error was my mistake I was now arrange properly the create raw block thanks very much it work