Import relational data into Quick Base
How can I import related data from excel into 2 tables in Quick Base and then join them using a key? I tried creating primary and foreign keys in excel
Forum Discussion
If the primary and foreign keys are already a part of the data in excel, then it is just a matter of making those fields the Key Field in Quick Base.
If you want to use the default primary keys created in Quick Base (Record ID#), then you need to upload the parent records first, export them back to excel to get the Record ID#, then use a vlookup to pull the record ID # from the parent record into the child table data.
If you want to use the default primary keys created in Quick Base (Record ID#), then you need to upload the parent records first, export them back to excel to get the Record ID#, then use a vlookup to pull the record ID # from the parent record into the child table data.