Question

Filter by id from another table in API ?

+2

Hi,

I have this table where i would like to filter by the ID of the player.

But I strangely cannot find a way to do it.

Thanks a lot for your help,

Laurent

+31

What does your GET url look like? Here’s an example of one I just tested that works:

https://api.airtable.com/v0/appz6YcyO3dXfqDWV/tblsCy38oC7N7FE4c?maxRecords=3&filterByFormula={Users}="DEF"

Adam, Airtable Consultant - thetimesaving.company

+2

Yes but in your case DEF is not a unique ID. You just filter by text if I’m not mistaken.

for example, in my case, two people can have the same player name, this is why I need to filter by their ID, which is unique.

+31

Ah, try creating a formula field in the ‘Player’ table with ‘RECORD_ID()’, create a lookup field to display that in ‘Chat Log’, then filter by that

Adam, Airtable Consultant - thetimesaving.company

Sign up