Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 calculated score and results from Analytics into the corresponding Zoho CRM record. Inputs: String crmAPIRequest Outputs: - Date Created: 2025-09-19 (Joel Lipman) - Initial release - Identifies a survey by email Date Modified: 2025-10-06 (Joel Lipman)...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 "TBC" so that the the naming of the invoice can happen on save Maps other fields to fill in the blanks Inputs: - Outputs: - Date Created: 2025-10-07 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information:...

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

SSRS Expand specific drilldown by defaulthttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-expand-specific-drilldown-by-default.html

23 February 2011 particular week. When I open the report, each drilldown row is collapsed (as opposed to expanded). The user can specify the date as it's a report parameter. What we want The user will select a date. We want the report to open with the specified day...

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

Convert seconds to total time in PHPhttps://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 This is intended for activity/session durations and although I usually get MySQL to do the date/time calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc ) FROM Person_Staff ps -- In oracle, yields "missing parenthesis" error. So you can see my parentheses are fine. Working...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Zoho Deluge: Check Time Booking Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time: req_StartTime = input.Date_Field; req_Duration =...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 "tasklist_id": 78901234567890130, "person_responsible": "20211234567", "duration": "1", "duration_type": "hrs", "start_date": "11-12-2021", "end_date": "12-12-2021", "percent_complete": "0", "order_sequence": "4", "priority": "None", "custom_fields":...

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

Disclaimerhttps://www.joellipman.com/static-items/disclaimer.html

30 May 2009 purposes only. The information is provided by Joel Lipman .Com and while we endeavour to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy,...

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

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

08 March 2010 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 Change Settings button Check the box next to Synchronize...

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

Run commands for Windowshttps://www.joellipman.com/articles/microsoft/windows-os/run-commands-for-windows.html

05 July 2011 (if installed) acrodist Adobe ImageReady (if installed) imageready Adobe Photoshop (if installed) photoshop Automatic Updates wuaucpl.cpl Bluetooth Transfer Wizard fsquirt Calculator calc Certificate Manager certmgr.msc Character Map charmap Check Disk...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 Const ICC_HOTKEY_CLASS = $00000040 Const ICC_ANIMATE_CLASS = $00000080 Const ICC_WIN95_CLASSES = $000000FF Const ICC_DATE_CLASSES = $00000100 Const ICC_USEREX_CLASSES = $00000200 Const ICC_COOL_CLASSES = $00000400 Const ICC_INTERNET_CLASSES = $00000800...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report finished running? Need to check what finished?...

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

Importing Joomla articles to WordPress postshttps://www.joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

16 August 2011 INSERT INTO my_wordpress_db.wp_posts SELECT id 'ID', 1 'post_author', created 'post_date', created 'post_date_gmt', CONCAT(introtext, ' ', `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft'...

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

Basic Oracle Stored Procedure Structurehttps://www.joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 -------------------------------------------------------------------------------- STUDENTID STUDENT_USERNAME STUDENT_CREATION_DATE STUDENT_FILE ---------- ----------------- ---------------------- ---------------------------- 1234567 jsmith2012 08-MAY-12...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Search a database with SOUNDEXhttps://www.joellipman.com/articles/database/search-a-database-with-soundex.html

11 October 2012 ** ****************************************************************************************************************** ** Date: By: Rev: Desc: ** **...

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

Stored Procedure to List Distinct Values and Countshttps://www.joellipman.com/articles/database/t-sql/stored-procedure-to-list-distinct-values-and-counts.html

26 October 2012 ** ****************************************************************************************************************** ** Date: By: Rev: Desc: ** **...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 ** Change History: ** ************************************************************************************ ** Date: By: Rev: Desc: ** ** ------------------------------------------------------------------------------ ** ** 29/10/2012 Jlipman 1.0 Created...

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

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

03 April 2009 meet all of these conditions: a) The work must carry prominent notices stating that you modified it, and giving a relevant date. b) The work must carry prominent notices stating that it is released under this License and any conditions added under...

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

Quickly update all content in mySQL database replacing a stringhttps://www.joellipman.com/articles/database/mysql/quickly-update-all-content-replacing-a-string.html

03 February 2013 an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin that would replace my HTML tags with . Not I want to switch these...

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

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore database in use Cannot drop database because it is currently in use...

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