Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 ]; info r_AddTags; } } } /* {"code":"INVALID_DATA","details":{"api_name":"id","json_path":"$.tags[0].id"},"message":"invalid tag id","status":"error"} -> Error was due to trying to assign map with removed key to a new map. -> Solution was to remove the...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 api_name:'data'... But this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data" }, "message":"invalid data", "status":"error" } How? I recall covering this solution before but it boils simply down to the...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer with the to email address, bcc, subject and message content already populated. How? The example from the Kaizen series uses a record with canvas mode applied; but I wanted to...

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

How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 = ‘index.php?option=com_contact&task=view&contact_id=’. $contact[0]->id .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE ) replace that code with the URL for the contact Thank-you page as defined as follows: $link = sefRelToAbs(...

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

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 with this allergy?" PLG_USER_PROFILE5_FIELD_ALLERGYTIME_LABEL="Time With Allergy?" PLG_USER_PROFILE_FIELD_ALLERGYTIME_MESSAGE="Select one of the options" PLG_USER_PROFILE5_XML_DESCRIPTION="User Profile - JoelLipman.Com Plugin"...

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

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

05 July 2011 disappearing and reappearing, the content is what I don't want to lose. ;// ;// Win32 Constants ;// ;#region Peek Message Flags Const PM_NOREMOVE = 0 Const PM_REMOVE = 1 Const PM_NOYIELD = 2 ;#End Region ;#Region Windows Messages Const WM_NULL = $0000...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 will be based on (and can be used with) the Search Forum webPage. Our first example will use the alert() method to pop-up a message box that says Hello World! Simply put this javascript in your URL Address bar and hit enter: Code: javascript:...

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

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

02 September 2011 (:) we expected for Oracle. Passing in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 rows if there are no matches (not a blank row either) as one of my reports uses a row counter to display a "No data found" message when no rows are returned. This does not affect the above problem as the stored procedure simply fails and discontinues...

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

Print Directory Contents to a Filehttps://www.joellipman.com/articles/microsoft/windows-os/print-directory-contents-to-a-file.html

19 July 2012 I could have used %Comspec% or even %windir%\system32\cmd.exe but with some group policies, you will get an "access denied" message. If you don't have a C:\windows folder, then find your "cmd.exe" program and change the path in the above instructions...

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

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

08 March 2013 page. From the Restrict Access option, select Single. If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes. Restoring in SSMS, Right-click on the...

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932)....

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

Change the default Joomla Error templatehttps://www.joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

04 April 2013 Backup the file \templates\system\error.php Create a replacement file called error.php including the below code Change the message "The Page you are looking for..." to what you want. Change the link "www.joellipman.com" to the "www.yoursitename.com"....

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 OR @GivenDOB = '') AND (@GivenRef'' OR @GivenForenames'' OR @GivenSurname'' OR @GivenDOB'') For usability, we put a message just below the header which was an expression detailing what the report was displaying, so for example: -- If setting the limit...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 Pictures\Win7_ScrSvr\BU_Core_CMYKportraitbigwithborder.jpg" ; Default Message reference ThisMessageIndex:=0 ;...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 XSLT but watch your datatypes Notes: We did not find a way to return the code when the lookup failed, only an alternative message "*LookupFailed*".

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Convert XML UTF-16 to JSON UTF-8 with PHP cURLhttps://www.joellipman.com/articles/web-development/php/convert-xml-utf-16-to-json-utf-8-with-php-curl.html

28 March 2015 curl_setopt($ch, CURLOPT_POST, TRUE); // TRUE to do a regular HTTP POST. curl_setopt($ch, CURLOPT_POSTFIELDS, $api_message_xml); // In my case, the XML form that will be submitted curl_setopt($ch, CURLOPT_TIMEOUT, 15); // Target API has a 15 second...

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

CSS Add Text to Breadcrumb Link with a Transitionhttps://www.joellipman.com/articles/web-development/css/css-add-text-to-breadcrumb-link-with-a-transition.html

18 May 2019 is not a smooth one. If anyone has a tried and working solution to the width transition then feel free to comment/message me (please test before sending it to me as I'm aware of width transitions for div layers). DEMO: See my JsFiddle...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

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

24 October 2020 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 preview your app: Open a browser and Ensure you type the preceding “https”...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 before going Live. sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While still on the CRM functions page, hover your mouse over the...

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