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.
Now hide all the fields except Name and Joined
Copy and paste your 2nd table into Airtable
Unhide all fields
Then, sort by Name. You will be able to see your duplicate Student names. You can then go through and manually tag all the appropriate selections.
IF your Joined data is per ongoing ‘events’ like daily attendance, create a second table and turn that Joined field into a Linked Record field type.