Search - Joel Lipman .Com

1. Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator: / Zoho /; What? A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module ...; Created on 20 April 2020
2. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = "To he who shall not be named, Re: " + v_Subject + " Please find attached the CSV export file containing the Data. "; // if(!isBlank(v_PermaLink)) { v_Message = v_Message + " The export fil ...; Created on 11 September 2024
3. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... e URL", v_Endpoint); // // first parameter is the workspace name containing the "Attachments" data table r_Analytics = zoho.reports.createRow("My_Desk_Workspace", "Attachments", m_Data, "zanalytics"); in ...; Created on 05 December 2023
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the ...; Created on 13 July 2023
5. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... form is called "Staff" and the subform is called "Usual Shift" containing the columns "Day", "Start Time", and "End Time": // // select applicable staff l_ApplicableStaff = Staff[ID != 0]; for eac ...; Created on 28 March 2023
6. ZohoCRM: Import Attachments: / Zoho /; ... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets ...; Created on 16 January 2023
7. Zoho Analytics: Set Up a 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
8. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... down and select the Personal Document Settings Scroll down again and select the Approved Personal Document E-mail List. This is the list containing the email address that the Kindle will recognize. You ...; Created on 29 June 2022
9. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the fields I mentioned earlier in the Creator form. Here's the code which should happen when the form containing this radio field loads up: // // initial CSS (hide element while it is styled) input.Form_Css ...; Created on 09 March 2022
10. Zoho Deluge: a HTML Entity Decoder: / Zoho /; What? A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " ...; Created on 27 January 2022
11. Zoho Creator: Add a subform while creating a record: / Zoho /; What? This is an article to document how to include a subform and rows while you are creating a record containing the subform. Why? The use case here is for a Quote Builder in Zoho Creator: Create ...; Created on 14 July 2021
12. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... using the built-in popup of Zoho creator and gives you the freedom to style the notification as any modal would. 1. Create a page This will be the page containing the styled modal. I'm going to ...; Created on 06 November 2020
13. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... have appeared containing a ZIP file: Adding your Widget in Creator Now return to your Creator app, go to Settings and then Widgets then click on "Create" or “New Widget” and enter the details ...; Created on 24 October 2020
14. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... Language: English ; Platform: Microsoft Windows 7 Professional ; AutoHotkey: v1.33.02 ; Author: - ; Description: This program will remove the word EDIT and words containing an underscore ...; Created on 08 July 2020
15. Import Excel CSV file as JavaScript array: / Excel /; ... row Account for strings containing double-quotes (and commas to ignore) Sort the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file ...; Created on 05 October 2015
16. XML Schema Reference: / Extensible Markup Language /; ... in complex type definitions choice Allows only one of the elements contained in the declaration to be present within the containing element complexContent Defines extensions or restrictions ...; Created on 13 August 2014
17. Include a carriage return in a column heading: / SQL Server /; ... 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when ...; Created on 07 July 2014
18. T-SQL: Parse an XML value: / Transact-SQL /; What? This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code. Why? I'm working with a system which stores XML strings ...; Created on 27 March 2014
19. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... whose source time is newer than the destination time. /EXCLUDE:file1[+file2][+file3]... Specifies a list of files containing strings. Each string should ...; Created on 23 February 2014
20. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... Exception(e.ToString()); } } } } Allowing me to simply tick columns to apply this to (note that some of the images have been censored due to this project containing sensitive ...; Created on 04 October 2013