Forum Discussion

AmyGosz2's avatar
AmyGosz2
Qrew Cadet
6 years ago

When a child record is added, create a second child record

My app has two tables. When the child record is added, I would like another child record automatically created and have some fields pre-populate with data from the first child record. I think it would...
Quickbase Automations
AmyGosz2's avatar
AmyGosz2
Qrew Cadet
6 years ago
HI Mark...I did try an automation, but the field values I want to populate in the new child record are formula fields on the original child record. Those fields were not available in the drop down of fields to choose to set up and populate.

------------------------------
Amy Gosz
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You cannot type manually into a formula field nor can an Automation write into a formula field.  So you will need to rethink that you are trying to do.  Or explain here what you are trying to do.



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • AmyGosz2's avatar
    AmyGosz2
    Qrew Cadet
    6 years ago
    In the original child record I have formula fields populate based on data being entered. I would like to take the values in those formula fields and create a second child record automatically. Ultimately, we would run a report to pull both original and new child records. However, as you said, I think my train of thought is flawed and I need to think a bit more on this. I'm hoping I don't have to create a another child table for the automatic record. Thanks!

    ------------------------------
    Amy Gosz
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      well, you could chnage the formiula to allow and override fild be taken into account

      like

      if([override field populated by Automation]<>"",[override field populated by Automation], else formula goes here)

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