Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 l_Messages.add(m_Message); } } The one to rule them all So I've been asked here and on the forums as well for the full query that includes making ChatGPT keep the context of the conversation along with new cliqs: // // initialize m_Response = Map();...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 for the amount on the invoice. Well almost. We've gone the extra step in that we added a custom field that can override the full balance, to allow partial payments such as a deposit or instalment. How? I won't go in to how to create a button in...

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

ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 Now create another query (better to refresh the page so that the new table and columns will be available to us): SELECT c."Full Name", c."Lead Source", cp."Campaign 1", cp."Campaign 2", cp."Campaign 3" FROM "Contacts" c LEFT JOIN "Contacts vs Campaigns...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 pages respectively: Page of Copyright © My Company Ltd. All Rights Reserved. In for a penny, in for a pound Here's my full template deluge/html/css code to put in a Zoho Creator page excluding the content (edited for Public display - Not the used...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 brief with a separate workflow that runs exactly 4 days after the lead creation time and assigns it to the specified user (full name of user was given in the brief but removed here for privacy). Finally, we delete any of these tasks when they get...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 AS "Record Owner", img2."ZohoAnalytics Image URL" AS "Status Image" FROM ( SELECT con."Id" AS "RecordID", con."Full Name" AS "RecordName", con."Contact Owner Name" AS "RecordOwner", con."Modified Time" AS "ModifiedTime", if(to_date(con."Modified Time")...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 the new developer's application is subscribed to eBay marketplace account deletion/closure notifications or they have successfully opted out of the notifications, the keyset/App ID is activated, and they can begin making API calls." How? Let's cover the...

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

How to put MediaWiki into Debug modehttps://www.joellipman.com/articles/cms/mediawiki/how-to-put-mediawiki-into-debug-mode.html

22 October 2009 does: $wgDebugLogFile = '/home/username/public_html/wikidir/logfile'; IMPORTANT NOTE: The path above should be the exact full path to the wiki directory under your account.

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

MS Excel: Convert a text to a numberhttps://www.joellipman.com/articles/microsoft/excel/ms-excel-convert-a-text-to-a-number.html

15 November 2013 values to a number using Microsoft Excel 2010. Since when did MS Excel stop understanding what a NUMBER was? I have a column full of currency values which I want to convert, specifically Philippine pesos to British pounds (sterling). When I multiply the...

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

Joomla CMS: Register to Read Morehttps://www.joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full text) and just show intro texts to public but the default Joomla instructions do not include the search engine. I need the...

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