
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 22, 2021 12:29 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 01, 2021 12:35 AM
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
