Search - Joel Lipman .Com

1. Call to a member function mark() on a non-object in Joomla CMS: / Joomla /; What? This is a quick note on one reason you may get the above error in a Joomla CMS environment. Call to a member function mark() on a non-object in /public_html/index.php How? Not really ...; Created on 17 November 2013
2. Drop If Object Exists: / Transact-SQL /; ... OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL DROP PROCEDURE [Common].[usp_MyStoredProcedure]; GO -- drop a view if it exists IF OBJECT_ID ( '[Common].[uvw_MyView]', 'V' ) ...; Created on 03 August 2012
3. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... Who_Id (JSON Object or Int): ID of the contact or lead the task is related to. What_Id (JSON Object or Int): ID of the account the contact is associated with. Specify this only when the Who_Id is a ...; Created on 14 May 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; What? This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found ...; Created on 22 April 2024
5. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a ...; Created on 25 March 2024
6. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url ...; Created on 05 December 2023
7. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... :v_PaymentIntentEndpoint type :POST parameters:m_Params headers:m_Headers ]; info "Payment Intent Create"; info r_CreatePaymentIntent; // v_CheckObject = ifnull(r_CreatePaymentIntent.get("object"),"-"); v_CheckAmount ...; Created on 16 March 2023
8. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; What? A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article ...; Created on 13 February 2023
9. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Portrait Photography Sports Photography Street Photography Travel Photography Wedding Photography Manmade Objects Architecture Fine Art Photography Food Photography ...; Created on 11 February 2023
10. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... var json_Row = new Array(); var json_Arg = new Object(); // get some values beforehand which allows us to compare to the rows already present in the subform // first column to add ...; Created on 09 December 2022
11. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... = invokeurl [ url :v_Endpoint type :POST parameters: m_GraphQl.toString() headers:m_Header ]; info r_GetProduct; Awesome! Now for the primary objective of this task, which ...; Created on 14 February 2022
12. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... via Webhook Zoho Creator: Receive JSON via a Shopify Webhook This time, the objective is to have an eBay notification be sent to Zoho CRM (can receive webhooks) which forwards it to Zoho Creator, ...; Created on 21 January 2022
13. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't demonstrate ...; Created on 08 October 2021
14. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
15. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Select namespace (if following this example, it will be "Default") Select function (note that only functions that can receive a list/form object are listed here) The argument name should be disabled/read-only, ...; Created on 06 December 2020
16. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search ...; Created on 28 August 2020
17. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... Return fex } Usage v_MyMediaFile := "C:\Users\Public\Music\Sample Music\Maid with the Flaxen Hair.mp3" a_MediaObject := Filexpro( v_MyMediaFile,, "System.Media.Duration" ...; Created on 07 August 2020
18. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; What? A sorta quick article to note how I can generate refresh tokens and access tokens using Zoho Deluge code (so within Zoho Creator, CRM or Books) without XML calls. Why? I find myself using ...; Created on 17 July 2019
19. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... Requests, Qualifications and some others. How? The aim/objective is the following: Store what was already selected in the lookups Clear the lookups list Restore what was originally selected ...; Created on 28 June 2019
20. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... really random, it involves getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters ...; Created on 09 May 2019