Skip to main content

This one is a little convoluted and I can’t figure out where I’ve gone wrong. I have three tables - course list, participant list, and course completion status. I set up an automation so that when a participant is added to the linked field in course list, or a course is added to the linked field in the participants table, it creates a record in course completion with that information.

What is happening is that the new record will do one of three things: it will link to the correct record in the course list, it will link to a different record in the course list, or it will create a new record in the course list. I actually need to make some changes to accommodate users who get future enrollments, but I want to get this working first.

Here is the automation setup:

When record enters a view in Participants table, create record in Course Completion Status table. The view is set to show only records in the Participants table where the Courses field is not empty.

And the action settings:

Course Completion Status table, fields: participants linked field with Airtable record ID selected, Course linked field with courses record selected.

Here is what it looks like from the various tables:

Partipcant table
Course List table
Course Completion table

ETA: what I want it to do is if I add a participant to the AI course 1 it will create a record in course completion linking it to the course 1, not course 2. The participants table has linked record fields to both course list and course completion. course list table has linked fields to participants and course completion. course completion table has linked fields to participants and course list. They all are linked together so I’m not sure why it’s misinterpreting or how it’s even grabbing something else.

Any insight would be appreciated.

Hm, your automation setup looks fine.  Could you private message me a link to your base so I can review the revision history for you? 

---

I think the bigger problem is that when a new Course gets added to a Participant you want it to create a new record in ‘Course Completion Status’ for that new Course only which is kind of tricky to do.  Your current automation will only trigger once as, after the first Course has been added the automation won’t trigger again

To solve this, you could try:

  1. Create another linked field between Participants and Courses called ‘Course to add’ or something
  2. Get your automation to trigger off of this new field instead
  3. In this new automation, the actions would be to:
    1. Create a new record in the Course Completion Status table with this new Course
    2. Clear the ‘Course to add' field so that when you add a new course in the future the automation will trigger again
    3. Add the newly added Course to the ‘Course’ field 
      1. i.e. If the previous value was ‘Course 1’, it would now be ‘Course 1, Course 2’

You could also solve this via scripts too, and if you did that you wouldn’t need the new linked field either

Terms & ConditionsAccessibility statement