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

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • Acknowledged
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]

Photo of Brian Wade

Brian Wade

  • 70 Points

Posted 12 months ago

  • 0
  • 1
Photo of Matt Saforrian

Matt Saforrian, Employee

  • 452 Points 250 badge 2x thumb

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!