Search - Joel Lipman .Com

1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... symbols) ValueToConvert = textInfo.ToTitleCase(ValueToConvert.ToLower()); // add a trailing space to catch below exceptions (eg. "Director of It ") ...; Created on 04 October 2013
2. Add the website name to the page title in Joomla!: / Joomla /; Change Page Title in Website Here are some instructions on changing the page title in Joomla! CMS to display both the actual page title and other stuff. As I like doing this for this particular website ...; Created on 06 September 2009
3. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; What? An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for ...; Created on 04 November 2024
4. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with ...; Created on 25 July 2024
5. Zoho Projects: Get All Events: / Zoho /; ... + ifnull(m_PastEvent.get("title"),"?").trim().toLowerCase(); v_ThisEventStart = v_ThisDateEvent_Year + "-" + v_ThisDateEvent_Month + "-" + v_ThisDateEvent_Day + " " + v_ThisDateEvent_Hour + ":" + v_ThisDateEvent_Minute ...; Created on 22 July 2024
6. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; What? A follow on from my article Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want ...; Created on 14 March 2024
7. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... for the code to replace these with the user's personal details (eg. name, job title, etc). /* ******************************************************************************* Function: String ...; Created on 05 December 2023
8. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... build the update or create request m_CreateBooksItem = Map(); m_CreateBooksItem.put("name",v_ItemTitle); m_CreateBooksItem.put("sku",v_ItemSKU); m_CreateBooksItem.put("rate",v_ItemPrice.toDecimal()); // // ...; Created on 04 May 2023
9. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... "Role" with the options: "user", "assistant", "system". Add a file upload field called "Big Data" Add a single line field called "Title" (used as a multi-line cannot be used in the listview). Add ...; Created on 06 March 2023
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... select which fields to return l_OutputFields = List(); l_OutputFields.add("ItemID"); l_OutputFields.add("Title"); l_OutputFields.add("SKU"); l_OutputFields.add("QuantityAvailable"); l_OutputFields.add("SellingStatus"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // / ...; Created on 01 March 2023
12. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
13. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... title handle status createdAt publishedAt updatedAt } updatedAt } cursor } pageInfo { hasNextPage ...; Created on 20 February 2023
14. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; What? So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct ...; Created on 11 February 2023
15. ZohoCRM: Import Attachments: / Zoho /; ... := "Joel Lipman .Com" v_CompanyKey := StrReplace( v_Company, " ", "_" ) v_Title := v_Company " - Generate ZCRM Attachments" v_SubTitle := "Generate ZCRM Attachments" v_Desc := "This ...; Created on 16 January 2023
16. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... (in this example, a lead record but can be almost any kind of record) m_ScheduleMeeting.put("What_Id",98765432109876543); // // the subject m_ScheduleMeeting.put("Event_Title","TEST Consultation: Call ...; Created on 02 March 2022
17. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... "sku": "ABC123456", "title": "Default Title", "barcode": "0000012345", "inventoryItem": { "id": "gid://shopify/InventoryItem/23456789123456" ...; Created on 14 February 2022
18. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
19. Zoho Creator: Change Radio into Tabs: / Zoho /; ... the tabs group) and then a negative margin on another notes field called Note_Title which contains my header to place it above the tabs group: v_Css = ""; v_Css = v_Css + ".zc-Tabs-group .choice-table-row"; v_Css ...; Created on 22 October 2021
20. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... b_CreateProduct = false; } // // title and HTML m_Product.put("title",input.Listing_Title); if(!isNull(input.Full_Shopify_HTML_Code)) { m_Product.put("body_html",input.Full_Shopify_HTML_Code); } m_Product.put("vendor",input.Brand); m_Product.put("product_type",input.Item_Type); // / ...; Created on 17 October 2021