# How to club all entries with the same name and view as one via Airtable

**URL:** https://community.thunkable.com/t/how-to-club-all-entries-with-the-same-name-and-view-as-one-via-airtable/2170811
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [December 8, 2022, 9:38am UTC](https://community.thunkable.com/t/how-to-club-all-entries-with-the-same-name-and-view-as-one-via-airtable/2170811 "2022-12-08T09:38:27Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [December 8, 2022, 9:38am UTC](https://community.thunkable.com/t/how-to-club-all-entries-with-the-same-name-and-view-as-one-via-airtable/2170811/1 "2022-12-08T09:38:27Z")

</div>

Dear All,

Item details get stored into the Airtable via firebase id i.e

I am trying to list all the entries made by one user(firebaseid) and view as consolidated data.

Ex like the below screen shot:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/8/6892225780d4c8089e55d6c5addec1dd6cb00217.png)

Sharing the airtable view

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/f/4f6daa8a5887cf270fd40b44061e1e0fd4128e10.png)

Sharing the blocks:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/3/b3c08c544f995748da6283d64decd1c98ca50233.png)

also the output

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/7/579af5f2087201934066185f668b935a343908ef.png)

Hope I made it clear. Could you kindly assist?

Regards,  
Sasi Preetha

---

<div class="post-metadata">

### Author: ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)
#### Post date: [December 8, 2022, 2:09pm UTC](https://community.thunkable.com/t/how-to-club-all-entries-with-the-same-name-and-view-as-one-via-airtable/2170811/2 "2022-12-08T14:09:11Z")

</div>

> [@sasi.preethag3yh](#):
>
> Item details get stored into the Airtable via firebase id i.e

This is probably in inaccurate. And thinking like this may be a bit confusing. Currently are using fire base is your user authentication method. Firebase returns a user ID. You’re storing data in airtable and using the user ID is one of the values in that record to function as a unique identifier for that user

> [@sasi.preethag3yh](#):
>
> Could you kindly assist?

There’s two ways to do this one of which being more appropriate than the other. You should use the airtable API and filter by the user ID in that column. This would return only the relevant information and you would not need to filter out data client side. Work like this should be done server-side, period.

That said, you need to loop over the data. That’s being returned by airtable in a 4 each loop and within that loop you need an if/then statement that says `if this rows user ID equals the current users ID then throw it into a second list`. After you’ve gone through that entire for each loop you can then display only the list of relevant information but be aware that you were downloading everybody’s information which is probably a little excessive at times. You won’t feel any issues on small data sets but once you get into larger data sets you will .

---

<div class="post-metadata">

### Author: ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [December 8, 2022, 2:15pm UTC](https://community.thunkable.com/t/how-to-club-all-entries-with-the-same-name-and-view-as-one-via-airtable/2170811/3 "2022-12-08T14:15:03Z")

</div>

Thank you for your response Jared. Much Appreciated.

Currently are using fire base is your user authentication method - Yes Jared?. Firebase returns a user ID. You’re storing data in airtable and using the user ID is one of the values in that record to function as a unique identifier for that user- Yes

I am exploring Airtable API using filter.

But here you know Admin will get to see all the order received from the user not only the current user. Any suggestion?

---

<div class="post-metadata">

### Author: ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)
#### Post date: [December 9, 2022, 3:07am UTC](https://community.thunkable.com/t/how-to-club-all-entries-with-the-same-name-and-view-as-one-via-airtable/2170811/4 "2022-12-09T03:07:24Z")

</div>

using Airtable API - filterByformula I am able to get the details as per the current user ,

Sharing the blocks.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/c/4cb8118df3be4ee714d7bf7e34635e98308e46c3.png)

As I want to see all the user relevant details via firebase id, what I have done now is pulled the record i.e firebase id alone from user profile table and made it displayed in the list viewer and from the listviewer selected item get passed into the filterByformula but I get an error as undefined.

Sharing the block

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/8/5838ad9ad08d3e5505a74647f27fd17f928550fa.png)

Could you kindly assist?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [March 9, 2023, 3:08am UTC](https://community.thunkable.com/t/how-to-club-all-entries-with-the-same-name-and-view-as-one-via-airtable/2170811/5 "2023-03-09T03:08:07Z")

</div>

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