Airtable query pls help

Suppose in your user app your cust. Id is 1234
Then there should be data of only your customer id

It is quite hard to do with Airtable because you have to do something like this:

  • Get all customer Id
  • Check for a particular I’d
  • Now get all rows which have that particular Id

And it is impossible with firebase because you can not add new value with an existing tag.
This is very easy to do with MySql.
You have to run a query like this-
Select *from database name where customer Id=id
And it will get a CSV table text with all users having that id.

But now i had already set up with airtable… Pls help me out with some blocks

No,not at all directly.
First you have to show what you have tried.
Maybe others can help directly by giving you blocks or aia file.

1 Like

I had made block to call column customer id but how to check for particular id

I am sure this one is going to help you:sweat_smile:

This only search function… I get customer id column… Why u didnt tell me how to check for particular id and display all data​:rage::rage::rage:

Fine.
I have to say once again

after that I can help you.

See i just try this… Here i dont know how to check for particular id and display all

this is what you have tried…??? is this a joke… you just added only 3 blocks, now you saying that the logic not working…

use if condition to check the customer id you need to display data, if customer id found then add data to list item and then show that list data in card view or colin tree list view…

That i didn’t know where to use if condition… Pls help me with some block… I m here to get help…

looks like you joined kodular recently, so i think you didnt have the concepts of how to make apps properly, so i suggest you to start from basic apps, then move to complex login part…

and dont expect a complete answer, the answer you need is mentioned above in my comment. use that logic inside **got column ** block. now go try and come again with the updated blocks. then i will help you.

This will list all your customer ID.
Now you can find the Row Number of that particular ID from the values list [Use Index in list block to do that]
And now you can get that row you want.
Hope this is what you were finding

Noo,
U r not understanding my issue​:grimacing::grimacing:
Suppose there are many rows containing same customer id then how to show data seperately

Customer ID Food Price
3424 cake 50
5774 pizza 500
3424 pepsi 60
3424 cream 100

Now how to show data seperately for id 3424

He joined Kodular on March 21.
But the problem is that he has just 7 hours read time and this is not enough to understand blocks.
Or he is pretending to get blocks ( this is just a doubt ).

I know everything ok… But there are some issue that i didnt know… I ask here and u ppls say try himself…
If i know why i m askin here?
Gussa dilate ho baar baar

I am sure that you have not read @techcvr guide because if you had then you have find some blocks posted by me.
I am talking about this one:

1 Like

This is different form my issue… Why u cant tell me logic how to check for ids

And if there are 50 rows with that id how to show each data in seperate list

May be this can help:

Where is checking for customer id here