Question: Is “Fall 2021” its own table? Have you considered storing all course-instructor pairings in one table and using filtered views to differentiate “Fall 2021” from “Spring 2022”?

Regardless, if you already have a Link to another record-type field in the table you’re importing into, if the values being imported into the field that links to the Courses] table matches the primary value of an existing Course record it will link to it, if not it will create a new record in cCourses] with that name.

Hi Kamille, Fall 2021 is its own table. We would like to explore further the benefit from storing course instructor pairings in one table. The challenge is that there is a many to many relationship - many courses can be taught by many instructors so I havent been able to figure that out using a linear approach.

When I tried a test import using Link to another record, it did not work. I am wondering what I am doing wrong. Is there someway I could get some further instruction regarding this?

Can you post a screenshot of the Fall 2021 table showing the field names?

Does this help: Airtable - CSWE

Okay, so if you’re importing into the table eCSWE], the column from your CSV that you map to the Airtable field {Course} should do the linking for you on import if the imported record has a value of something like SOWK 708. Are you saying you’ve tried this and the import didn’t link to the course?

You have two different fields with (effectively) the name “course id”, you may want to examine your nomenclature. {CourseID} seems duplicative of the {Course} field and does not yield unique values, have you considered using {course id}, which seems to produce unique values and is more descriptive, as your primary field?

If you want to use that same table for courses next year instead of making a new table, you could simply add a single select field with options for “Fall 2021”, “Spring 2022” etc, and use that field to calculate the full course ID. Or use another link to a record field pointing at a table of Semesters].

That is a lot to unpack. I appreciate you replying. I will admit, it seems a little over my head, but I want to read it again and again to make sure I understand. To clarify, i did an import and the import did not link to the course so I think that is where I am going to start and see what happens.

Thanks again, I will report back with results.

The CSV you imported, does the matching column have values that match the primary column (left-most column) in your [Courses] table?