Previously I’m using multiselect field from the current table. However, I am trying to automate by pulling the multiselect field from the LOOKUP. But when I want to run the script, I am unable to do so.
Here is the structure of the base
My current ...
Hi Guys,
Previously I was using filtered.pop (thanks to @Alexey_Gusev) to find the last record that has no amount
let filtered=(result.records.filter(item => item.getCellValue('Cumulative by Customer') > 0));
let last=filtered.pop();
Howeve...
This is my current scripting code to do cumulative total based on customer field.
// change these names to pick a view:
let table = base.getTable('Sales');
let view = table.getView('Overall');
let result = await view.selectRecordsAsync({fields: ['Cu...
Hi guys,
Need your help in scripting. I want to concatenate month and templateName to another table using scripts as individual records.
My desired output is e.g.
templateMonth; templateName
2022-01; HD-HD1460, TR144 | 1 x RM-HD
2022-01; HD-WHITE | 5...
I’m surprise the level of engagement from Airtable in this thread! Keep it up guys! I know you are now focusing on Enterprise but those in the lower plans can and might be the enterprise in the future! :grinning_face_with_big_eyes:
Thanks for your reply @Vivid-Squid. I manage to convert your script to automation (daily update of conversion rate). Sharing here in case anyone needs it. Replace first 2 lines to these.
//Record Input
let inputConfig = input.config();
let recordID =...