Help

VLOOKUP Script is not working

Topic Labels: Scripting extentions
588 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nathan_Phillips
4 - Data Explorer
4 - Data Explorer

I can’t for the life of me to get this script to work. I’m trying to do a vlookup across two tables.
“In Contract” table is the one that I’m trying use the information from “Movie/Episode Title” Column and find that same title in the “Episode/Movie Title” in the “All Assets” table and then grab the info from the “Program/ Asset ID” column and paste that into the “Asset ID” column on the “In Contract” table.

let mainTable = base.getTable(“In Contract”);
let mainTableRecords = await mainTable.selectRecordsAsync({fields:[“Episode/Movie Title”]});

let lookupTable = base.getTable(“All Assets”)
let lookupRangeRecords = await lookupTable.selectRecordsAsync({fields:[“Movie/Episode Title”,“Program/ Asset ID”]});

for (let record of mainTableRecords.records) {
let lookupvalue = record.getCellValue(“Episode/Movie Title”);

for (let reangeRecord of lookupRangeRecords.records) {
    if (rangeRecord.getCellValue("Movie/Episode Title") === lookupValue). {
        let returnValue = rangeRecord.getCellValue("Program/ Asset ID");

        await mainTable.updateRecordsAsync(record,  {
            "Asset ID": returnValue
        });
    }
}

}

Here is the error I’m getting…
ERROR

SyntaxError: Unexpected token ‘.’
at Function
on line 1
at l on line 1
on line 1
at r on line 1
at s on line 1
on line 1
at Promise
on line 1
at l on line 1
on line 1
at r on line 1
at s on line 1
on line 1
at Promise
on line 1
at l on line 1
on line 1
at r on line 1
at s on line 1
on line 1
at Promise
on line 1
at handle on line 1
on line 1

I’m sure it is something really dumb that I’m missing.

0 Replies 0