thanks so much for your reply!
If I understand correctly you recommend consolidating the lists before uploading ot airtable?
But how could I do that in airtable? I found the option to manually link records from table 2 to the right row in table 1 - but my lists are long so Im searching for a way to automatically connect the two lists, having the name as the dependence field.
Do you might know how to do that?
Thanks so much for your help!
Yes, you can manually link everything, but best practices in Airtable means you need to have a single Students table, not duplicate tables.
If you need another table that logs each time a Student “Joined” a daily class (Attendance), then you will have 2 tables and use a linked record to the Students table to display the Student’s name. An example of this is every day, you ‘check’ that the student has attended the class.
If ‘Joined’ is a singular 1-time event, like your Student joined a civic club, then it can stay in the Students table.
My thought process on the suggestion was that you start with cleaned up data before bringing it into Airtable.
To add to Airtable:
First, create a table in Airtable labeled Students
Add all the column names from both your spreadsheet tables as Fields in the single Airtable table
Name, Country, Contact, Joined
Copy and paste your 1st spreadsheet table into the Airtable table - be sure the columns in both are in the same order.