Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): ...; Created on 30 April 2021
9. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... CRM modules called a "LinkingModule" (as opposed to standard modules and custom modules). Quick way to determine the API name of the linking module: Go to setup > Developer Space > functions. Create ...; Created on 28 April 2021
10. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... "data": { "member_id": "123456", "channel_name": "shopify", "item_name": "Joel's Awesome Life", "item_price": "priceless" } } What Zoho sends to the 3rd-party API: Sending a map request ...; Created on 03 February 2021
11. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url": "/crm/org12345678901/specific/ViewAttachment?fileId=aaaabbbbccccddddeeeeffff1111222233334&module=CustomModule1&parentId=123456789012345678&creatorId=987654321098765432&id=234567890123456789&name=dummy1.pdf&downLoadMode=default", ...; Created on 02 February 2021
12. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it in code so as to display it in a HTML table. What I have: id name date --------------------------------------------- 46498 ...; Created on 29 January 2021
13. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What I have: , What I want: First ...; Created on 11 January 2021
14. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... "message": "Field name 'ApprovalStatus' is invalid " }, "status": 1 } } [Warning: Another red herring ahead] We tried various other options such as adding a tickbox that would be used ...; Created on 10 December 2020
15. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in ...; Created on 06 December 2020
16. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... into 3 stages: Zoho Creator: Specify Custom Domain Domain Registrar: Setup subdomain and add CNAME Zoho Support: Get Zoho to setup SSL 1. Setup Custom Domain So go into your Zoho Creator ...; Created on 17 November 2020
17. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without ...; Created on 24 October 2020
18. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... List View Product Name #1 Product SKU #1 Product Description #1 Product Price ...; Created on 22 October 2020
19. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; What? A very quick article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. ...; Created on 19 October 2020
20. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... name. The issue is that if you use zoho.crm.searchRecords() this will work fine for company names without special characters such as the ampersand or parentheses. But what if amongst your records you ...; Created on 28 August 2020