Forum Discussion

manoharvankired's avatar
manoharvankired
Qrew Trainee
3 years ago

When importing a file into a child table in QuickBase, the parent lookup fields are not appearing in the import mapping options.

I am trying to import a file into a child table in QuickBase. After importing the data, I am unable to see the relationship between the child record and the corresponding parent record in the parent ...
Data import and export
manoharvankired's avatar
manoharvankired
Qrew Trainee
3 years ago

But it is not showing while importing



------------------------------
manohar vankireddy
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

I don't understand.  What is not showing during importing? The field for Related Country Pipeline will show.  The lookup fields cannot be populated via an import. They are lookup fields from the Parent Countries Pipeline table.



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

  • manoharvankired's avatar
    manoharvankired
    Qrew Trainee
    3 years ago

    Hi Mark,

    The related field names "Country Pipeline - Study Number" and "Country Pipeline - Country" of the parent table "Country Pipeline" are not appearing while attempting to import data into the child table "Sites Pipeline". Please refer to the attached screenshot for clarification. Can you please provide guidance on how to correct this issue?



    ------------------------------
    manohar vankireddy
    ------------------------------

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago

      The field for Related Country Pipeline will show.  That is the field that you need to populate.  The lookup fields cannot be populated via an import. They are lookup fields from the Parent Countries Pipeline table.

      Can you tell me more about the data in the Countries Pipeline table.  What does each record represent.  Is each record the name of a country?



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • manoharvankired's avatar
        manoharvankired
        Qrew Trainee
        3 years ago

        Hi Mark,

        The parent countries pipeline should have the following records:

        1. "Study Number" - a numeric value that represents the study. There can be multiple studies in the same table.
        2. "Countries" - the name of the country where the study is conducted. This can have multiple sites in the child sites pipeline table.
        3. "Sites Count" - a numerical value that represents the number of sites in the child sites pipeline table.
        4. "Issues Found" - the number of issues found in the child sites pipeline table.


        Please let me know if anything is required
        ------------------------------
        manohar vankireddy
        ------------------------------