Search - Joel Lipman .Com

21. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use ...; Created on 07 December 2021
22. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... single out this person (can be removed after testing) if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // // startofweek is a ...; Created on 02 December 2021
23. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't demonstrate ...; Created on 08 October 2021
24. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... receive data Login to your Zoho Creator and setup a form, I've called mine "eBay Webhook Payloads" Add a Single-Line field called "Event Type" Add a Multi-line field called "Payload" Click Done Make ...; Created on 20 September 2021
25. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... Replace all commas in between a pair of double-quotes: Well I couldn't find a single regex that can do this in one go but by applying the same regex to the same value (line 29), solved this for the sample ...; Created on 26 August 2021
26. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
27. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... Name (type: Single Line) File Ref (type: Single Line) Expiry Date Time (type: Date-Time) File Download (type: File upload) Create a connection in the Creator app with the scope: ZohoCRM.modules.ALL ...; Created on 02 February 2021
28. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this ...; Created on 06 December 2020
29. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... let's call it "Notifications". Drag a single-line field and a multi-line field onto the form called "Title" and "Content" respectively. If you use this method to populate your notifications, you can send ...; Created on 06 November 2020
30. Zoho Deluge: Get Image Uploaded in Creator Form: / Zoho /; ... name "MyImage". There is an additional single-line text field called "Name". I have added an entry with name "Logo" and I have uploaded an image accordingly. // change this to eu (Europe), com (US), ...; Created on 14 July 2020
31. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... Instead, do the above workflow to attach the files to the Sales Order in Zoho Books, then in your Creator app, do the following for a delayed secondary workflow: Add a single-line field to your Creator ...; Created on 15 May 2020
32. Autohotkey - Chrome Profiles in Alphabetical Order: / AutoHotkey /; ... when listview row is double-clicked to open Chrome Browser with selected Profile. #NoEnv #Warn SendMode Input SetWorkingDir %A_ScriptDir% #SingleInstance force ; -------------------------------------------------------------------------------------- ; ...; Created on 07 January 2020
33. PHP - Remove newlines and spaces from StyleSheet: / Personal Home Page /; What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: ...; Created on 03 January 2020
34. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... yields list of [1,2,3,4,5] Replace any multiple spaces with a single space: v_MyString = "Hello World!"; v_FormattedString = v_MyString.replaceAll("[ ]+"," ",false); // yields Hello World! ...; Created on 31 May 2019
35. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... $v_Output = preg_replace("/[^a-z0-9\_]/", "_",$v_Output); // replace any consecutive underscores to a single one (eg. "my_____test" yields "my_test") $v_Output = preg_replace("#((\_))\\2+#", ...; Created on 06 May 2019
36. Excel - Check a column for values found in another column: / Excel /; ... search with the first parameter being the text to search for (can be a range) and the second the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from ...; Created on 14 February 2019
37. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000 ...; Created on 11 February 2019
38. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... %A_ScriptDir% ; Ensures a consistent starting directory. #SingleInstance force ; -------------------------------------------------------------------------------------- ; Set program Defaults ; -------------------------------------------------------------------------------------- Title ...; Created on 28 January 2019
39. Zoho Deluge - MD5 function: / Zoho /; ... of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can' ...; Created on 19 November 2018
40. 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