Airtable Scripting - Conditionally update records based on view

index.js

let config = input.config({
    title: 'Test Script',
    description: 'Updates Name & Email fields on Test records to have a generic default if they are empty.',
    items: []
});

let table = base.getTable('Test');
let view = table.getView('Empty Name or Email');

let result = await view.selectRecordsAsync({
    fields: ['ID', 'Name', 'Email']
});

for (let record of result.records) {
    let id = record.getCellValue('ID');
    let name = record.getCellValue('Name');
    let email = record.getCellValue('Email');

    output.text(`processing ${id}`);

    if (name === null || name === '') {
        await table.updateRecordAsync(record, {Name: 'Unnamed Person'});
        output.text(`update ${id} name`);
    }

    if (email === null || email === '') {
        await table.updateRecordAsync(record, {Email: '[email protected]'});
        output.text(`update ${id} email`);
    }
}