Skip to main content

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

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!