How to link fields from different columns?

Hi @Ethan_Suero, in this case it would be easier if cities were stored in a separate table, in which you specify the corresponding id for each city. You then just link the city and you can use a lookup field for the id if you want to display the id in your main table.

Best,
Rupert

Hi @Rupert_Hoffschmidt ,

So essentially I need to create databases for each of these fields with IDs and then link these to the main spreadsheet, is that right?

Is there a tutorial that explains how to do this?

Thank you

Hi @Ethan_Suero ,

You need to create a separate table (not a separate base) that contains a list of your cities and ID’s. (Although you could create a separate base and then sync to your existing base.)

After that, you would create a linked record field in your original table that links to the city in your new table, and then a lookup field that brings in the ID.

You would likely greatly benefit from my free Airtable training course, which covers linked record fields & lookup fields in significant depth:

Hi @ScottWorld ,

Will definitely take a look, thank you!

I guess a separate base would work better as each base will have up to 5k entries on a Plus plan, is that right?

Thanks again

No, you wouldn’t be able to use separate bases to workaround the 5k limit, because whenever you sync records from one base to another base, those records count towards your limit in both bases.

So, if you’re on a Plus Plan and you have more than 5,000 cities (although you would actually need less than 5,000 cities because you’ll want records in other tables as well), then you will need to upgrade to the Pro Plan.