Forum Discussion

JohnRokoczy's avatar
JohnRokoczy
Qrew Member
5 years ago

How to import MULTIPLE tables beyond the intitial one

I'm testing QB, and can't believe I can only import one table when I create an app.... that is unfathomable.  And before anyone says, "Yes, but you can 'connect' to a CSV file or build it from scratch...
Data import and export
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
np,
Once an app exists you can create an additional table with no fields.  Then import an excel or csv file.  Quick Base will offer to auto create the missing fields for you with the same names as the column headings on hour import and take a guess at the field types.  Just correct any mis-guesses about the field types and import.  You will then have both data and the fields to hold the data.

You can do this as many times as you like to create successive additional tables by importing data.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
JohnRokoczy's avatar
JohnRokoczy
Qrew Member
5 years ago

Thanks Mark! 

 

The "import" function was definitely hidden... it should be a plainly-stated 3rd option alongside "build from scratch" and "connect"...

 

Now that I have the 2 tables, I was able to establish a relationship between the 2 but there's no clear way to tell it what the primary and foreign keys are.  Is there a secret way to establish and define what fields in the child table are related to the parent?

 

John

 



  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    np, when you look at the field list, there is a gold Key that indicated the Key field.  In Quick Base each table may have have a single Key field.  

    When you make a relationship, you can either allow Quick Base to create a field to join he tables (the foreign Key) or you can select one of the fields that you imported.   A reference field (what you call a foreign key) may also be a formula field.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------