Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent to the end user, and when they finish signing it, it attaches automatically back on to the record?... It is...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 developers coming to the platform must subscribe to or opt out of eBay marketplace account deletion/closure notifications before they make their first API call. Once the new developer's application is subscribed to eBay marketplace account...

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

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

01 April 2025 the output from the function var o_ParsedQuote = JSON.parse(JSON.stringify(r_QuotedRecord)); // valid? note the underscore before the details variable a_QuotedItems = []; if (o_ParsedQuote._code == "SUCCESS") { if (o_ParsedQuote._details !== undefined)...

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

ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 { b_CreateAccount = false; v_CrmAccountID = m_SearchAccount.get("id"); // // if sync'd before then let's use that date/time d_CrmAccountLastUpdated = ifnull(m_SearchAccount.get("Xero_Updated"),zoho.currenttime).toString("yyyy-MM-dd...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 { b_CreateAccount = false; v_CrmAccountID = m_SearchAccount.get("id"); // // if sync'd before then let's use that date/time d_CrmAccountLastUpdated = ifnull(m_SearchAccount.get("Xero_Updated"),zoho.currenttime).toString("yyyy-MM-dd...

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

SSRS - Lost window with datasetshttps://joellipman.com/articles/microsoft/ssrs/ssrs-lost-window-with-datasets.html

25 March 2011 for the Report Data containing the parameters and datasets isn't there. I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report data" and it's right at the bottom...

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

The greatest invention in IThttps://joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 and as everlasting as human error. More? "By [undoing] repeatedly, you can gradually work your way back to a point before your mistake. This is convenient if you've made a mistake four or five commands back. It is marginally useful if you've made a...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Trim in T-SQL and SSIShttps://joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 1 Joel Lipman 2 JOE THE GREATEST DECLARE @EmployeeStr = 'JOE ' + CHAR(9) + CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE' -- yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM Employees WHERE...

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