Assuming often is required, the following 37 results were found.
-
A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Inventory Level Update notification Note that this one is not the "Inventory Item Update" as I get the two muddled up very often and they don't do the same thing. We want this triggered whenever the stock level of a product changes. /*...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
is losing time because of a system clock problem. A workaround in this instance is to change the NTP client to update more often. Note: The following process requires administrator (installation) rights on your computer. Open regedit.exe through the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
great resource for learning Javascript. In the image above, note the document object - you will be using this object quite often. To access the Webpage, you will need to navigate through the HTML DOM. Here are some simple ways to do this: Object Name &...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
me to reduce the risk of nasty surprises and also allows me not have to Google search every solution. As an IT developer, I often get told I may win the lottery or get run over by a bus, so I am used to needing a backup plan. My aim is always to hand...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
have proposed stupid extensive solutions when all you need is one command-line. Why? Working with programming languages, I often need to write the accompanying documentation. Within the documentation, I may want to refer to a line of code within a text...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
perform this operation This is a quick issue to resolve as it may be incorrect scopes specified but in my case is more than often the wrong accounts server: v_DataEndpoint = "https://books.zoho.com/api/v3/contacts?organization_id=123456789"; r_Response...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
I have had this working with the 2 CNAME records though. Some providers say this will take between 24-48 hours but I have often found that after a few hours, the effects have been propagated. A test I like to do is open the command-line in MS-Windows or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ "-" + r_LeadDetails.get("Created_Time").subString(8,10); // // parse date into yyyy-MM-dd (using toString - often works) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").toString("yyyy-MM-dd"); // // parse time into HH:mm:ss v_LeadCreatedTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
an image to be downloaded, then uploaded to the Zoho Inventory or Zoho Books item record. Well I don't want to research this often so here's the quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
design should go in the other direction, as in enter the products in Zoho Inventory and this feeds the website. More than often, however, this request comes in when the customer has already been setting their Zoho environment up and the Wordpress site...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... } isBlank() can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
use cases, but is useful to be aware of if you have not come across it before. Why? In many Deluge scripts, assignments are often more than a single value. At times, it can be useful to copy and paste or temporarily format logic across multiple lines to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
are interesting but as with a lot of showroom demo sites, "the picture that came with the picture frame you bought can often be nicer than the picture you put in". i.e. it's a showroom and you've got to complement the template with your own visuals. Had...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Calculating Percentagehttps://joellipman.com/articles/else/e-commerce/calculating-percentage.html
I need to often be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
Data Flow task to stop running. There may be error messages posted before this with more information about the failure. -- often when processing a datasource, the function is being applied to a NULL date timestamp. Dealing with Date NULLs: Fix: Put...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB