Help needed; how to retrieve record from repeater list

Hi there,

I have searched for 2 days now, without finding an answer to my question. Thus I come to you for help.

I need help retrieving data from my repeater list. I can acces my text just fine, but i dont know how to acces the list of texts (nested data).
This is my first base, which holds Items:

{
    "records": [
        {
            "id": "recaS9FihmRBztkEB",
            "fields": {
                "Drawer": [
                    "recHYyn4v9egqtH39"
                ],
                "Group": "Overig",
                "Closet": [
                    "reckQOcPU1Z4Lhi88"
                ],
                "Name": "Adenosine",
                "Location": [
                    "recT0G9SD3wdneSCA"
                ]
            },
            "createdTime": "2022-03-14T15:00:57.000Z"
        },
        {
            "id": "rec3MKY86zAU7jo9j",
            "fields": {
                "Drawer": [
                    "recHYyn4v9egqtH39"
                ],
                "Group": "Medication",
                "Closet": [
                    "reckQOcPU1Z4Lhi88"
                ],
                "Name": "Atropine",
                "Location": [
                    "recT0G9SD3wdneSCA"
                ]
            },
            "createdTime": "2022-03-14T13:20:37.000Z"
        },
        {
            "id": "recbvKOasNUUDC5k9",
            "fields": {
                "Drawer": [
                    "recb2j2OxAPDkEXSl"
                ],
                "Group": "Overig",
                "Closet": [
                    "recrxmzYBMaAeXDvo"
                ],
                "Name": "Atropine",
                "Location": [
                    "recNIhMNYmA3XFhW0"
                ]
            },
            "createdTime": "2022-03-14T15:36:34.000Z"
        }
    ],
    "offset": "itrUJ7Ixpekwhnxmi/recbvKOasNUUDC5k9"
}

I can acces the “Name” just fine, which builds the list. However, I want to add the “Location” as secondary label. I cant however, because its a list of texts.

On top of that, the location entry is an id, which needs to be lookup up from my other base (which holds a list of locations).

{
    "records": [
        {
            "id": "recT0G9SD3wdneSCA",
            "fields": {
                "Name": "Berging 2e etage",
                "Items": [
                    "recaS9FihmRBztkEB",
                    "rec3MKY86zAU7jo9j",
                    "recnoIMawwkq2Ewj6",
                    "recibo5FlRo6WZ4Ot",
                    "recDwLTcPEvs7ycUd"
                ]
            },
            "createdTime": "2022-03-14T14:13:00.000Z"
        },
        {
            "id": "recNIhMNYmA3XFhW0",
            "fields": {
                "Name": "Berging 1e etage",
                "Items": [
                    "recbvKOasNUUDC5k9"
                ]
            },
            "createdTime": "2022-03-14T14:13:00.000Z"
        },
        {
            "id": "recstZh76JRMOHeA1",
            "fields": {},
            "createdTime": "2022-03-14T14:13:00.000Z"
        }
    ],
    "offset": "itrUJ7Ixpekwhnxmi/recstZh76JRMOHeA1"
}

Which formulas do I need to get an accurate result for each item in the list?

Thank you for your time!

Hi! For objects such as fields, use LOOKUP. For lists (arrays) it depends what you want to get out of it – you can go just Items[0] for example, or use FIND or JOIN if that’s more to what you need.