Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

I have a Gravity Form where users can pick and choose between 7 different types of donation options, each of which will ultimately get converted to line items in Bloomerang. I want to remove any donation “type” they do not select from becoming a line item… those with a value of 0. My logic is telling me to test the value and then create a text field that can be used to build the line items. If the donation is greater than 0, the text will be “dollar amount, ”. If equal to zero, the text field is blank (won’t generate line item). FYI: there are other “hard-coded” fields that need to be included as part of the each line item. The content of each varies so the idea of doing a “split text” to remove a line does not work (unless there is an option to look for the “0” and remove the entire contents of the line regardless of the rest of the content?).

I’ve considered many scenarios but none carry all the way through to my end goal. Any help is greatly appreciated!!!

Hi @MiM-Zap 

Good question.

To help us have true context, please post screenshots with how the data is returned from Gravity Forms.

Hello,

I’ve attached 3 screen shots, I hope they are what you are looking for. One is of the actual gravity form (GF) and includes a sample “donation” item (personalized gold leaf...). There are 7 of these types of donation items that all work the same. The other two attachments are of my Line Itemizer Zap step where I concatenate the data from the 7 to create the line items. There are 3 components to each donation line item:

  • the “Ornament Info”, includes GF fields and some text labels
  • the “Subtotals”, fields pulled directly from GF
  • the “Appeal Hard Coded”, all custom text

Since I do not know what donation items have been selected, I automatically pull them all into Bloomerang where 7 different payment “splits” are created. I would like to eliminate all splits where the subtotal is 0.

My original idea was to test the value of each subtotal and create text “snippets” to eventually create line items. If subtotal is 0, snippet would be “” (essentially blank). If not 0, something like “125, ”. I would concatenate all these snippets to create my line items.

What do you think? Other options?? Thank you so much!

@MiM-Zap 

With the way the data is coming thru from Gravity Forms, it would be best to handle this logic with 1 Code step, altho that is an advanced approach.

I’ll do some “learning”. I used to be a programmer way back when so maybe it won’t be so bad?

Hi there, @MiM-Zap! 👋

Just wanted to pop by and mention that our Code by Zapier actions have a Generate with AI (beta) feature that you could use to help you generate the necessary code:
a9bbf948116cc305f3156d13f49f36c5.png

As it’s a beta feature, it may not be 100% perfect code but hopefully it will give you enough of a starting point at least. You can learn more about using that feature here: Generate a Code step using AI (Beta)

Hope that helps. Would love to know how you get on with this so please do keep us updated with your progress! 😁
 

Terms & Conditions