Discussions

Expand all | Collapse all

Query Record ID from Parent Table and add its Record ID to a Connected Table

  • 1.  Query Record ID from Parent Table and add its Record ID to a Connected Table

    Posted 07-26-2018 17:09
    I have a connected table that pulls 15,000 records from a csv in a shared Google Drive folder. I have a parent table that has the physical location of all these records. I need to relate the records to their location, but because it is a connected table, I cant do a VLOOKUP and reimport the data. 

    Is it possible to do a webhook that says something like:

    When a record is added, take the [Child Location] and query the parent table for the same location then add the [Record ID] for that location to the [Child Reference Field]

    Thanks


  • 2.  RE: Query Record ID from Parent Table and add its Record ID to a Connected Table

    Posted 07-27-2018 15:29
    Brian,

    Without looking at your app, it sounds like what you need to do is to set the relationship key on the connected table to match with the key field on your parent table. That way, when the import happens, everything will already be related.

    Hope that helps!

    Best,

    -Matt