Forum Discussion

MarkComish's avatar
MarkComish
Qrew Assistant Captain
6 years ago

Import into 2 tables at once

Our Wordpress website uses Gravity Forms and I use Zapier to bring the data into Quickbase.  The issue I am having is it is creating a Company Name (in the Companies Table) and saving Contact info (in the Contacts Table) but I can't figure out a way to relate the company to the contact automatically.  I currently have an extra field in the Contacts table that pulls in the company name and then I can manually link the related company.  Can anyone think of a way to relate this automatically with a webhook, automation, etc?

------------------------------
Mark Comish
------------------------------
Data import and export
Relationships
  • KeithJusas's avatar
    KeithJusas
    Qrew Captain
    6 years ago
    Mike,
      we may have an option for you.  Our Triggers for Quick Base add-on can be fired to search the Companies table to get the record id of the Company record and then update the Contact record to connect it properly. 

    updated...I created a sample app and a sample trigger so I can demo this quickly if you are interested.

    Let me know if you'd like to know more about this.
    Keith
    Juiced

    ------------------------------
    Keith Jusas
    ------------------------------
    • DonLarson's avatar
      DonLarson
      Qrew Elite
      6 years ago
      Mark,

      Let me vouch for Triggers from Juiced.  I have used their Search feature to get RID's out of parent tables to manage child relationships many, many times.

      Don

      ------------------------------
      Don Larson
      Paasporter
      Westlake OH
      ------------------------------
    • MarkComish's avatar
      MarkComish
      Qrew Assistant Captain
      6 years ago
      Keith you are the best!  Juiced Technology will be a company we use going forward as you were very helpful and your "Triggers" did just what I needed!

      ------------------------------
      Mark Comish
      ------------------------------
      • JuicedTechnolog's avatar
        JuicedTechnolog
        Qrew Trainee
        6 years ago
        Thank you for that feedback Mark!

        ------------------------------
        Keith
        ------------------------------
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    Why do you need two tables?

    ------------------------------
    Adam Keever
    ------------------------------
  • BabiPanjikar's avatar
    BabiPanjikar
    Qrew Assistant Captain
    6 years ago
    Post company name into contacts table as well and then setup a relationship between company and contact table using company name.

    ------------------------------
    Babi Panjikar
    ------------------------------
  • JustinLapier's avatar
    JustinLapier
    Qrew Trainee
    6 years ago

    You can do what Babi suggests, or alternatively.

    While I am not 100% familiar with Zapier's system, if it is similar to workato, here is how I would build out the recipe (workato's term):

    1. Pull data from Gravity forms.

    2. Create Company Records in QB.

    3. Query the Company Records table and extract the Record ID#'s (or other Keys).

    4. Then in your call to create the Contact record, pass the Key from #3 into the Related Company field.

    ​

    ------------------------------
    Justin Lapier 
    Synctivate Inc.
    ------------------------------