- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 24, 2022 11:08 PM
Hello -
I have a base that manages products for a website through Webflow. I have built and tested a tool that will import products from an XML source from the supplier that my client uses; however, for the product descriptions it gives the bullet list in an array (XML) that provides up to 24 bullets.
I have them mapped and they sync to 24 distinct columns accurately, but now I’m having some trouble navigating how to get those 24 fields converted into a bullet list in the rich text field I have for the “Full Description” - while ignoring empty fields.
Any support or insight would be greatly appreciated!
- Brian
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 25, 2022 07:21 AM
Hi,
consider arr is a variable containing array of fieldnames, values retrieved by usual getCellValue, rec is record
const bulletlist=rec=>`- ${arr.map(fld=>
rec.getCellValue(fld)).filter(n=>n).join(('\n- '))}`
usage example:
await table.updateRecordAsync(rec.id,{'result':bulletlist(rec)})
