Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Pulling data from 2 tables into a single export

Topic Labels: ImportingExporting
349 2
Showing results for 
Search instead for 
Did you mean: 

I have 2 tables:

  • Organisations - which contains fields related to organisations we have funded to run projects - each record includes the organisation’s postcode
  • Projects - which contains fields related to projects run by these organisations.

The 2 tables are linked -a project links to one org and an org can link to multiple projects.

I want to export the project table to csv to create a map of the projects but I need the postcode to be exported too and it’s in the other table. Can I do this? I currently only get the organisation’s name in the csv file as it’s the primary field of the org table. Thanks!

2 Replies 2

Hi @Rosy_Carter and welcome to the community!

Did you try using lookup fields?

Hi thanks for your reply. I have added the Postcode field using the lookup field type and it works perfectly!