About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Line Itemizer for Paragraphs with Varying Inputs

H
Userlevel 1

I have a record summarising the incidents that a client is involved in during each month. For some months this could be 0 incidents, for others there could be 5 or 6 etc. 

 

I am trying to translate this noise into external facing notion pages that give a summary of the month for each client and the individual events they were affected by. 

 

Here is how I am currently using the Line Itemizer feature: 

It is giving me a great output:

 

Which I was hoping I could use to now have a paragraph for 1: and a paragraph for 2: 

 

However when I get to a later text based action step and I look for the outputs I generated above, I get the same comma delineated stuff: 

Is there some other step I should be using?

icon

Best answer by SamB 13 March 2023, 13:29

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

5 replies

MohSwellam
Userlevel 7
Badge +8

Hi @Hugpuf 

 

The comma separated text is actually line items. i.e.: if you use a Loop by Zapier step, you can trigger the next actions separately for each of the line items. This would be your solution if you are looking to create a new entry for each of the line items. 

 

HOWEVER, IF I understand correctly, I would approach this differently. I would use Rollup fields and Formulas in Airtable to summarize the incidents in a paragraph for each client (given that you have your clients Linked to the incident in Airtable) THEN use this summary to create 1 record in Notion per client (if that is what you are looking for?) 

 

Let me know if that makes sense and if you need any more help. 

Founder of GeekyAir.com
H
Userlevel 1

Hi Moh, thanks for responding so quickly to this. 

 

I have created a short loom giving a run down of where I’m at: 

 

 

SamB
Rank
Userlevel 7
Badge +11

Hi @Hugpuf. Thanks so much for sharing that helpful video to explain the situation. 🙂 

With Looping by Zapier you’d end up creating to separate database items. So if there were two incidents for a client, there would be one database item added for each of the incidents. 

But if you’re wanting all incidents to be added into a single database item then I’d suggest adding an additional Formatter action. You’d need a Formatter (Utilities > Line-item to Text) to convert the line items into text which you can then select in the Notion action. For example a Formatter action with the following set up would output all the incident line item information as text separated by a couple of return breaks:

bf76658e45750e7ff0efb227850c378b.png
You would then select the Output Text field, from that Formatter action, in the Notion action. Which would look like this:
35d48b404ce02315aa55fe199d0a2a8e.png
And that would result in it appearing in Notion like this:
1214e4e25861274354acfa17a5864601.png
Would that approach work for you here? 

H
Userlevel 1

This is awesome ^ thank you so much

SamB
Rank
Userlevel 7
Badge +11

You’re welcome, @Hugpuf. Happy to help! 😁

Terms & Conditions