Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 to open the profile. As an overview: Setup a standard AutoHotkey GUI Loop through Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and extract value. Hide the first column in the list view...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 straightforward, Login to ZohoCRM as Administrator > Setup > Developer Space > Connections > Add Connection > Give it a name and then select Scopes > and get ERROR_invalid_operation_type Solution: Remove some scopes and test. The likely ones you want...

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

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 will return a count of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value` FROM (...

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

Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 check your URL is correct. The format for API v2 is: https://www.zohoapis.{eu or com}/crm/v2/settings/fields?module={module-name} You can then use the following snippet to get all the fields for the module. In our case, for "Invoices": /* Function:...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 on an embedded form on the popup would need to apply specifically to the contents in the popup. Find the modal or popup name to isolate these from other CSS tags sharing the same name. Alternative Solution Some of you may be asking why not use openUrl...

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

Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/crm/xero/xero-send-multiple-invoices.html

15 August 2021 1, "UnitAmount": 240, "TaxType": "OUTPUT2", "TaxAmount": 48, "AccountCode": 3610, "DiscountAmount": 24, "Tracking": [ { "Name": "Activity", "Option": "ELEPHANT" } ] } ] }, { "Type": "ACCREC", "Contact": { "ContactID":...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 from the third-party API, let's go through the CRM picklist options to find the relevant one if(!isnull(r_Timezone.get("zoneName"))) { v_TimeZone = r_Timezone.get("zoneName"); // // get all the fields on the Lead module v_Endpoint =...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 is a little stricter than Zoho's. Setup a Zoho CRM Function: Login to Zoho CRM > Setup > Functions > New Function Function Name: fn_API_ReceiveXeroWebhook Display Name: FN - Xero - Receive Webhook Description: Function used to receive webhooks from Xero...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 this is how I do it along with screenshots: Login to your GoDaddy panel and expand the menu by clicking the caret by your name in the top right corner, then click on "My Products": Scroll down to SSL Certificates and click on the "Manage" button...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 in l_Actions { if(!isnull(r_Action.get("fields"))) { for each r_Field in r_Action.get("fields") { if(r_Field.get("field_name") == "Deal_Ref") { v_DealRef = r_Field.get("field_value"); } } } } } } // // Search ZohoCRM for the Deal with that Deal Ref...

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

Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 the MidJourney Bot Signup to Discord.com Visit Midjourney.com Go to the Midjourney's discord channel Join a community room (named "Newbie"...) // or if you subscribe you can have a private conversation with the MidJourney Bot Type the word /imagine and...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

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 || v_Message.containsIgnoreCase("Hey")) { // store in response text v_Answer = "Hi " + user.get("first_name") + "!\nMy name is JoelBot and I am currently connected to the OpenAI API. I can try and answer any question you end with a question mark. Try me...

• 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 != null) { for each m_NomAccount in r_ChartOfAccounts.get("chartofaccounts") { if(m_NomAccount.get("account_name").equalsIgnoreCase("Stripe Clearing")) { v_NominalAccountID = m_NomAccount.get("account_id"); } } } // // retrieve invoice details from...

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

Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 { for each r_Account in r_ChartOfAccounts.get("chartofaccounts") { m_Accounts.put(r_Account.get("account_name"),r_Account.get("account_id")); } } // // build the update or create request m_CreateBooksItem = Map();...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 type: GET connection: "my_projects_connection" ]; info r_Portals; // // once we check the JSON, we can select a portal name and ID, this avoids the need of using up an API request to get the portal v_PortalName = "my_portal"; v_PortalID = "789456123";...

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

Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 Creator app, to connect to the data within Shopify. Why? At time of print, we have woken up to the news that including a username and password, or a client and secret in the endpoint of a URL will no longer be supported in the Zoho Deluge invokeURL...

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

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 Make sure that the \components\com_kunena\template folder is on your local disk Make a copy of the default folder inside Rename this to the name of your new template (avoid any spaces) Download the new template for the Kunena forum This is what the...

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

How to use download managers with Google Chromehttps://www.joellipman.com/articles/google/how-to-use-download-managers-with-google-chrome.html

19 September 2009 http://www.youtube.com/watch?v= Using the bookmark feature: Right click on the bookmarks bar of Google Chrome. Type the name to what ever you want (eg. Download YouTube). Use the following code as the URL: javascript:window.location.href =...

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

Search and Replace in a MySQL Databasehttps://www.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace'); Source:...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast for it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider...

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