Skip to main content
← Data, API & Backend
Data, API & Backend July 1, 2022 · 2 replies

Getting a nested friend list from Airtable

Archived from the Bravo community forum (2021–2026). Some answers may refer to older versions of Bravo.

Im having trouble displaying Table binding data from a users list which have user.id (from firebase), username and friends connected field which shows friends of each users

Slika zaslona 2022-07-01 u 19.08.15.png

I want to filter that list by user.id and show only authenticated user (the one thats using the app) his friends list.

This is the end of my filter by formula request in Get the list.

?filterbyFormula=search("${user.id**_}",%2Carrayjoin(userid))

**The problem is Im getting all the friends from all the users, and Friends field is not a list, a but a string separated by **","

This is my request data:_**

Slika zaslona 2022-07-01 u 19.14.43.png

Slika zaslona 2022-07-01 u 19.14.30.png

2 replies

Valter July 1, 2022

Try the filterbyFormula like this:
{userid (from Friends)} = '${
user.id}'
But in the oposit way. Making the userid from the main friend appear on the line of the (from friends) and use the same type of formula but now adapted to the new row name.

Branimir July 1, 2022

Ok so if understand correctly, my filter by formula would look like this:

?filterbyFormula=search("{userid (from Friends)} = '${user.id}",%2Carrayjoin(userid))

Wrote something in this thread and want it removed? Request removal

Still stuck?

Ask the community on Discord

This archive is read-only. New questions, office hours and product updates now happen in the Bravo Discord.

Join the Discord