FILTER BY ARRAY OF IDs

[John_Tanko]

I have a parent table and a child table.
The parent table return ids of the child table.

I will like to be able with the array of IDs fetch all the data in the child table

Thank you

[TheTimeSavingCo]

Hi John, what issues are you facing when using a Lookup field for this? Lookup fields seem perfect for this situation.

If you could post a screenshot of your base, or a link to it, I would be able to provide more assistance

[John_Tanko]

@Adam_TheTimeSavingCo Unfortunately I ony have read access but this is a sample of what am try work on:

{
“id”: “rec2bBA5X2PKMcAGN”,
“createdTime”: “2021-08-11T15:31:32.000Z”,
“fields”: {
“Name”: “Joe”,
“Classes”: [
“recr0DOF3YWjN9wAH”,
“recwrHZ9zBIYFiU07”,
“rectGHWsZVmkeRwGh”
]
}
},

I want to be able to use filters and class array above to retrieve class list below

"records": [
    {
        "id": "rectGHWsZVmkeRwGh",
        "createdTime": "2021-08-11T15:31:14.000Z",
        "fields": {
            "Students": [
                "recoQBxwU83QJq69L",
                "recDImTGoac20jjl6",
                "rec7JYre5lzaHXTTu",
                "recriGJ89PRdUMaI0",
                "rec2bBA5X2PKMcAGN",
                "recRZ8XD5vg7N7JRj",
                "recSePppFodYpFy0l"
            ],
            "Name": "CS 101"
        }
    },
    {
        "id": "recwrHZ9zBIYFiU07",
        "createdTime": "2021-08-11T15:31:14.000Z",
        "fields": {
            "Students": [
                "rec2bBA5X2PKMcAGN",
                "rec7JYre5lzaHXTTu",
                "recoQBxwU83QJq69L"
            ],
            "Name": "CS 102"
        }
    },
    {
        "id": "recr0DOF3YWjN9wAH",
        "createdTime": "2021-08-11T15:31:14.000Z",
        "fields": {
            "Students": [
                "rec2bBA5X2PKMcAGN",
                "recoQBxwU83QJq69L",
                "recSePppFodYpFy0l"
            ],
            "Name": "CS 103"
        }
    }
],

Thanks

[TheTimeSavingCo]

Ah hm, I’m still not entirely sure what you’re trying to do honestly. Here’s some code that let’s you get the linked cell values and to look through the next table

To help further I need examples of exactly how the data looks and how you want the end result to be