Script that inserts new records and pastes values from origin table, copy/paste does not work.
I wish to create a script that takes records from columns/fields and copies them into another table. I made the beginner's mistake of creating a few columns for individual grant disbursements which would be better recorded in table rows. Now, having entered the data already, I wish to write a script that first finds the appropriate rows (i.e. disbursements that are not empty etc.) and then makes a new record in a related table copying the grant id (which is the same for each disbursement) into the table and creating a new record for each disbursement value. My script is attached as a screenshot.
I am basically wondering about the potency of copy/paste after having created a new record using the relationship and SetField. So, I am wondering about how to paste values into the row that ensues after having created the record. The records get created but for some reason, the copy/paste does not work and the target field records stay blank.
I would greatly appreciate your help.