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 Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
10. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + v_ListingPublishKey + "?filepath=/" + v_Filename; URL Syntax #2 // works in eBay v_ImageSrc = "https://creator.zohopublic.com" + zoho.appuri + "Portal_Listing_Report/" + input.ID + "/Main_Photo/image-download/" ...; Created on 17 October 2021
11. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... */ v_Page = ifnull(p_Page,1); v_PerPage = ifnull(p_PerPage,200); m_Output = Map(); r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken ...; Created on 13 October 2021
12. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... { "count": 3, "more_records": false } } Amazing! Let's go one further for a lookup field, in this case the account name field on the quotes record: // // build up COQL query v_CoqlQuer ...; Created on 08 October 2021
13. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; What? I probably won't forget this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? ...; Created on 07 October 2021
14. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; ... the CRM record. How? So we have to do the usual which is download the photo using invokeUrl then we set the paramname not to attachment but to file. We then use another invokeUrl to upload the ...; Created on 27 September 2021
15. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made ...; Created on 24 September 2021
16. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... = 0; m_ShippingAddress = Map(); // set field api names that we will read from and write to l_CrmShippingAddress = ; l_BooksShippingAddress = ; // loop through the CRM Sales Order address field ...; Created on 22 September 2021
17. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the ...; Created on 01 September 2021
18. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... loop through each row for each r_Data in l_FileRows { // initialize record m_Record = Map(); m_Record.put("EmployeeID",""); m_Record.put("Name",""); m_Record.put("Address",""); m_Record.put("Territory",""); // // ...; Created on 26 August 2021
19. ZohoCRM: Process all records of a module: / Zoho /; ... field update if(!isnull(r_Record.get("Account_Name"))) { // do other stuff v_CountUpdated = v_CountUpdated + 1; } // // update the record irrespectively m_Update.put("Processed",true); r_Update ...; Created on 24 August 2021
20. Xero API: Send Multiple Invoices: / Xero /; ... "TaxAmount": 48, "AccountCode": 3610, "DiscountAmount": 24, "Tracking": [ { "Name": "Activity", "Option": "ELEPHANT" ...; Created on 15 August 2021