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 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
3. Zoho Creator: Push to eBay Listings: / Zoho /; ... t which is sold at a fixed price using the AddFixedPriceItem method. I've added the code to update a listing as well through ReviseFixedPriceItem. The parameter in this example is the Creator Record ...; Created on 12 September 2021
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... should get prompted for the Mac/Admin password which you type in the terminal (will not display, just type away and press the Return key). The response will be something like “added 98 packages from 60 ...; Created on 24 October 2020
12. 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
13. MySQL: Count occurrences of words in a column: / MySQL /; ... have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I ...; Created on 12 March 2020
14. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; What? A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate ...; Created on 06 February 2020
15. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... false); if(!b_Exists) { // insert into Product table r_ProductCreate = insert into Product [ Product_Name=v_Name Added_User=zoho.loginuser ]; v_ProductID = r_ProductCreate.ID; } else { // ...; Created on 21 November 2019
16. GDPR Privacy Policy: / Static Items /; ... computer's hard drive. Once you agree, the file is added and the cookie helps analyse web traffic or lets you know when you visit a particular site. Cookies allow web applications to respond to you as an ...; Created on 14 February 2019
17. Excel - Check a column for values found in another column: / Excel /; ... to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this ...; Created on 14 February 2019
18. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... as) has most of the ever-changing data. Note how the impersonator is only added if it is not blank. It must not be included in the claim set if you have not yet had the service account authorized b ...; Created on 02 February 2019
19. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
20. Change div height to fit content: / Cascading Stylesheets /; ... is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this: I want this to happen: The code of this is the addedn overflow:hidden;height:1%;: A ...; Created on 19 December 2016