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.

  • Home
  • Get Help
  • How Do I
  • How do I configure a Zap to add new lines without overwriting subform entries in Zoho CRM?
Question

How do I configure a Zap to add new lines without overwriting subform entries in Zoho CRM?

  • 23 June 2023
  • 3 replies
  • 81 views
LHoFT

 

Hello

We have created a Zap that connects a Gravity Forms web form with Zoho CRM.
The form is a Whitepaper Download form and has the fields name, surname, email and name of the Whitepaper.

This Zap checks if  the contact exists in the CRM.

If the contact exists, update it by adding the name of the Whitepaper to a subform that we have created with the name of the Whitepaper and the date the form was received.


If the contact does not exist, create it as a lead and complete the fields of name, surname, email and complete the field of the form with the name of the Whitepaper and the date.


If we make a submission for a Whitepaper test “Whitepaper 1” it works correctly.
We have the subform with the field completed with the name of the Witepaper: “Whitepaper 1”

 


But what happens if the same contact sends a form for two different Whitepapers? (Whitepaper Test 1 and Whitepaper Test 2)
This is what should appear in the CRM:

We have Whitepaper Test1, from the previous form, and we add a line in the subform with Whitepaper Test 2 and the date.

But what actually what happens is that the Zap overwrites Whitepaper Test 1 with the data and dates of the new Whitepaper Test  2 form and this is what we see in the Subform:

The Zap has deleted Whitepaper Test 1


How can we configure the Zap so that it does not overwrite the lines of the subform in Zoho CRM but adds new lines to the subform?

Thanks!

3 replies

SamB
Rank
Userlevel 7
Badge +11

Hi there, @LHoFT. Welcome to the Community! 🎉

Are the whitepapers themselves separate module entries in Zoho that are being associated with the contact? 

Also, can you please share a screenshot showing what fields and settings have been selected in the Action section of the specific action that is deleting the whitepaper? Asking as that may help us get a better idea of why it’s doing removing the original whitepaper. Please remove/hide any private information (like names, email addresses etc.) from the screenshot before sharing though.

Thanks! 🙂

LHoFT

Hi @SamB !

In Zoho CRM the Whitepaper field is a subform within the Leads module.


On the other hand, we have a form on the website for download the Whitepapers. This form is created in Gravity Forms.

We have connected this form to Zapier and we have created a Zap that fills the subform fields in Zoho CRM.
We do this in Zap by mapping the field of the Whitepaper name form with the Whitepaper name field of the Leads module subform.


The subform in Zoho CRM is a type of field that allows to add multiple rows,

 

so we want that every time a form is submitted and the zap that connects the form to Zoho CRM is launched, a new line is created in the subform.

I hope I could have explained better. Thank you very much for your help!

Regards

SamB
Rank
Userlevel 7
Badge +11

Sorry for the delay in replying here @LHoFT!

Ah I see! Ok, so in those Whitepaper name and Download date fields you’re just recording the form downloads but the existing values are being overwritten by the new values.

Since it’s not appending the new values I think you’ll need to use a Find Module Entry search action to locate the existing values for those fields. Then select both the existing and new values for those fields. For example:

c3f5cc03fc125172739ad0f2989a2880.png

That way the Zap should overwrite the field with the old value and add the new value as well. I’m hoping that will add the new value into a separate row.

If it doesn’t then you may need to turn the old and new values into line items first. You can use a Formatter (Utilities > Line Itemizer (Create/Append/Prepend)) action to do that. Then select those line items in the Whitepaper name and Download date fields. More on how to do that here: Create line items in Zaps

Can you give that a try and let us know how you get on?

Reply


Terms & Conditions