Re: Multiply an Array
Hey there,
Is there a way to multiplyer an array of number to a constant or variable.
I have all my item with a default quantity on a table like so :
I’ve created group of item so I only have to add one group to list of the items with their default quantity (to prevent errors)
My problem is here on the packing List, when I want to be able to multiply the default quantity per Tower I need but I can’t figure out how to do so. How to multiply an array with “Tower needed” ?
Here’s a script that will do the job. This is set up to work in the Scripting app. I don’t recommend using an automation for this because there are several possible changes that would require a recalculation, and catching some of those could be tricky.
// Setup
let table = base.getTable("Group")
let record = await input.recordAsync("Select a record", table)
// Collect the list
let items = record.getCellValueAsString("Item Names").split("\n")
let qty = record.getCellValue("Quantity")
let newItems = []
// Calculate new totals
for (let item of items) {
let parts = item.split(" ")
let newQty = Number(parts[0]) * qty
newItems.push(`${newQty} ${parts.slice(1).join(" ")}`)
}
await table.updateRecordAsync(record, {"Total Items": newItems.join("\n")})
Here’s the script in action:
Aside from changing the table and field names in the script to match your scenario, the primary requirement is that the items are on separate lines, as the original example above shows. This can be done by using the following aggregation formula for any rollup fields: ARRAYJOIN(values, "\n"). A number must be at the beginning of each line, with a space separating it from later pieces.
Hi Justin! (or other script experts),
I’m hoping to resurrect this thread because I used your code for a similar problem (thank you!). I was able to get it to work as you recommended, and now I’m hoping to modify it so that the script runs through an automation whenever the Quantity field is updated. I pasted the same script into an Automation, which produced an error
I tried to fix that by changing line 3 to read:
let record = input.config()
but this gave me an error on line 6. Any guidance would be appreciated!
