Search - Joel Lipman .Com

1. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; What? A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing ...; Created on 01 September 2021
2. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... GUI and display what it will name them. The app needs to rename files but append an incremented count if the name of a file already exists. The original file needs to keep its original name. What ...; Created on 08 July 2020
3. Zoho Deluge - Get Full Day Name: / Zoho /; What? This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters ...; Created on 08 November 2018
4. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; ... statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add ...; Created on 24 September 2015
5. SITS: Export field code and name: / Extensible Markup Language /; ... &GCOD_NAME.COD.SRS England -- What I want: export format to get multiple values -- &G[COD.SRS:•|•] 5826|England How? You can see it in the code above but I'll give the run through using the ...; Created on 12 August 2014
6. Batch Process to rename multiple files using Windows DOS: / MS-DOS /; Applies to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. ...; Created on 09 August 2014
7. PHP: First name and Initial of Surname: / Personal Home Page /; What? A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- ...; Created on 27 March 2014
8. Add the website name to the page title in Joomla!: / Joomla /; ... seems to come out with a new version. If you have installed Joomla 2.5, this is now a setting in the global configuration... The only problem is that your landing page becomes "HOME - SITENAME.COM" which ...; Created on 06 September 2009
9. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... + v_BooksOrgID type :GET connection:"zinventory" ]; m_Accounts = Map(); if(!isnull(r_ChartOfAccounts.get("chartofaccounts"))) { for each r_Account in r_ChartOfAccounts.get("chartofaccounts") { m_Accounts.put(r_Account.get("account_name"),r_Account.get("account_id")); } } // // ...; Created on 04 May 2023
10. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... the domain name as this gets appended automatically: so just 1522905495316._domainkey will do. Set the TXT Value to the DKIM Value you noted earlier ZohoCRM: Get IT to do the SPF The following ...; Created on 04 May 2023
11. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... each r_Account in r_ChartOfAccounts.get("chartofaccounts") { m_Accounts.put(r_Account.get("account_name"),r_Account.get("account_id")); } } // // get access token v_AccessToken = standalone.fn_eBay_GetAccessToken(); l_DebugMessages.add("AccessToken: ...; Created on 27 April 2023
12. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = "GetOrders"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); m_Params.put("OrderStatus","All"); m_Params.put("SortingOrder","Ascending"); m_Params.put("CreateTimeFrom",v_OrdersFrom); m_Params.put("CreateTimeTo",v_OrdersTill); // // ...; Created on 29 March 2023
13. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... c_Employee in l_ApplicableStaff { info c_Employee.Name; // // reset the stuff they already have in their subform "Usual Shift" c_Employee.Usual_Shift.clear(); // // great now let' ...; Created on 28 March 2023
14. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... on each row and then the campaigns as columns. What we want: Contact Name Lead Source Campaign 1 Campaign 2 Campaign 3 ---------------- --------------- -------------- -------------- ...; Created on 20 March 2023
15. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It should be answered by "Construct Answer by Fetching Data" ...; Created on 06 March 2023
16. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products ...; Created on 01 March 2023
17. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... systems: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // ...; Created on 01 March 2023
18. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... build header m_Headers = Map(); m_Headers.put("X-EBAY-API-SITEID",3); m_Headers.put("X-EBAY-API-COMPATIBILITY-LEVEL",v_TradingAPIVersion); v_ApiCall = "GetOrders"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // ...; Created on 28 February 2023
19. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... not b_HasNextPage = r_GetProductVariants.get("data").get("productVariants").get("pageInfo").get("hasNextPage"); } } } } } // // generate a CSV list for monitoring purposes v_CSVFilename ...; Created on 20 February 2023
20. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... || v_Message.containsIgnoreCase("Hello") || v_Message.containsIgnoreCase("Hey")) { // store in response text v_Answer = "Hi " + user.get("first_name") + "!\nMy name is JoelBot and I am currently connecte ...; Created on 13 February 2023