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

06 August 2024 Click on "Send for Zoho Sign" Select the template document or upload one Add the fields that you will complete, and the ones that other recipients will complete Send it for your end-user to complete and sign it This comes back to a section called...

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

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

09 October 2025 m_ZohoTaxRates = r_ZohoTaxRates.toMap(); if(b_Debug) { info m_ZohoTaxRates; } // // server timezones v_XeroTimeZone = "Europe/London"; v_ZohoTimeZone = "Europe/London"; // // enter the CRM record ID of your integrations record (Xero Integration API)...

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

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

13 October 2025 Label: Fn - Xero - Map Tax Rates Trigger: Standalone / On-Demand Purpose: Function used to map Xero tax rates to Zoho ones Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure...

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

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 the feed was using. TBC Caveat(s): Refreshing the feed means that duplicates will be created. You will need to delete the ones manually imported in order for the numbers to be brought in line. Notes and findings: Integration locks: The “Accounts...

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

Deserialization and cannot checkout files in TFShttp://mail.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who can't remember, then it can take a while. How? Open the solution file Select any...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

DJI Phantom FC40 - First Flighthttp://mail.joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-first-flight.html

28 August 2014 to transfer my Joomla videos over to but in the meantime you can be subjected to my quadcopter videos. Here are a few quick ones, the Hubsan H107C and its Q4 Nano, then the DJI Phantom. First up, the Hubsan X4 H107C for $60 USD filming at a reduced...

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

VBScript to retrieve Windows Product Keyhttp://mail.joellipman.com/articles/microsoft/windows-os/vbscript-to-retrieve-windows-product-key.html

23 September 2015 retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example applicable to Windows 7 Professional....

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

SELECT COUNT(DISTINCT name) FROM tablehttp://mail.joellipman.com/articles/cms/joomla/select-count-distinct-name-from-table.html

24 September 2015 my_field FROM my_table) T1; -- Performance Improvement SELECT COUNT(1) FROM (SELECT DISTINCT my_field FROM my_table) T1; Ones that didn't work for me: Method #3: By grouping (NOT recommended for more complex queries): SELECT COUNT(my_field) FROM...

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