Forum Discussion

CassidyPhillips's avatar
CassidyPhillips
Qrew Member
7 years ago

Automatically create a parent record when info saved in the child reference field

Hi, I currently have two tables in a parent-child relationship: effectively I've got 100 parcels in the child table and each parcel is kept in one of ten boxes, which are kept in the parent table. Rat...
Data import and export
Relationships
Tables and fields
ClaireMartinez's avatar
ClaireMartinez
Quickbase Alumni
6 years ago
Yes, this can be done using automations. I just learn this from Harrison today.
You can create a lookup field  (named: has-parent) on the child record to the parent's formula checkbox field that has the formula value of true. This lookup will be true if the parent exists false otherwise. Then in the automation when a child record is modified/added and its lookup has-parent field is unchecked then create a new parent record using the child content for the reference field value.
AlexCertificati's avatar
AlexCertificati
Qrew Cadet
6 years ago
That's a sweet trick.