Skip to main content
Best answer

Integrating Zoho Projects time logs with Google Sheet

  • August 8, 2020
  • 1 reply
  • 76 views

Hello,

Can any one help with the following :

I am creating a zap 

When a new time log is made a new raw in Google sheet containing Log Date, Project Name, Task name, Notes of the log,

Yaa there is a prebuilt but that records either Log creted date or Last modified date, while I want Log date(date on which the user wants to park his hours),

Because there may a possibility that timeltime of yesterday is created today???

Please reply ASAP

Best answer by nicksimard

Hi @M_B!

If that date is not coming through in the data fields from the New Log Time trigger, one workaround would be to add something to the Notes that specifies the desired date. If you’re already using the Notes section for something else you could separate it with something and then use Formatter — Split Text to separate the parts.

Example: 08/08/2020 /// Then my notes are here.

Here’s a quick demo (I typed the note but you would map the Notes field from Zoho Projects):

Hope that helps!

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

1 reply

nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • Answer
  • August 11, 2020

Hi @M_B!

If that date is not coming through in the data fields from the New Log Time trigger, one workaround would be to add something to the Notes that specifies the desired date. If you’re already using the Notes section for something else you could separate it with something and then use Formatter — Split Text to separate the parts.

Example: 08/08/2020 /// Then my notes are here.

Here’s a quick demo (I typed the note but you would map the Notes field from Zoho Projects):

Hope that helps!