I’m building a database for a local school.
I have two parent tables (Students & Classes). I am trying to add multiple students to individual classes, however I’m having to do this individually per student, is there a way to either copy and paste or bring in multiple students at a time to individual classes?
Students full name is is the primary column in student table & uses a concatenation formula and class name is primary in class table also using a formula.
Thank you.
You can copy and paste a comma-separated list into a linked record field and Airtable will link to existing matching records and create new records for non-matching items. Otherwise, if you have multiple students all in the same classes, you can copy and paste the linked record field cell. Note that this will overwrite the destination cell (so any students not in the origin cell will be lost).
You may prefer to copy a full list of students between classes and then unlink students not in the class. Unfortunately there's no way to add multiple records at once, but you can see all the linked records at a glance and if you work from the bottom up, unlinking records should be straightforward (their position on screen won't change).
Thank you very much for your reply! I believe I came up with a solution to my issue that is similar to your second paragraph.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.