Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 product names (v2 up to 200, v6 up to 10k, v7 up to 100k) m_Params = {"select_query":"select Product_Name, COUNT(id) 'Frequency' from Products where Product_Name is not null group by Product_Name limit " + v_PerPage + " offset " + v_Offset};...

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

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

13 February 2023 0.8); m_Params.put("n", 1); m_Params.put("max_tokens", 256); m_Params.put("presence_penalty", 0); m_Params.put("frequency_penalty", 0); // // send request to chatgpt openai r_ChatGPTResponse = invokeurl [ url...

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

Select unique values in Microsoft Excel columnhttp://mail.joellipman.com/articles/microsoft/excel/select-distinct-values-in-microsoft-excel-column.html

03 July 2012 /* Count the number of unique number values in cells A2:A10, but do not count blank cells or text values (4) */ =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) /* Count the number of unique text and number values in cells B2:B10 (which must not contain blank...

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

Joes Word Cloud (JWC) Downloadhttp://mail.joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 IDs - Added Joomla! Admin Option: Exclude Category IDs - Added Joomla! Admin Option: Sort Words By (shuffle, alphabet, frequency) - Added Joomla! Admin Option: Sort Words Order (ascending, descending) - Prefixed language file references with JWC to...

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

ZohoCRM: Integrate ChatGPT to ZohoZIAhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 m_Params.put("n",1); m_Params.put("max_tokens",256); m_Params.put("presence_penalty",0); m_Params.put("frequency_penalty",0); // // send request to chatgpt openai r_ChatGPTResponse = invokeurl [ url :"https://api.openai.com/v1/chat/completions" type...

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

Creating a Top 10 chart with less codehttp://mail.joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 The old code would have been: echo '# | Search Term | Count' . "\n"; # create an array of search terms with their frequency count $search_table_results=mysql_query("SELECT DISTINCT column1 FROM table1");...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

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

22 April 2024 display name of "Schedule - Shopify Webhooks" It has the code standalone.fn_Shopify_RestoreWebhook(); Starts ASAP; with a frequency of Hourly (run every 2 hours); and never ends. Save and done. Error(s) Encountered webhook: expected String to be a Hash...

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

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

14 May 2024 that the contact is associated with. This key is mandatory when you include Who_id and What_Id. FREQ (String): Defines the frequency of the reminder. The possible values are DAILY, WEEKLY, MONTHLY, YEARLY, NONE. If you specify, NONE, the system sets a...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync http://mail.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 on the "Add Scheduler" button Complete the "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure you...

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