Hello the community,
I would like to add a return value condition in the vlookup script depending on another column containing a specific text.
your support is really appreciate.
Here my current script that I would like to improve:
thanks for your feedback. it works but issue I have now is concerning the return value.
By this code:
let mainTable = base.getTable(“Questionnaire”);
let mainTableRecords = await mainTable.selectRecordsAsync();
let lookupTable = base.get...