Forum Discussion

GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
6 years ago

Copying Data from Parent Record to Child record

I have a Parent table that refreshes via a Google Drive Connection. I have an add button on each Parent table record that adds a record to a Child table. When I add a record to the child table I want ...
GeorgeBramhall2's avatar
GeorgeBramhall2
Qrew Cadet
6 years ago
Thanks the Snapshot solution will work for me for most field types. I would like to know how to handle address field types as mentioned above.

------------------------------
George Bramhall
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
While we do not seem to be able to snapshot a whole address field, I believe that you can lookup the six individual address components such as
Address Street 1
Address Street 2 etc  and then snapshot them individually.

Then if you need to reassemble them to look like an address block you can mess around with a formula like this one.

List("\n",
[Address: Street 1],
[Address: Street 2],
List(", ", [Address: City], [Address: State/Region]),
if(trim([Address: Street 1])<>"",[Address: Country]),
[Address: Postal Code])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • GeorgeBramhall2's avatar
    GeorgeBramhall2
    Qrew Cadet
    6 years ago
    I searched the fields in the child table and only see the Address field but not the sub-fields. Where do I access these 6 sub-fields to select the Snapshot option?

    ------------------------------
    George Bramhall
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      :) you need to  create 6 lookup fields from the parent.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------
      • GeorgeBramhall2's avatar
        GeorgeBramhall2
        Qrew Cadet
        6 years ago
        I have done that (added the 6 lookup fields from the parent). The child table has been actively using the address field to capture the six subfield information. As you suggested above, I should be able to access the subfields and click the snapshot functionality, but I don't see how I access those subfields to do so.

        ------------------------------
        George Bramhall
        ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      I just did a test and looked up the field Address Street 1 from a parent to a child.  Then on the child record I made a new text field and then went into field properties way down at the bottom and set it to be a snapshot of the Parent- Address Street 1 lookup field.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------
      • GeorgeBramhall2's avatar
        GeorgeBramhall2
        Qrew Cadet
        6 years ago
        Yes, I understand that you can create a new field in the child table, but I already have many records that are using the existing Address field. I don't want to create another field for the City, State, etc. It already exists. I was just hoping that I could go directly in to each subfield and turn on the SnapShot functionality.

        ------------------------------
        George Bramhall
        ------------------------------