Skip to main content

Multiple Cells to Bullet List in Rich Text Field

  • July 25, 2022
  • 1 reply
  • 16 views
B

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

1 reply

Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • 1261 replies
  • July 25, 2022

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)})


Terms & ConditionsAccessibility statement