Assuming lipman is required, the following 656 results were found.
-
What? This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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? Zoho doesn't have a function to generate random numbers...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A quick article to document how to calculate the distance "as the crow files" between two coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution that will distance following roads and the such but.....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is a reminder on how to swap out a product in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the following in a form/report called "Stock_Upload": RowID Name SKU Account Email 0001 Test Product 1 TEST001 test1@joellipman.com 0002 Test Product 1 TEST001 test1@joellipman.com 0003 Test Product 1 TEST001 test1@joellipman.com 0004 Test Product 1...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
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 month is before the current date, then set it to the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal year starts from January, simply divide by 3... How? I'm...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
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 page for each minor issue. How? So I'm going to try and list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, I needed a way to programmatically link the sales...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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 has a multi-select picklist which will use commas to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in Zoho Creator and nor is List when submitted as a file attachment. sendmail [ from: zoho.adminuserid to: "info@joellipman.com" subject: "Testing an attachment" message: "This is a test" attachments: file: input.my_upload ]; // success! Send mail...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
What? So this is an article to document the methods I use to get an image uploaded in a form to display in a report or on another page. Why? There might be different articles out there and discussion forums that do cover this but it takes me so long to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A very quick article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *