Skip to main content
Question

Transferring Field Data to Another Record

  • Sep 19, 2025 2:26 PM UTC
  • 3 replies
  • 159 views

Forum|alt.badge.img+4

Hello, 

Is it possible for me to transfer quantity data on one record to another record? As an example, Record A has 10 laptops. Record B has 5 laptops. I would like to transfer 2 laptops from Record A to Record B. I've tried different methods, but I keep hitting a wall. 

3 replies

MarkShnierYou
Forum|alt.badge.img+24

Can you tell us a little more about the structure of your data. Are these numbers just a single field on record A and record B. Or are these records in fact, parents and underneath the parents are respectively 10 and 5 child records with the individual laptop serial numbers?


Forum|alt.badge.img+4
  • Author
  • Qrew Corporal
  • Sep 19, 2025 2:56 PM UTC

Sure! Using my laptop example, the second option is correct. Each parent record is linked to a child record, and I want to transfer one or more child records from one parent to another. I've also created a product tracker table and a change log table, which allow me to view and track changes made to the parent records.


Top Step
Forum|alt.badge.img+12
  • Observing
  • Oct 23, 2026 4:12 PM UTC

Since each laptop is its own child record, you don’t move a quantity at all. You move the child records and the counts on both parents follow.

Change the Related Parent field on the 2 laptop records from Record A to Record B. If the quantity on the parent is a Count summary field of the children, A drops to 8 and B goes to 7 on their own.

For a few at a time, make a report on the child table that shows the Related Parent field, filter it to Record A, and edit that column inline. Pick B for the 2 you’re moving and save.

For your change log, use a pipeline on the child table with Record Updated as the trigger. Set Trigger on Any Field to No and watch only the Related Parent field. Then create a change log row with the old and new parent, using $prev for the old one:

{{a.$prev.related_parent}}

If your quantity is a typed number on the parent rather than a summary field, I’d switch it to a summary. Otherwise you’re editing two numbers by hand on every transfer and they will drift from the actual laptops.