Re: Records not sorting properly in automation script
No, of course not. This is only the snippet of code that has gone wrong. Everything else in the code works fine.
fieldToRank1: album code
fieldToRank2: INTERNAL: master track no
fieldToRank3: Nesting Sort Position
Below is a screenshot showing these fields and the correct “INTERNAL: Harvest no”
I purposely did not include the full code because it would probably be more confusing than helpful. The idea here is that we’re trying to augment a sheet with the original track numbering system with the track numbering system of another sheet format. The only thing I need help with is PART 3.
Full code:
/// PART ONE - CREATE ID DICTIONARY (WORKS FINE)
console.log(`Updating internal record of master track numbers for non-master tracks in main table of ${base.name}!`);
let sourceAudio = base.getTable("Source Audio Metadata");
let fieldToRank1 = sourceAudio.getField("Album Code");
let fieldToRank2 = sourceAudio.getField("INTERNAL: master track no");
let fieldToRank3 = sourceAudio.getField("Nesting Sort Position");
console.log("Retrieving master ID mappings");
// get ids from previous step
const ids = input.config().records;
// get the table records
let saRecords = await sourceAudio.selectRecordsAsync({
recordIds: ids,
fields: [
"Master ID",
"SourceAudio ID",
"Track Number",
"INTERNAL: master track no",
"Album Code",
"Nesting Sort Position",
"INTERNAL: Harvest no"],
});
// dictionary of master IDs to master track number
var masterTrackMapping = {};
// loop through the records to create master -> track no dictionary
/** redacted logic, this works fine, and we get the masterTrackMapping dictionary**/
/// PART TWO - FIRST UPDATE - add dictionary lookup to each track
console.log("Updating records with master track number");
/** redacted logic, this works fine, and we get the "INTERNAL: master track no" populated as seen in the screenshot **/
/// PART THREE - FINAL UPDATE - sort by the newly added field in part 2 + "Nested Sort Position", then enumerate and inject "INTERNAL: Harvest no" for records in that order.
// Sort by the newly added main track number, nesting sort position to create and inject Harvest track number
console.log("Sorting by master track no, nesting position & updating the harvest track number...")
saRecords = await sourceAudio.selectRecordsAsync({
recordIds: ids,
sorts:[ // this sorting does not seem to be applying
{field:fieldToRank1, direction:"asc"},
{field:fieldToRank2, direction:"asc"},
{field:fieldToRank3, direction:"asc"},
],
fields: [
"Master ID",
"SourceAudio ID",
"Track Number",
"INTERNAL: master track no",
"Album Code",
"Nesting Sort Position",
"INTERNAL: Harvest no"],
});
var harvestTrackNumber = 0;
for (let record of saRecords.records){
harvestTrackNumber ++;
console.log("track no: " + harvestTrackNumber);
// Update selected field with the new track number
await sourceAudio.updateRecordAsync(record.id, {"INTERNAL: Harvest no":harvestTrackNumber,});
// Let user know the script is running & notify when done
if (harvestTrackNumber%5 === 0){
console.log("Still running...")
}
if (harvestTrackNumber === saRecords.records.length){
console.log("Done!")
}
}
Negative, both fields 2 and 3 are text fields, as denoted by the “A” next to the column name.
Field 1 is the linked record “Album Code”. This shouldn’t matter in this case as they all have the same album code.
The screenshots are sorted in the same way as in my code, no grouping.
Below are the correct sort and the incorrect sort:
Correct (when I run the same code in a script that isn’t in Automations)
Incorrect (when I run the code in the Automation script)
