Hello @seaTurtlesRUS ,
If the duplication detection and removal process is manual then First, check this extension Dedupe - Apps - Airtable Marketplace as @ScottWorld mentions. If that works it's best to use it, there are lots of flexibility in field selections.
Otherwise, Try this.
The error message you're encountering is that you're using the await keyword inside a callback function that is not marked as async. Specifically, the await keyword is used inside the .filter() method's callback function, which is not itself an async function.
To fix this issue, you'll need to refactor your code because .filter() cannot be directly used with asynchronous operations like await. Instead, you can use a loop to iterate over the records and perform the necessary asynchronous operations.
Here's a revised version of your code that addresses this issue:
var table = base.getTable('Testing_500');
var query = await table.selectRecordsAsync();
let duplicates = []; // To keep track of duplicates
// Use a for loop to iterate over the records
for (let i = 0; i < query.records.length; i++) {
let record = query.records[i];
for (let j = 0; j < query.records.length; j++) {
let potentialDupe = query.records[j];
let fName = record.getCellValue("First Names") === potentialDupe.getCellValue("First Names");
let lName = record.getCellValue("Last Name") === potentialDupe.getCellValue("Last Name");
let resi = record.getCellValue("Residence") === potentialDupe.getCellValue("Residence");
let ident = record.id !== potentialDupe.id;
if (fName && lName && resi && ident) {
// Initialize update variables inside the loop
let upPN = null;
let upEM = null;
let upID = null;
if (record.getCellValue("Phone Number") == null && potentialDupe.getCellValue("Phone Number") !== null) {
upPN = potentialDupe.getCellValue("Phone Number");
upID = record.id; // Update this to record.id since you're updating the current record
}
if (record.getCellValue("Email Address") == null && potentialDupe.getCellValue("Email Address") !== null) {
upEM = potentialDupe.getCellValue("Email Address");
upID = record.id; // Update this to record.id as well
}
// Perform updates if there are fields to update
if (upPN || upEM) {
await table.updateRecordAsync(upID, {
"Phone Number": upPN,
"Email Address": upEM,
});
await table.deleteRecordAsync(potentialDupe.id);
duplicates.push(record); // Add to duplicates list if any action is performed
}
}
}
}
console.log(duplicates);
A few key changes and considerations in this revised code:
Loop Structure: The code now uses nested loops to compare each record against every other record. This allows for asynchronous operations within the loop using await.
Update Variables Initialization: The variables upPN, upEM, and upID are initialized inside the loop to ensure they are reset for each record comparison.
Updating the Correct Record: When updating a record or deciding which ID to use for updates, it's important to target the correct record (record.id).
Duplicates List: The duplicates array now tracks records for which updates or deletions have been performed.
Note:- I've used some help from GenAI here. But that ok if it solves our problems.
👍
