Any Idea why the scripting block would give me this error? I've seen
let query = await table.selectRecordsAsync();
used in other scripts.
Scripting Error
+10
+19Hey @PickThisBerry ! Can you post a screenshot of more of your code? selectRecordsAsync is working for me. Prob just a small typo somewhere. Here's an example:
+10Hey @PickThisBerry ! Can you post a screenshot of more of your code? selectRecordsAsync is working for me. Prob just a small typo somewhere. Here's an example:
// Define the base
const base = ('DMB_Data');
// Define the table name and column names
const table = 'DMB_Products_Groups';
const columnA = 'email';
const columnB = 'full_name';
const columnC = 'multiple_emails';
// Initialize an empty object to store the mapping
const mapping = {};
// Query all records from the table
const query = await table.selectRecordsAsync({fields: table.fields});
// Iterate through the records and build the mapping
for (const record of query.records) {
const valueA = record.getCellValue(columnA);
const valueB = record.getCellValue(columnB);
if (valueA && valueB) {
if (!mapping[valueB]) {
mapping[valueB] = [];
}
mapping[valueB].push(valueA);
}
}
// Update the records in Column C
for (const record of query.records) {
const valueB = record.getCellValue(columnB);
if (valueB) {
const valuesA = mapping[valueB];
record.setCell(columnC, valuesA);
}
}
+29@PickThisBerry Can you share more about how you got this script, how it was written, and your scripting skill level?
The reason you are getting the error is because your variable table is not actually a table object. It is a text string matching the name of a table. To get an actual table object, you can use
const table = base.getTable("DMB_Products_Groups").
+19@PickThisBerry simple fix, try changing this:
const table = 'DMB_Products_Groups';
to this:
const table = base.getTable('DMB_Products_Groups');
Also change this line:
const query = await table.selectRecordsAsync({fields: table.fields});
to
const query = await table.selectRecordsAsync({fields: ["Field Name 1", "Field Name 2"]});
Where "Field Name 1" and "Field Name 2" are the specific names of your fields. (if need more than 2, use commas to separate more entries.
Let me know if that works for you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.