Question

How to filter out this output from formatter step?

  • 10 March 2023
  • 6 replies
  • 57 views

Userlevel 1
Badge +1

Here the output shows separate fields (along with user, ts and type)for each text being sent in slack.
My question is out of the list, how to filter out based on user id.
for example if user = <user id>, format remove the matching result and output only the text sent other users in separate fields.
How can I do this filter using formatter by Zapier?


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

6 replies

Userlevel 3
Badge +4

Hi @Jojin 

Awesome!

Could you kindly share how Code by Zapier worked for you? That way other members of the Community can see it and apply it on their end as well.

Would greatly appreciate it! 😊

Userlevel 1
Badge +1

@Charie Code by zapier helped to format the output. thanks for catching up!

Userlevel 3
Badge +4

Hi @Jojin 

I see that you’re already working with one of our Support Specialist and they suggested this,

Do you want the first line item to be always removed/ignored by the Zap? In that case you could use:

  • the Line Item to Text Formatter action to split the line items into individual fields
  • The Line Itemizer to combine all the individual fields into a line item again, but without the first item

If you want to be able to map the entire line item at once, try mapping each line item field from the previous step into your "Text to Line Item" step, and separating them with commas.
You can read more about using text and line item formatting here: 

However, Troy also suggested using Looping and Filter by Zapier.

Have you tried one of those suggestions? If so, may I know what worked for you?

Looking forward for your response! 😊

Userlevel 7
Badge +14

@Jojin

If you want to handle each line item in the array separately, then you can use the Looping app: https://zapier.com/apps/looping/help

Follow that with a Filter step.

 

Otherwise, you’ll have to use a Code step: https://zapier.com/apps/code/help

Userlevel 1
Badge +1
this is the output which needs formatting

 

Userlevel 7
Badge +14

Hi @Jojin 

Good question.

The image did not attach.