I’d like to know if this was possible in Zapier and if so, where best to start.
We use Harvest for timesheets that are integrated with Zendesk. So when staff submit their timesheet, each line in their timesheet should a comment referencing a ticket. Sometimes they don’t
e.g Date Hrs Comments
3/5/21 1.0hr <blank>
4/5/21 1.5hr #12345:This is a ticket and good for billing
6/5/21 2 hr some comment - without a ticket, it may be queried.
- When the harvest user submit their timesheet, the data would also be submitted to Zapier for validation
- In the above case, timesheet entries on 3/5/21 and 6/5/21 do not contain a ticket reference as the first character of the comment does not equal to: “#”
- It would send an email to the harvest user requesting them to review ticket reference on 3/5/21 and 6/5/21/
I don’t there is currently a trigger when harvest timesheets are submitted.(Step 1)
I don’t know where to start with validating the data (Step 2)
Sending the email (Step 3) would be the easy part.