So, within the Uncategorized stack - you’re only wanting one of the duplicates names listed and then once it’s assigned, you want it to populate with the next duplicate?

Here is the result that I just got working with an Automation Script - as with all Automations, it takes about 5 seconds to update;

So, my initial setup is this;

To get a step closer to what you’ve described, we’ll need to make our own “Unassigned” type;

We’ll then need to monitor that stack with a script, that scans the Uncategorized duplicate records and then adds the next duplicate to the custom “Unassigned” stack, limiting it to one at a time.

I wrote this Automation script in haste, so it might be buggy, but it worked well enough in my quick testing;

let table = base.getTable("List");

let query = await table.selectRecordsAsync({

    fields: b"Demeanor", "Address"],

});



let gonnaFindOut = "";

let demeanorCount = query.records.filter( record => ( record.getCellValueAsString("Demeanor")) == " Gonna Find Out").length



console.log(demeanorCount);



if (demeanorCount < 1) {

    ugonnaFindOut] = query.records.filter( record => ( !record.getCellValueAsString("Demeanor"))).map( record => record.id)

    console.log(gonnaFindOut);

   

    await table.updateRecordAsync(gonnaFindOut, {

    "Demeanor": {name: " Gonna Find Out"}

    })

}