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. ZohoCRM: Import Attachments: / Zoho /; ... the reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" ...; Created on 16 January 2023
10. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... v_RateCard = ZDK.Page.getField('Which_rate_card_is_this_based_off').getValue(); // get opportunity lookup (related deal) of this record let r_DealLookup = ZDK.Page.getField('Opportunity_Name').getValue(); ...; Created on 09 December 2022
11. Zoho Analytics: Set Up Widget Displaying Sales Person: / Zoho /; ... I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing the sale person name. Something like the following: With ...; Created on 24 October 2022
12. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... r_CandidateDetails; if(!isNull(r_CandidateDetails.get("Which School do you go to?"))) { v_SchoolName = r_CandidateDetails.get("Which School do you go to?"); v_SchoolID = r_CandidateDetails.get("Which ...; Created on 19 October 2022
13. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... = r_RequestDetails.get("requests").get("actions"); for each r_Action in l_Actions { if(!isnull(r_Action.get("fields"))) { for each r_Field in r_Action.get("fields") { if(r_Field.get("field_name") ...; Created on 17 October 2022
14. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... type :GET connection:"zcrm" ]; f_FileRequest.setParamName("file"); f_FileRequest.setFileName(r_QuoteDetails.get("Subject") + ".pdf"); // // get a greeting name ...; Created on 18 August 2022
15. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... m_CustomField in l_CustomFields { // exclude existing custom field payment mode and date l_DontCopyFields = ; if(!l_DontCopyFields.contains(m_CustomField.get("api_name"))) { l_NewCustomFields.add(m_CustomField); } } // ...; Created on 17 August 2022
16. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; What? An article on one of my first client scripts for ZohoCRM. This retrieves and populates an email field based on when a contact is selected in a lookup field. Why? I could do a normal automation/workflow ...; Created on 20 July 2022
17. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... part. Else, here is what you need to do. Go to the official Amazon home page that applies to your region. Sign in with your Amazon username and password. After you have logged in, look for the menu ...; Created on 29 June 2022
18. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... set the data type r_DownloadedPhoto.setParamName("image"); // // build up request to Zoho m_Params = Map(); m_Params.put("image",r_DownloadedPhoto); // // generate endpoint v_Url = "https://books.zoho.eu/api/v3/items/" ...; Created on 21 June 2022
19. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; ... tag which isn't great for CSS styling as you can't do cross-dom acoss child iframes; but it does let you use OpenURL(v_Url, "iframe", "iframe_name") which is good if you have multiple iframes on a page and ...; Created on 05 May 2022
20. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... 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 alongside the domain you want to install the SSL certificate ...; Created on 07 April 2022