ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 workdrive and returns the public link Date Modified: ??? - ??? ttps://workdrive.zoho.com/apidocs/v1/filefoldersharing/shareeveryone ******************************************************************************* */ // // Go create a folder in workdrive,...

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

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 field mandatory. Why? Because for some reason, it wouldn't appear as selectable when I tried using a layout rule. Probably everyone else has figured this out and I'm just late to the party. How? Through the wonders of Zoho CRM Client Script. So we're...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 than flaming, because it also hurts other members of the board who fall into the catagory you insult. TEU is a place where everyone is equal, and discrimination will NOT be tolerated! No Bullying - Do not pick on other members. The worst kind of...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

How To Make Chocolate Chip Cookieshttps://www.joellipman.com/articles/_other-misc/how-to-make-chocolate-chip-cookies.html

30 September 2009 Everyone loves chocolate chip cookies, and with VideoJug's special recipe, it's easy to make the perfect chocolate chip cookie every time. You Will Need: 150 g sugar 160 g brown sugar, , packed 220 g butter 2 eggs, , large 2 tsp vanilla extract 280 g...

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

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 for your weblinks (eg. "Helpful Links") Set the "quicklist weblinks" module to view this category. This will be the one everyone sees. Create a copy of the "quicklist weblinks" module Set the permissions to view this new module as "Super Users" or...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 format please cos unix will take my server's one). --- Enable Captcha to download? --- Specify News category (to tell everyone about your new projects) --- Specify high download rate or total downloads as "HOT" --- Specify number of days a file is "NEW"...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 (despite knowing what they are). Searches that got me nowhere Well not entirely true, there were solutions and tidbits but everyone had a different setup to us and their solutions were complex coding solutions and ultimately the wrong route as we worked...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 outline how to apply this to an SSRS 2008 R2 report. How? If you've googled this topic as much as I have, you'll note that everyone seems to be recommending using a cursor. I went through about 10 pages of google results without working out how to use...

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

Copy a table with structure and data into a temporary tablehttps://www.joellipman.com/articles/database/t-sql/copy-a-table-with-structure-and-data-into-a-temporary-table.html

03 August 2012 a given table into a temporary table all the while maintaining the structure and data. Thinking inside of the box I think everyone suggests the following (or at least the idea of): SELECT * INTO #MyTempTable FROM @GivenTable If @GivenTable is a...

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

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://www.joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 when following other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had access to the SharePoint site... It doesn't. The following steps show you how SharePoint will open a shared...

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

Licence GNU/GPLhttps://www.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 GENERAL PUBLIC LICENSE Version 3, 29 June 2007 Copyright © 2007 Free Software Foundation, Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The GNU General Public License...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connecthttps://www.joellipman.com/articles/database/mysql/mysqldump-got-error-2049-connection-using-old-pre-4-1-1-authentication-protocol-refused-client-option-secure-auth-enabled-when-trying-to-connect.html

28 July 2014 old authentication protocol). The error ONLY appears when I try to "data export" the database. Why? The quick solution for everyone else is to change/reset the password of the connecting database user, but herein lies the problem. When you read my...

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

Sort an associative array by values in Javascripthttps://www.joellipman.com/articles/web-development/js/sort-an-associative-array-by-values-in-javascript.html

29 September 2015 An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...

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

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

25 January 2022 address) Once it looks like you want, click on the "Save" then "Save Now" button in the top right of your CRM. Done... get everyone involved to check they see the change as well... Inspect page Elements in Chrome (method #2) Open Google Chrome Browse to...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 So let's say there's a schedule that has to be run weekly and include all the orders of a specific week... Just to confuse everyone in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday...

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

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

22 April 2024 the payload. Same with responding with the variable crmAPIResponse. Don't overthink it, just accept it. Less headaches for everyone. Source(s): Shopify Dev - REST API - Retrieves a list of webhooks Shopify Dev - REST API - List of Webhook event topics...

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

ZohoCRM: Make either Mobile or Email mandatoryhttps://www.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 being used in a rule. Seems that I can't select the same field in a third layout rule... Easy without coding and probably everyone figures this one out but I thought I'd add it here as I thought it was pretty cool.

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

How to use download managers with Google Chromehttps://www.joellipman.com/articles/google/how-to-use-download-managers-with-google-chrome.html

19 September 2009 Apparently everyone knows how to download FLV videos from web addresses which use the Youtube syntax: http://www.youtube.com/watch?v= Using the bookmark feature: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...

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