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

Question

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

mattsaforrian · Answer

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

Forum Discussion

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

Related Content

Many parent records on a single child record

Totaling Child Records Live on Parent Form

Add child record through parent form and redirect back to parent form in edit mode

Filter records based on table connection

Pipeline to add Parent record from child import