Discussions

 View Only
  • 1.  Import into 2 tables at once

    Posted 10-29-2019 10:29
    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
    ------------------------------


  • 2.  RE: Import into 2 tables at once

    Posted 10-29-2019 10:48
    Edited by Adam Keever 10-29-2019 11:05
    Why do you need two tables?

    ------------------------------
    Adam Keever
    ------------------------------



  • 3.  RE: Import into 2 tables at once

    Posted 10-29-2019 23:47
    Post company name into contacts table as well and then setup a relationship between company and contact table using company name.

    ------------------------------
    Babi Panjikar
    ------------------------------



  • 4.  RE: Import into 2 tables at once

    Posted 11-08-2019 11:09
    Edited by Justin Lapier 11-09-2019 22:44

    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.
    ------------------------------



  • 5.  RE: Import into 2 tables at once

    Posted 11-10-2019 18:03
    Edited by Keith Jusas 11-10-2019 21:21
    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
    ------------------------------



  • 6.  RE: Import into 2 tables at once

    Posted 11-10-2019 22:05
    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
    ------------------------------



  • 7.  RE: Import into 2 tables at once

    Posted 11-12-2019 12:16
    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
    ------------------------------



  • 8.  RE: Import into 2 tables at once

    Posted 11-12-2019 13:15
    Edited by Juiced Technologies 11-12-2019 13:33
    Thank you for that feedback Mark!

    ------------------------------
    Keith
    ------------------------------