Help

FILTER BY ARRAY OF IDs

Topic Labels: Sync
1722 3
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Tanko
4 - Data Explorer
4 - Data Explorer

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

3 Replies 3

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
4 - Data Explorer
4 - Data Explorer

@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

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