Name – Is a primary field, required by Airtable, there is no suffix in it because it is non-unique for all 3 tables.Just make sure that the destination columns order is the same as in the table from which you copied your data.Īfter all the steps above you will produce something close to the table in the picture below: Use this to copy and paste data in blocks, not just column by column. HINT: you can hide columns and change their order by drag-n-dropping them. Step 4 – Copy the data from your old tables into the corresponding columns in the new table. *It might not make a whole lot of sense at this point why we’re creating suffixes but you’ll understand what this actually looks like and WHY we do it in just a moment, so read on! (Pr) – for unique fields from ‘Partners’ table.(CX) – for unique fields from ‘Customers’ table.(Team) – for unique fields from ‘Team’ table.In our case we used the following naming convention: The reason we do this is because we’ll need these suffixes later to build Views in our new table. When you add them, you will need to append a suffix after the name of the field to help you identify unique fields for each table that will be included into the consolidated table. Step 3 – Add these fields to your new table. NOTE: When you link a column in the table to another table, Airtable automatically creates a reciprocal linked record in the source table as well! (A great way to remember this is that linked records are a 2-way street both tables have to link to each other, you can’t have one without the other!) Step 2 – Create a list of all of the fields in the tables from which you will be transferring data to your new, single table. To reiterate, the reason we named our new, single table ‘People’, is because all of the entities in the three separate tables we used to have-Partners, Customers, Team Members-are in fact all just different types of people. Step 1 – Create the new table to which you’ll be transferring your data from the multiple other tables where it’s currently stored. #Airtable change primary field free
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |