Forum Discussion

AlexWilkinson's avatar
AlexWilkinson
Qrew Assistant Captain
6 years ago

Automation to create missing parent record when a child added

Scenario: A child record is created. It has a field (often a text-formula) that uniquely identifies the parent record. If the parent record already exists, wonderful! If it does not, use an automation...
Quickbase Automations
AlexWilkinson's avatar
AlexWilkinson
Qrew Assistant Captain
6 years ago
It would be necessary to check for existing of the Parent in Automation #2, would it not?

Essentially, Automation #1 is creating a virtual queue, and Automation #2 is processing that queue. Clever.

Minor reservation: the method requires a sequence of Automations where the sequencing is implicit in the logic of the two Automations. That makes it slightly more vulnerable than a single-Automation approach such as my 4a or 4c, where the sequence is explicitly specified.​​​

Thanks for taking the time to spell out a good alternative.

------------------------------
Alex Wilkinson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Yes, for sure Automaton #2 needs to make sure that the Parent still does not exists. I will update my post above..

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    And yes you can have a Safety Net Automation run each night to trigger a saved table to table each night to mass update the field [Date Time to Request Creation of Parent] for orphans to be sure that here was no hiccup in the live process.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------