I have records that look something like this in Employee table.
“records”: [
{
“id”: “recxPbyRYLea1Y3u7”,
“fields”: {
“Name”: “Jane Doe”,
“ID”: 1,
“Roles”: [
“rec93YegEkI0lLKi0”,
“recgUgOR7mEk9SYDm”
],
…
}
}
]
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
Thanks