Airtable query pls help

Discuss
#1

Suppose in airtable i store
Customer id
Name
Mobile
Address

Now when user open app all its data should be shown According to his customer id in cardview
All data means if there are 25 rows with that customer id… All the data in that will show

#2

use colin tree list view and set it inside card view, there are tutorials on youtube for colin tree list view usage with airtable

#3

I already seen it.
But i want to show data according to customer id…
Of all rows data

#4

try to make something first, if you stuck somewhere we will help, let me suggest you something

use firebase to store customer id as a bucket and all its data under tags, so when you want data for a customer set project bucket to customer id and call data

#5

You can create different Tables for different Customer Id and call Airtable Table Name as Customer Id and then when a customer open the app with his id then he/she can see only his/her data.

#6

You can do that in this way:
In airtable
Sort all rows according to customer id in ascending or descending order.

In app
Just get all rows or column.As it is already sorted you do not have to anything.

Or
Use list utils extension to sort list.

#7

I want to use only airtable… And u r not understanding my query…
Suppose there are 50 records with samne customer id then all records should be shown…

#8

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

#9

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.

#10

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

#11

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
#12

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

#13

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

#14

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:

#15

Fine.
I have to say once again

after that I can help you.

#16

IMG_20190714_131022
IMG_20190714_131022.jpg4160×3120 2.89 MB

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

#17

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…

#18

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

#19

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.

#20

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