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.

Question

Time-tracking records in Zoho Analytics are being duplicated instead of updated

M

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.

Hello,

Just wondering if I could get some advice. I’ve created a Zap with the purpose of tracking the time people on our team spend on individual tasks. The data is pulled from Monday.com when someone edits the time_tracking variable and a new row is added to a data sheet in Zoho analytics. The issue I’m having is that there will be duplicates of time made instead of updating the already existing time. I have tried to use “update row” instead, but it updates the entire column to all be the same task with the same time and just multiple version of it. 

 

I’ve attached screenshots for reference, any help would be appreciated. I’m new to automation.

 

Monday Trigger
​​​​​
What happens in Zoho

So in this example you can see it’s created Webinar/Morning Tea Data twice and I’m not sure why. Does anyone have any ideas on how I could work around this?

Did this topic help you find an answer to your question?

5 replies

jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @MCW Digital Marketing ,

 

Is this happening with all the tasks?

M
1 person likes this
  • M
    MCW Digital Marketing
Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • November 8, 2022

Hi @MCW Digital Marketing, welcome to the community!

The Monday doesn’t have a way of knowing if a column has previously triggered the Zap so it will cause a Zap to fire multiple times if the same column value is changed more than once. In terms of what’s happening on the Zoho Analytics side, it looks like a Find or create row would have helped you here; search for an existing row and if none are found then create a new one. That isn’t currently possible with the Zoho Analytics integration but we do have a feature request for that addition. I’ve added you as an interested user on that feature request, which lets the Zoho team know how many users would like to see it implement. I can’t say when/if the feature will be added and I did take a look at some information on Zoho’s side and I don’t think it’s currently possible for this feature to be built. I’m sorry about that. 

 

In terms of a workaround, what you would need to do is to find a way to tell the Zap whether the same column is updated twice. There are a couple of ways to do this, and this article outlines how they work: How to stop duplicate triggers from running your Zap

 

I hope that helps, let us know if you have any questions!

M
1 person likes this
  • M
    MCW Digital Marketing
jayeshkumarbhatia
Forum|alt.badge.img+6

Hey @MCW Digital Marketing ,

 

I am trying to solve your problem and i have a query, When you select Update a row action, do you see an input field update all rows?

 

 

M
1 person likes this
  • M
    MCW Digital Marketing
M
jayeshkumarbhatia wrote:

Hey @MCW Digital Marketing ,

 

I am trying to solve your problem and i have a query, When you select Update a row action, do you see an input field update all rows?

 

 

Hello Jayeshkumarbhatia, 

 

I see “Update existing row in Zoho Analytics table” and in the setup action it asks me for the Zoho criteria. Would it be possible to Zap the data with a google sheet, and then from the google sheet zap it to Zoho? I appreciate you assisting with the problem heaps.

shalgrim
Forum|alt.badge.img+8
  • shalgrimZapier Staff
  • Zapier Staff
  • 406 replies
  • November 15, 2022

It’s hard to tell exactly what’s going on here since the screenshots show the Add Row action instead of the Update Row action.

The help text for the Criteria field on the Update Row action says

Enter the criteria based on which rows must be updated. If no value is entered in this field, all rows will be updated. Learn more about how to construct criteria: https://www.zoho.com/analytics/api/#applying-filter-criteria

 

Rows will always be added if using the Add Row action, as far as I can tell. If duplicates are added with the Update Row action, then it’s possible the Criteria isn’t set up correctly.

I believe you’d want your Criteria to be something like:

“Task” = ‘mapped_field_goes-here’ AND “Type” = ‘other_mapped_field_goes_here’

Though keep in mind you’d never be able to have more than one row with the same Task and Type as shown here: https://cdn.zappy.app/6e0b85de13d8fc8f92254aafefc33375.png

Reply


Terms & Conditions