Update

I have made some progress so far, but I am running in to trouble with my Linked Record field, Equipment # and Description. Right now I am able to separate the array of New #'s into respective Outputs. The formula I have in the primary field is just {Output}. This is what my table looks like before and after I run my code:

Before:

After:

The problem I am having is that I apparently I can’t a string to a linked record field, as far as I can tell? I may need create a work around sorts by using additional tables and primary fields, but for now I would like to know if there is a way to put the corresponding Equipment # and Description in their respective fields. I also would like to delete the initial record because the primary field is left blank, which is causing issues in other areas.

My current code:

As always, thanks for the time anyone spends on this. Also, I thought I would just reply to myself instead of making a super long post…

Have you actually tried running it? :slightly_smiling_face: What error is it throwing?

Yep, I have tried running it but I don’t get an error. I actually have a slightly updated version below that shows my most recent attempts. Visually, refer to the above to see what this is doing. The problem I am having is getting the individual values of Equipment # and Description to show up. I don’t know how to use scripting to place values into a linked record.

let table = base.getTable("CopyRows");
let query = await table.selectRecordsAsync();
let field = await table.getField("Equipment # and Description");
for (let record of query.records) {
    let quantity = record.getCellValue("Count");
    if (quantity > 1) {
        for (let i = 0; i < quantity; i++) {
            let myArray1 = [record.getCellValueAsString("New # (Don't Use)")]
            let myArray1j = myArray1.join()
            let myArray2 = [record.getCellValueAsString("Equipment # and Description")]
            let myArray2j = myArray2.join()
            let myArray2s = myArray2j.split(",")
            let id = await query.getRecord(query.recordIds[0])
            let newRecord = await table.createRecordAsync({
                "Equipment # and Description": { id: myArray2s[i] }[0],
                // ^^ where my current issue is
                "Output": Number(myArray1j.substring(i * 8, (i * 8) + 6)),
                // ^^ for some reason I could't removeAll spaces and commas, hence the formula
                "Project Number": record.getCellValue("Project Number"),
                "Start": record.getCellValue("Start"),
                "End": record.getCellValue("End")
            })
            //let id = await query.getRecord(query.recordIds[0])
            //await table.updateRecordAsync(record, 
            //{"Equipment # and Description" : {id : myArray2s[i] }[]})
            // ^^ can't figure out if I need to update the record after it's created or fill in as I create the record 
            console.log(myArray2j)
            console.log(myArray2s)
            console.log(myArray2s[i])
            console.log(id)
        }
    }
    else (
        await table.updateRecordAsync(record, {
            "Output": Number(record.getCellValue("New # (Don't Use)"))
        }))
}

let table = base.getTable("CopyRows");
let query = await table.selectRecordsAsync();
let field = await table.getField("Equipment # and Description");
for (let record of query.records) {
    let quantity = record.getCellValue("Count");
    if (quantity > 1) {
        for (let i = 0; i < quantity; i++) {
            let myArray1 = [record.getCellValueAsString("New # (Don't Use)")]
            let myArray1j = myArray1.join()
            let myArray2 = [record.getCellValueAsString("Equipment # and Description")]
            let myArray2j = myArray2.join()
            let myArray2s = myArray2j.split(",")
            let id = await query.getRecord(query.recordIds[0])
            let newRecord = await table.createRecordAsync({
                "Equipment # and Description": { id: myArray2s[i] }[0],
                // ^^ where my current issue is
                "Output": Number(myArray1j.substring(i * 8, (i * 8) + 6)),
                // ^^ for some reason I could't removeAll spaces and commas, hence the formula
                "Project Number": record.getCellValue("Project Number"),
                "Start": record.getCellValue("Start"),
                "End": record.getCellValue("End")
            })
            //let id = await query.getRecord(query.recordIds[0])
            //await table.updateRecordAsync(record, 
            //{"Equipment # and Description" : {id : myArray2s[i] }[]})
            // ^^ can't figure out if I need to update the record after it's created or fill in as I create the record 
            console.log(myArray2j)
            console.log(myArray2s)
            console.log(myArray2s[i])
            console.log(id)
        }
    }
    else (
        await table.updateRecordAsync(record, {
            "Output": Number(record.getCellValue("New # (Don't Use)"))
        }))
}

Ok, we’re getting somewhere, a few things:

awaiting individual fields isn’t necessary, or consequential in any way, for that matter.

you probably know this already but having special characters tied to reference values is not a good habit to get into. Ditto for not using the semicolon to end your statements; which might actually be the source of some of your problems due to code leakage.*

for some reason I could’t removeAll spaces and commas, hence the formula

I have a feeling that “some” reason is the same thing giving you trouble elsewhere hah.

No easy way to bootstrap a test base but those whitespaces suggest your typing is wrong;

I’d suggest rewriting the whole script in a way that doesn’t allow for nested loops and you might be surprised how smoothly things will go from there. As things stand right now, you shot yourself in the foot with the overly convoluted syntax, halfway in.

I don’t have any experience with Javascript syntax. Or coding at all, really. I guess I should have clarified that more in my original post.

I’m not sure if it possible to rewrite this without having at least one nested loop, since what I need to do is an iterative process.

Is there anyway you could give me some pointers on how to accomplish what I’m trying to do? If my objective is still confusing I apologize, I can try and explain more if I know what is unclear!

I took most of my source code from the below link and edited to fit my needs after a ton of trial and error.

Create multiple records based on a quantity field with a Script