Search - Joel Lipman .Com

1. Added a Launcher and Unduplicater: / Products /; Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL ...; Created on 19 May 2010
2. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the ...; Created on 09 December 2022
3. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... helpful on the CRM record to see how many candidates had been placed at this particular CRM Account. We added several fields which get populated when a candidate was modified in ZohoRecruit. How? ...; Created on 19 October 2022
4. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... into a PDF using a customer's template. // // initialize (this is code added to a button so should alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; // // ...; Created on 18 August 2022
5. Zoho Creator: Populate a Multi-Lookup: / Zoho /; What? This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, ...; Created on 18 August 2022
6. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... the Payment Date. Why? This was requested by a customer and the problem happened in that the workflow would simply not trigger when the invoice was paid. The customer had added 3 custom fields: ...; Created on 17 August 2022
7. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... as you would any other reading stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to the approved list as well as finding out ...; Created on 29 June 2022
8. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... one way, in other words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings don't get parsed into custom ...; Created on 31 March 2022
9. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... r_CheckIfDocumentAlreadyExists.ID]; v_DateAdded = r_NewDocumentRecord.Added_Time.toString("E, d MMM yyyy HH:mm"); } else { r_Document = insert into Document [ Added_User=zoho.loginuser Document_Name=r_Attachment.get("File_Name") Document_File=r_Download Downloaded="Downloaded" Parent_Record=v_CrmContactID.toString() ]; r_NewDocumentRecord ...; Created on 11 March 2022
10. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; What? A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho ...; Created on 08 February 2022
11. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we ...; Created on 15 December 2021
12. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Daylight Savings Time. The field is a text line field called Customers_Requested_Time and I have added a few more date time fields called GMT_Date_Time_Start, GMT_Date_Time_End, System_Date_Time_Start, ...; Created on 07 December 2021
13. Zoho Creator: Change Radio into Tabs: / Zoho /; ... First, let's add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need ...; Created on 22 October 2021
14. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; What? A quick article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" ...; Created on 01 September 2021
15. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
16. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal = ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy ...; Created on 30 July 2021
17. Zoho Creator: Add a subform while creating a record: / Zoho /; ... go. How? Here's a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below example, my ...; Created on 14 July 2021
18. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is only modifiable when using REST API v2.1. We are going ...; Created on 17 May 2021
19. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... ]; // add record as zoho.loginuser so that only record owners can access this record in report or form r_HoldInCreator = insert into Download_File [ Added_User=zoho.loginuser ...; Created on 02 February 2021
20. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... // return response as ok popup (doesn't really do anything: just says "Record added successfully") v_OutputMessage = "Thank you for submitting your application for leave."; c_Response = Collection(); ...; Created on 10 December 2020