Skip to main content

Hi All - new here and a bit of a novice developer but trying to automate a simple creation of new records in one table when a new record is created in another table. I’ve been trying to mimic a bit of the parent /template script example but my filter function wont read my input variable that is part of the automation.


let listTable = base.getTable('List of Metrics');

let importQuery = await listTable.selectRecordsAsync();

let importRecords = importQuery.records;

let metricsTable = base.getTable('Metrics');

let inputConfig = input.config();

let companySector = inputConfig.companySector;



let imports = importRecords.map(c => ({

    'Sector': c.getCellValue('Sector'),

    'Stage': c.getCellValue('Stage'),

    'Name': c.getCellValue('Name'),

})).filter(x => x.Sector.includes(companySector))

I’m trying to filter the imports by sector, but an error I’m getting is that since companySector is a string it is not compatible and reads as null.


Feel like I’m missing something simple, thanks!

Hi @Connor_Cash - includes works on an array:


https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/includes


like this:


const pets = ['cat', 'dog', 'bat'];



console.log(pets.includes('cat'));

// expected output: true

So I’m guessing that, in your case, x.Sector is not an array, but a string (but I can’t tell from the script - would need to see the base to be sure). If it is a string, you should just be able to test for equality, e.g.


x.Sector == companySector

Reply


Terms & Conditions