Search - Joel Lipman .Com

1. 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
2. ZohoCRM: Import Attachments: / Zoho /; ... spinny progress animation or go and do something more productive: Ensure the CSV files are selected for mapping (in this case Attachments.csv and Contacts_001.csv - by the way, my Attachments.csv ...; Created on 16 January 2023
3. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... v_DealRate3 = 475; v_DealRate4 = 525; b_ShowAlertMessage = false; } // show advisory if (b_ShowAlertMessage) { ZDK.Client.showAlert("You have selected ...; Created on 09 December 2022
4. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... you simply add an option to the picklist and then specify which of the options are selected. In this case, simply giving it the IDs should work... but it doesn't. Assuming my multi-lookup field is ...; Created on 18 August 2022
5. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... you or may be already working for you without this issue. By changing the workflow to execute not "When any field is upddated" but "When any selected field is updated" and then selecting the fields "Status", ...; Created on 17 August 2022
6. 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
7. 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
8. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; What? So this is a pretty cool feature in Zoho CRM that I hadn't used much but definitely worth an article. The ability to block field picklist options from being selected based on the profile of a user. ...; Created on 11 February 2022
9. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
10. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... else if(r_Record.Type == "Subform2") { // store the second subform into a collection c_SubformRows = r_Record.mySubform2; } // loop through the selected subform rows ...; Created on 17 November 2021
11. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... PDT 2022,Fri Jul 29 00:00:00 PDT 2022 But if I were to maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold valid appointment ...; Created on 02 November 2021
12. Zoho Creator: Change Radio into Tabs: / Zoho /; ... Set Clicked Tab to Selected One niggling issue I had was that when selecting a tab, the selected tab didn't stay a different color or style. One theoretical way around this could be that I restyle ...; Created on 22 October 2021
13. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
14. ZohoCRM: Process all records of a module: / Zoho /; ... by "Processed" is "Selected", check after each run of the function that the number has incremented. Once all records are done, return to the Module Layout and delete the "Processed" field. [Optional conditionally] ...; Created on 24 August 2021
15. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... a grooved border ; 0x200 aligns horizontal to left and vertically centered (0x201: center center, 0x202: right center) Gui, Add, Text, w350 h28 x120 y11 -Multi vSelectedDir gBrowseFolders 0x1000 +0x200, ...; Created on 08 July 2020
16. 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
17. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; What? An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the ...; Created on 27 September 2019
18. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; What? A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...; Created on 28 June 2019
19. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
20. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... of the PDF preview of my HTML code where I've selected a quote and applied a template to it: The Solution After removing all styling, taking away classes and ID fields that might have been ...; Created on 22 February 2019