Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
6 years ago

Actions/Automations: How do I create a record in the same table as the trigger record creation?

I need to create a new record  when another record is manually created. The trigger record and new record are in the same table, so Actions won't allow it since it's adding a new record. When I attempt to use Automations to accomplish this, it goes into an endless record creation loop. Is there a way to automate this without creating endless records?

Thanks!
Quickbase Automations
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Well a low-tech solution is to create a checkbox field that is not visible really on any forms called [record created by automation]

    Then said your automation to only trigger when that check box field is not checked.

    But when the automation does run when a record is that it manually and creates the record then it would checkbox that field so that it would not self trigger.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • MattMakris's avatar
      MattMakris
      Qrew Assistant Captain
      6 years ago
      Low-tech works for me in this case! Thanks - it worked great!

      Matt


      ------Original Message------

      Well a low-tech solution is to create a checkbox field that is not visible really on any forms called [record created by automation]

      Then said your automation to only trigger when that check box field is not checked.

      But when the automation does run when a record is that it manually and creates the record then it would checkbox that field so that it would not self trigger.

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