Forum Discussion

ChrisBaker2's avatar
ChrisBaker2
Qrew Member
2 years ago

How to add both parent and relatled child records from one excel file import from parent table?

When I need to create a new parent record I also need to import hundreds of child records. Currently I am creating the parent record from quickbase manually, taking its created id and adding it to th...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
2 years ago

Depending on the makeup of your parent record you could approach this with Pipelines. If you can load the file as CSV to Box or somewhere that Pipelines can access you can create the parent record and then load the actual file as the children using the prior step. The assumption there is that you have sufficient info to make the parent



------------------------------
Chayce Duncan
------------------------------
  • AdamKrzyzanek's avatar
    AdamKrzyzanek
    Qrew Captain
    2 years ago

    I remember I saw it on one from Empower video but not sure which (2021, 2022 or 2023).

    Over there was described how to build Excel file to load 1 set of data to "Staging" table and later pipeline was distributing it to Parent and Child table.

    Here links to recordings but not sure which🤔
    Empower-2021
    Empower-2022
    Empower 2023



    ------------------------------
    Adam Krzyzanek
    ------------------------------