Help with automation that creates nonduplicated record

Argh, and here’s the latest script Chat GPT wrote. Still no new record…

// Get the input config

let inputConfig = input.config();

let farmNumber = inputConfig.farmNumber;

let producerName = inputConfig.producerName;

let contractNumber = inputConfig.contractNumber;

// Tables

let producerEnrollment = base.getTable('Producer Enrollment');

// Check if a record with the same Farm # and Producer Name already exists

let existingRecords = await producerEnrollment.selectRecordsAsync({

    fields: ['Farm #', 'Producer Name']

});

let recordExists = existingRecords.records.some(record =>

    record.getCellValue('Farm #') === farmNumber &&

    record.getCellValue('Producer Name') === producerName

);

if (!recordExists && farmNumber && producerName) {  // Also check for empty values

    await producerEnrollment.createRecordAsync({

        'Farm #': farmNumber,

        'Producer Name': producerName,

        'Contract #': contractNumber

    });

}

Hey ​@AndreaR,

Would you mind explaining the following in further detail?

“I have a second table called “Producer Enrollment” that I want to be auto populated by the Farm Key. However, there are cases like in my example where there are duplicate Farm Keys and I only want the one.”

What do you mean when you say that you want the Producer Enrollment be auto-populated by  the Farm Key?

If there are records with same Farm Key, which one is “the one”?

Sorry I cannot provide a straight forward answer. However, with answers to the above, and some additional details on your use case and context, I’m pretty sure I’ll be able to help (and probably no script is needed).

Mike, Consultant @ Automatic Nation

Hi Adam, wow! That’s looking pretty good! The only thing is that we have hundreds of these so I don’t want to click a “run automation” button. Is there some other trigger that could be used, perhaps “if Farm isn’t empty”? Will test now and report back. THANK YOU!!!

Oh lawd, it worked. THANK YOU. That only took me about 6 hours 😜 Have a good one!