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 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the connection link name. I'm calling mine joel_zoho Authorize it, etc. Make a ...; Created on 31 March 2022
17. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... Here's the Creator form to hold the Attachments: Parent Record (a single line that will be a unique ref to prevent downloading the same record again and again) Document Name (a single line that ...; Created on 11 March 2022
18. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... for this, I created the following Creator form: The fields: Calendar Day Select (link name: Calendar_Day_Select || type Radio) Form CSS (link name: Form_Css || type Add Notes) Selected Value for ...; Created on 09 March 2022
19. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single ...; Created on 14 February 2022
20. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... layout didn't work Choose field to validate > Select "Lead Status" Choose validation type as "Validate using function" and click on "Next" For functions, select "Write your own" Give it a function name, ...; Created on 11 February 2022