Zoho CRM: Upload a Product Photo using Delugehttp://www.joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 A quick article to remind me on how to upload a photo using CRM API v2. Yes it's documented and yes it still confuses me now and again. So I'm writing this to remind me and to keep reminding me of how to do this. Why? My use-case is that I have a photo...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Display Sales Order Shipping Address on Package Sliphttp://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 I probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Get Unique Values of a Text Fieldhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator / Shopify: Get all Active Productshttp://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search Shopify using a Product SKU. Community forums could only suggest...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Generate List of TimeZoneshttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has to go to the CRM record, click on Mail Merge, which opens...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Change Radio into Tabshttp://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Splatter Logohttp://www.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 I saw this article and rather than bookmark it I thought I could just have it here for easy reference. It was written for Photoshop but I use Paint Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

After installing rokstories, get invalid argument 106http://www.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 After I installed the rokstories module from www.rockettheme.com, if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Copy Subform to other Subformshttp://www.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 A quick article on a snippet of code which copies one subform to other subforms in the same form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Increment a column in MySQL using the UPDATE queryhttp://www.joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Zoho CRM: Schedule a Call using Delugehttp://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to figure out so I don't spend so long the next time I have to do it....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Schedule a Task: Timesheet Reminderhttp://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator/Deluge: Calculating with Timezone Offsethttp://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Calculate start and end of Daylight Savings Timehttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)http://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)http://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both for outbound and inbound but local to the customer and we want...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Setup DataSource via FTP Connectionhttp://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: eBay: Get Item Transactionhttp://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you can use the following code, note that the parameter is the eBay Item ID: void...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *