Using Count on Linked Fields between bases

[Max_Ruddock]

Hi all,

New user to AirTable here.

I have a base set up that shows my users etc and a linked field that enables me to select a course for those users from another base. This all works fine.

In the base where all my courses are stored I wish to add a count field to show how many users have a specific course assigned to them - however I can’t seem to get this to work.

Hopefully the screenshots attached help. The first base has a column called ‘from delivery plan’ which is where I select the course from another base. The second screenshot is the second base with all the courses listed - I’d like to have a column which shows how many users have been assigned this course.

Thanks in advance :slightly_smiling_face:

[TheTimeSavingCo]

Hi Max, could I get a screenshot of the Courses base that includes the linked field to the first bvase, as well as a screenshot of the Number of participants field setup please?

From the screenshots you’ve included everything seems fine

[Max_Ruddock]

Hi Adam,

Here is the delivery plan in its own base (Base 2). Here courses (entries) are specified with a course code.

Here are the participants in their base (Base 1). The ‘from delivery plan’ field is set as a linked field to the delivery plan (Base 2) - so a user can select a course from Base 2 to apply to this record.

Here is what that looks like:

This is what my count field in the delivery plan (Base 2) currently looks like. I’d like it to count how many participants from Base 1 have that record selected (i.e. number of participants on that course):

FYI, both bases currently have 1 table - and then I have synced the table from each base into the other.

Thanks in advance!

[TheTimeSavingCo]

Ah I see, so in the Enrolment Leads table, you’re linking it to a record from the synced view Delivery Plan (Shared)?

If so, I think you’d need to create a count field inside Delivery Plan (Shared) and then create another synced view in the base that contains your original Delivery Plan table and sync Delivery Plan (Shared) back over or something

(Might be wrong though, thinking about this made my head hurt)

The other option would be to use a script to update each table I guess

---

This would be a lot simpler if the Delivery Plan and Enrolment Leads table were in the same base, and I’m curious what business need requires you to separate the two out like this?