Assuming hour is required, the following 45 results were found.
-
A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry of an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
list as well as to display empty custom related lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the documentation and get a working solution. How? So the article below shows how to do this Zoho CRM and how...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
being returned for API names... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2 schedules: one that runs on even hours and one that runs on odd hours to change this to every hour. It's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to mark a package as shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document for future use. The use-case is the client has their own delivery drivers and want them to mark a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
:= "Success_" v_ProcessID v_FileName_Prep := "Prep_" v_ProcessID ; to be set on setup (leave blank) v_TotalHours := 0 v_YourProfile := "" v_YourEmail := "" v_YourBrowser := "" v_YourName := "" v_Message := "" v_YourDate := A_Year "-" A_MM "-" A_DD...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
include:one.zoho.eu ~all Check using the toolkit: Some registrars will say this can take between 24 to 72 hours to propagate. In our cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
How? Based on the fact that the United Kingdom is on the Prime Meridian and when no daylight savings are in effect, the hour difference to UTC (Coordinated Universal Time) should be zero, then for checking if daylight savings is in effect in the UK, we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
message :v_DebugMessage ] } return ""; Related List for Custom Module Just for good measure (and because it took me an hour to write this), here's the code to generate a related list on a custom module to the related ZohoSign Documents in ZohoCRM: /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
take just a few minutes..." I've written this because I spent all night on setting up a "quick" demo resulting in a quick 1 hour nap before having to go to my day job... It sounds straight forward because both phpBB3 and RocketTheme talk about how to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Just noted this down in case I need to do it again. This article documents how to take a 5.5 hour video (MP4) and have it transcribed by a locally installed AI on a MacOS (running Sequoia 15.1.1). Why? Needed for training videos as a follow-on from my...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
clean house, tidy up, vacuum clean, vacuum cleaning code: learn to code, coding time, hackathon, Rails Girls, Railsgirls, Hour of Code, Codecademy, Computer Science, Programming in Python, Web Programming, Programming in Java, Web Development coffee:...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: *
-
the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse MSDN for an hour before I realised all those experts were using programming solutions that seemed a bit over the top for something that...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile of useless info, at least I'm not just copying and pasting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a query at report execution time and populates/assigns the local variable ID (@StudentReference) everytime. So after an hour or so I came across "Cascading Parameters" (http://technet.microsoft.com/en-us/library/dd255197.aspx). Maybe the answer could be...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
(dd/mm/yyyy) DATE_FORMAT(now(), '%d/%m/%Y') CONVERT(varchar, getdate(), 103) Time to Seconds TIME_TO_SEC(now()) (DATEPART(hour, getdate()) * 3600) + (DATEPART(minute, getdate()) * 60) + (DATEPART(second, getdate())) Seconds to Time SEC_TO_TIME( seconds...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query: CASE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
after that every page load is a few hundred to few thousand queries (per page). The webserver limits me to 50,000 queries an hour and I am blowing past that quickly with just 1 person (me!) on the site so they just refuse the connnection after a while....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB