Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 Admin interface, then the following code won't be able to check and restore them. The Code Snippets: The Shopify Order Update notification First create a CRM function called Shopify - Webhook - Order Notification. It's a standalone function but you'll...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 type change Purpose: Prepares the invoice as a deposit invoice or final balance invoice Inputs: string value Outputs: - Date Created: 2025-03-31 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Any information that may help...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 by a client script to retrieve the pipeline given a deal record id Inputs: Deal Record ID Outputs: the value of the pipeline Date Created: 2025-05-06 (Joel Lipman) - Initial release Date Modified: ??? - ???...

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

ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

16 October 2025 you can see "Automatic Import" then selecting this will run you through setting up the connection again. If you can see "Update Credentials" then selecting this should also run you through setting up the connection again (never seen this option myself)....

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/component/content/article/report-builder-20-hide-series1.html?catid=75&Itemid=165

06 May 2010 Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from appearing in your...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

13 December 2010 entered via the browser useragent (VisitorUAgent), the User ID (VisitorID, 0 if not logged in) and of course the Timestamp (DateTimeStamp). Here is a page of some MySQL queries I can do based on just those 5 columns: MediaWiki: number of unique guests,...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/cms/website-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 me if I ever work for a company using SITS:Vision again. How? For demonstration purposes, I'm going to create a table update process (TUP) based around a change in the course application details. Some of the screenshots are censored for confidentiality...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/cms/website-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? 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...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 the file and some other fields Owner Email (type: Email) FIle Name (type: Single Line) File Ref (type: Single Line) Expiry Date Time (type: Date-Time) File Download (type: File upload) Create a connection in the Creator app with the scope:...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 Function: fn_eBayQuery_GetNotificationPreferences() Purpose: Retrieves the requesting application's notification preferences Date Created: 2021-09-20 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

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

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

18 November 2021 // // customer is in (America/Los_Angeles) v_CustomerCallTime = '2021-11-19 08:12:34'; // // set system/application date time start in CRM format v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") +...

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

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

16 December 2021 Module is "Calls" Rule Name can be whatever you want, I'm calling mine "Calls - Send SMS Reminder 1 Hr Before" When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is...

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

Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 call for order (sales) management. /* Function: fn_GetEbayOrders() Purpose: Queries eBay for all orders for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 People Login to ZohoPeople as a system administrator Click on the cog icon in the top right to go to the setup screen. Update 2025: Click on "Employee Information" > "Automation" > "Schedulers" > "Custom Schedulers" Pre Zoho People v5: Under...

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

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/else/app-dev/android-os/android-replace-return-key-with-done-go-send.html

03 November 2014 will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date // selectable date time // selectable time android:imeOptions normal actionUnspecified...

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

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

28 January 2010 The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/else/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 same table. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination wanted 1 row per day. This meant...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/component/content/article/excel-pivottable-filter-list-ordering.html?catid=110&Itemid=165

05 September 2011 Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in yyyy-mm-dd format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want it sorted in...

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