Duplicate several records with changing one of the fild values

You could try something like this in a button:

let findRecs := select tablename where fieldname = something;
for loop1 in findRecs do
    let newRec := duplicate(loop1);
    newRec.(
        fieldToChange := newValue
    )
end

Line 1, we need to create an array of the records you want to duplicate, so we use the select command and the where parameter to only find the records you need. Make sure to put in the proper table name, field name and search parameter.

Lines 2 - 7, is the for loop that will go through the array from line 1 and duplicate each record. Then it will take the newly duplicated record and change a field to a new value. Make sure you put in the correct field name and value.