I’m trying to push the Time Estimate value from ClickUp as a Time Entry on Quickbooks online.
Zapier retrieves it in miliseconds so i customized a formula that returns the valie in the HH:MM format QB requieres. However, Zapier retrieves the formula, not the value.
Any idea how I can capture that value?
Best answer by paches86View original
@paches86! Thanks so much for swinging back in and letting us know what you figured out. Sounds like this one was not apparent or obvious in the least, so I hope this helps another QBO user in the future.
Exactly the reasoh I left all the steps in my comment 😉
Ok so I figure this out. At least to achieve what I needed which is to bring a HH:MM value format to QBO.
I just used zapper formatting and utilities to split the hours and the minutes and formatting.
@paches86! I’m wondering if there’s an issue in how you’ve formatted your formula and the editor thinks you’ve inserted text. Mind posting up a screenshot for us to take a look at? Please be sure to not include any personal information like addresses, e-mails, or phone numbers in the screenshot.