filterByFormula that is linked from other Table


I have records that look something like this in Employee table.

“records”: [
“id”: “recxPbyRYLea1Y3u7”,
“fields”: {
“Name”: “Jane Doe”,
“ID”: 1,
“Roles”: [


As you can see Roles link to other Table, so what I wanted to achieve is that filter Employee data including data that is linked from another table in this case Role.

e.g. I wanted to show all Employee with Roles Id of ‘rec93YegEkI0lLKi0’ using ‘filterByFormula’.

I’m using CURL PHP



I had the same problem, in NodeJS but i bet it is the same.
I had a Reserves table that was something like
User: 402123 (this is their id)
ReserveStart: June20,

The user was a linked record from the Users table. I just had to use their ID, not the hash code (402123 rather than “rec93YegEkI0lLKi0”
function (userID) {
return new Promise(function (response, reject) {
maxRecords: 1,
filterByFormula: “AND({User}=’” + userID + “’,TRUE())”,
sort:[{field: “ID”, direction: “desc”}],
view: “Grid view”
function page(records, fetchNextPage) {
records.forEach(function (record) {
}, function done(err) {
if (err) { console.error(“error finding reserve”+ err); return false; }