Create Records based on a number field in a different table

[Amanda_Lubow]

I’m trying to create a certain number of new records in a table based on a number in another table.

For example, if the # Field in Table A is 4, then I want to create 4 new records in Table B.

Is this possible? Any idea how I’d do it with either Scripts or Automations?

[KVachon]

Hey there!

1. You can create a linked field between Table A and Table B (we will call it Created Records Link)
2. Then create an automation triggered on “When record matches condition” that looks at your # Field in Table A. (you can use any trigger you’d like)
3. Create a “Run a Script” step
4. Create two input variables:

• numberOfRecords: look at the first step at the # Field
• linkedRecordId: look at the first step and choose the Record ID

Then drop in this script:

let inputs = input.config();
let numberOfRecords = inputs.numberOfRecords;
let linkedRecordId = inputs.linkedRecordId;
let recordsTable = base.getTable("Table B");

// Create three records in the Table B table linked to Table A
    for (let i = 1; i < numberOfRecords + 1; i++) {
    let recordId = await recordsTable.createRecordAsync({
    "Name": "Test " +[i],
    "Created Records Link": [{id: linkedRecordId}],
    })
};

This will create the number of records that you identified in Table A # field in Table B. In this example I just created them with the name “Test” and the record number.