Windows 7 Aero Featureshttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-aero-features.html

27 April 2010 a possible slight slow down on performance you can force enable them - Go to Control Panel -> System and Security -> System Click on advanced system settings on the left and then performance settings. Under the visual effects tab you should see that the...

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

Problem creating SSRS report subscriptionshttp://mail.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 we needed to get them working. Custom DataSource Upload the report to the ReportServer. Hover the mouse cursor over it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the left menu Specify a...

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 v_Total + v_LineItemTotal; } // // other actions you want to do after all quotes looped through // } Save your function and click on "Done" to ensure it's all saved in the system. Create the workflow Now go to a the "Design" mode of the report that...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 Function used to receive webhooks from Xero and parse these into data for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the following code: // enter the webhooks key for your app (in...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 Request access to the Shopify store owner as a developer Login to the Client's Shopify Admin as an invited developer Click on "Apps" > Develop Apps > Create an App Give it a name (eg. mycompanyname Zoho OAuth) Set its developer (preferably as the user...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 eBay hosted URL Detailed Step-by-step Add Zoho Creator to your Zoho One Login to Zoho One Go to Settings (cog in top right) Click on Applications i the sidebar Click on the Add Application button Select Creator by clicking the Add button below it Link...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 We have an Accounts module which holds all the companies we deal with in our Zoho CRM. I want our sales team to be able to click on a button off the CRM account record which will call an API returning all the credit information about a company....

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

Windows 7: System Clock is constantly going out of synchttp://mail.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time settings link Click on the tab Internet Time Click on the...

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

Administrator Program Shortcut without Prompthttp://mail.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 incessantly and never manage to do what you want them to do. What? I want to create a desktop shortcut that I can double-click and it will run the above programs in administrator mode without confirmation by the Windows operating system. At home this...

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

Display Feeds to major Social Networkshttp://mail.joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 Will update this if ever a free method for embedding the page comes up. Go to Instagram and open the video/picture to embed Click the 3 dots (ellipsis) at the bottom right of the description. Click Embed From the box that appears, Copy & Paste the code...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttp://mail.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: *

ZohoCRM: Template: not being able to edit a text boxhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 I'm going to list step by step but using the "Google Chrome" web browser: Login to ZohoCRM > Setup > Templates > Inventory Click on the name of the problematic template to enter a Preview Edit mode (not the pencil icon) Click on the clone icon (just...

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

Zoho CRM: Change System Field Lengthhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 page, mapping it, and then testing by converting a lead to a deal. Actions Login to ZohoCRM > Setup > Modules and Fields Click on the "Deals" module (or whichever module you are wanting to edit) > and select the layout (eg. "Standard") Click on the...

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

Making a CD copy with only one drivehttp://mail.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 is a minimum of a CD Writer and you want to make a copy of a CD. Insert original CD in the drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER Right-click on the CD drive and select OPEN Go to EDIT > SELECT ALL >...

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

Windows Live Messenger: Error 80048820http://mail.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 desktop gadgets except the CPU monitor and your analogue clock. Make sure your computer is connected to the Internet Left-Click once on the clock on your taskbar Click on Change date and time settings link Click on the tab Internet Time Click on the...

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

Excel PivotTable Filter List Orderinghttp://mail.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all available values listed. The Problem The values are listed in alphabetical order...

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

Zoho Deluge: Search Records with Special Characters (COQL)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 elsewhere on my website, but to use in an invokeUrl here's a quick overview: ZohoCRM > Setup > Developer Space > Connections Click on Get Started / Add New Connection Click on the "Zoho OAuth" icon Enter a Connection name (for this example I will call...

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

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 along with the instructions “please enable the host (https://127.0.0.1:5000) in a new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. This message is somewhat out of date but follow the following instructions to...

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

Zoho CRM: Standard Setup for Tax Rateshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 to Setup > Customization > Modules and Fields Hover the mouse cursor over the "Products" module and then over the ellipsis Click on "Customize Tax Rates" For our clients in the UK, we tend to specify the tax rates as "Standard Tax" @ 20% and a "Zero...

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

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

12 January 2022 readily available to ZohoCRM. How? Well, let's setup the FTP connection first in Zoho Analytics: Login to Zoho Analytics Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: Type FTP in the filter field in the...

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