
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21, 2022 11:46 PM
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 script
let templateName = r.getCellValue(s.tempField.name);
console.log(templateName)
let monthName = r.getCellValue(s.monthField.name);
templateName.forEach(item => console.log(`${monthName}; ${item.name}`));
let combinedArray = templateName.map(item => `${monthName}; ${item.name}`);
console.log(combinedArray);
output.table(combinedArray);
How to modify this script? Thanks!
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 22, 2022 04:03 AM
Hi,
try to add .join().split(',')
right after getCellValue(fname)
i’m not sure it’s correct for all types of lookup, but it should work in your case
note that if your values contain comma, you should define another divider, also providing join()
with it
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 22, 2022 04:03 AM
Hi,
try to add .join().split(',')
right after getCellValue(fname)
i’m not sure it’s correct for all types of lookup, but it should work in your case
note that if your values contain comma, you should define another divider, also providing join()
with it
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 22, 2022 06:22 AM
You’re a lifesaver! Thanks a lot mate!
