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.

Question

Unmapped fields seem to be deleting information already in a cell on a spreadsheet...

  • 26 September 2023
  • 5 replies
  • 30 views
S

I have a Google Sheet that contains formulas in some of the columns.  When creating a zap to pull information into this spreadsheet and I have purposely not mapped the these fields and left them blank to ensure the formulas already in those cells remain and can work once the information in other fields is populated by the zap.  However, by not mapping these fields it is still overwriting the formulas by overwriting them with no information.  Almost as if by not mapping the field its inputting a blank which overwrites the information already there if that makes sense.

 

Has anyone else come across this?

5 replies

ken.a
Userlevel 7
Badge +6

Hi there @Sarah - ACH,

Welcome to the Community! 🎉

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please send a screenshot of the “Action” section of the Zap that shows all of its fields. Here’s an example screenshot:


46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks! 😊

S

Thanks Ken - I hope these screenshots help 😊

There are quite a lot of mapped fields but the ones I have not mapped are the ones relating to Engineers and the telephone numbers.  Those columns in the spreadsheet contain formulas but this zap is adding a blank response in cells for those columns and overwriting the formulas in the spreadsheet.  It would be great if I could tell it not to map these if possible.

 

MohSwellam
Userlevel 7
Badge +8

Hi @Sarah - ACH 

 

To be clear, in Google Sheets the formula does not apply on empty rows or any newly created row UNLESS you drag the formula all the way down in the sheet. This is why I would suggest you use something more advanced like Airtable to do something like this. Unlike Google Sheets, Airtable formula fields will apply to the full column (field). 

 

That being said, try one of the following: 

 

  1. Drag the formula all the way down in the sheet. 
  2. Recreate the formula in the cell in Zapier. You would write it as you would write it inside Google Sheets.
Founder of GeekyAir.com
S

Thank you for this - I had already done this in Google Sheets and dragged the formula all the way down in the sheet. 

I’m not sure if it would work by recreating the formula in the cell in Zapier. Obviously when I drag the formula down through the Google Sheet it automatically updates formula so it looks at the correct cell in the correct row but if I put the formula in Zapier wouldn’t it be a repetitive formula.

Not sure if I’ve explained myself very well 🤣

MohSwellam
Userlevel 7
Badge +8

Yes I understand dont worry 😃

 

Well, regarding the formula, you wouldnt type the column id in Google Sheets, you would actually do it with the values you are receiving in the Zap. 
 

Another solution would be to use another step to Update the row after it is created with the formula 

Founder of GeekyAir.com

Reply


Terms & Conditions