Skip to main content
Best answer

Help with Formatter tool, to create bullet list of items from an array

  • 8 July 2021
  • 4 replies
  • 1125 views

Hey zapier community, 

 

Can someone help me solve an issue.

 

So I get the data in the following way

 

And would like format or convert this data into bullets or numbered list.

For eg:

in the following way:

  • Official registry extract
  • List of shareholders

Could someone help me with zapier by code for this or any other way to convert the items into bullets and numbered list?

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Sidd 

Are there always only 4 items in the array?

Can you please elaborate on your use case?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
Userlevel 1

Hey Troy, thanks for following up. 

 

No it can either be more or less, its not fixed to 4

Troy Tessalone
Userlevel 7
Badge +14

@Sidd 

What are you trying to do with these formatted items OR where are you trying to send this data?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
SamB
Rank
Userlevel 7
Badge +11

Just wanted to follow up here to confirm that it’s possible to convert a set of line items into a HTML formatted bulleted list. To do that you’d first need to use Formatter’s (Utilities > Line-item to Text) action. This will convert them into a comma separated list of text. For example:

e02d326f339dacacee33382e5ae4a76e.png
Then you would use a Formatter (Text > Replace) action to convert the commas into </li><li> which are HTML tags that end the previous list item and start a new one:
21f69673d0d8cf2ba288f1c333bc15ac.png

Next, in the app you’re looking to add the bulleted list to, you’d add the opening and closing HTML tags for the list (<ul><li> and </li></ul>) and select the middle section containing the list items from the previous Formatter step. If you were using Gmail for example, it would look something like this:
601050d2df8fc2b99411311aeac4ef98.png
The above will then generate any number of line items into a bulleted list. To create a numbered HTML List instead of bulled list you’d use <ol> and </ol> instead of <ul and </ul>. :)

Terms & Conditions