Issue Linking Tables

[jpduchesneau]

Hi everyone,

I’m facing an issue with counting linked records in Airtable, and I’d love your help!

I’ve created two tables for managing group interviews:

1. “Entrevues Dispo” (Interview Slots) – Tracks the availability of each interview slot.

2. “Entrevues Inscriptions” (Interview Registrations) – Stores candidate registrations linked to the available slots.

In the Entrevues Dispo table, I have a linked field called “Entrevues confirmées” (Confirmed Interviews), which pulls all the candidates linked to a specific interview slot. The relationship works, and I can see the correct linked records.

The Problem:

I’m trying to calculate the number of candidates per slot using COUNTA({Entrevues confirmées}). However, it only counts 1 record, even though there are multiple linked records (e.g., 2 or 3 candidates).

I also tested with a Rollup field using ARRAYJOIN() and confirmed that all linked records appear correctly (e.g., emails of all candidates). Despite this, the COUNTA() formula doesn’t return the correct count of linked records.

What I’ve Tried:

1. Re-creating the linked field and re-linking the records.

2. Using a Rollup field with ARRAYJOIN() to debug the links (they seem correct).

I attached the screenshots.

Help needed:

I’d like to accurately count the number of linked records for each slot in the Entrevues Dispo table to calculate the remaining availability (e.g., Total Slots - Confirmed Registrations).

Has anyone encountered a similar issue, or does anyone know how to fix this? I’d appreciate any advice or suggestions!

[TheTimeSavingCo · Accepted solution]

Hmm, may i know what issues you faced using a 'COUNT' type field for this?  You can also try using the formula field on a rollup field if you'd like:

Link to base

I don't think you can use the 'COUNT' formula on a linked field like that I'm afraid

[jpduchesneau]

Thanks a lot Adam. Your simple solution of using a Count column was just what I needed. I'm still learning all of the Airtable options and something there's something that is really more obvious! Thanks again for your help!