Best answer

Integrating Zoho Projects time logs with Google Sheet

  • 8 August 2020
  • 1 reply
  • 40 views

Userlevel 1

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

icon

Best answer by nicksimard 12 August 2020, 01:26

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!

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +10

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!