Search - Joel Lipman .Com

1. Zoho Deluge: Proper Case for Names: / Zoho /; What? This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the ...; Created on 13 July 2023
2. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; What? There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with ...; Created on 12 July 2023
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. Zoho Creator: Input Color Picker: / Zoho /; ... a radio type field into a color picker. Pre-amble: Create a Zoho Creator form Create a form, I'm calling mine "Color Picker" Add a note field, I've given it the field link name "Note_ColorPicker_Css" ...; Created on 14 October 2024
12. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = invokeurl [ url :v_Endpoint type :GET headers:m_Header connection:"my_workdrive_connection" ]; //info r_TeamFolderInfo; // // ====================== // get list of subfolders by name (creates ...; Created on 11 September 2024
13. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... purposes if(!isNull(r_Contact) && !isNull(r_Contact.get("Email"))) { v_RecipientEmail = r_Contact.get("Email"); v_RecipientFullName = r_Contact.get("Full_Name"); // _ m_Parameters = Map(); m_Data ...; Created on 06 August 2024
14. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... the name "Joels Image Library". I think I closed it and reopened it but now I want a 2nd column. So I click on the "Add" button and select "Add Column" > I called the column "ZohoAnalytics Image URL" and ...; Created on 25 July 2024
15. Zoho Projects: Get All Events: / Zoho /; ... we check the JSON, we can select a portal name and ID, this avoids the need of using up an API request to get the portal v_PortalName = "my_portal"; v_PortalID = "789456123"; // // get all projects v_EndpointProjects ...; Created on 22 July 2024
16. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... "Zoho Analytics Workspace" as the data source type. Select the relevant workspace and click on "Next" Select "Custom Query" in step 2 and paste your Zoho SQL query in here. Give it a name, set the schedule ...; Created on 09 July 2024
17. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
18. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... every day until an end date. We then carry out the last bit of the brief with a separate workflow that runs exactly 4 days after the lead creation time and assigns it to the specified user (full name ...; Created on 14 May 2024
19. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email ...; Created on 07 May 2024
20. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... = zoho.creator.createRecord("myOwnerName","myAppName","myFormName",m_CreateRecord,m_Blank,"myCreatorConnection"); // // build the hash based on the payload body v_Data = ifnull(m_Payload.get("body"),""); v_VerifyHash ...; Created on 22 April 2024