Assuming zoho is required, the following 216 results were found.
-
This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts it to a list, then lets you generate an array or list of any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A short article explaining how Zoho Deluge allows a variable assignment to be written across multiple lines, as long as the statement ends with a semi-colon. This has a limited number of use cases, but is useful to be aware of if you have not come...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= "Credit Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the letters with removeAllAlpha(): v_PaymentTermsAlphaNum = v_PaymentTerms.getAlphaNumeric(); // yields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and working... The quickest I found [limit 1000 per day | Incorrect Location]: v_Url = "http://api.db-ip.com/v2/free/"+ zoho.ipaddress; v_Response = getUrl( v_Url ); Returns something like: { "ipAddress": "147.188.254.175", "continentCode": "EU",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
writing a whole page for this is probably unwarranted so I may rename this article later to common things I need to do in Zoho Deluge. How? So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a file to be hosted within Zoho Creator for use by a JS widget that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
but in this case it is the rate that gets rounded. The numbers at the end still need to match what's in CRM and with ZohoBooks rounding differently can make cent/penny errors into 100s of dollar/pound errors. Zoho CRM has a fun way of rounding which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
the quarter by the month and your Fiscal year starts from January, simply divide by 3... How? I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
task which contradicts documentation: In a custom function In an Action item in Report In a schedule workflow Source(s): Zoho Creator - Insert rows in Subform (via Deluge Script)
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
l_Triggers = List(); l_Triggers.add("none"); m_Data.put("trigger",l_Triggers); v_Url = "https://www.zohoapis.eu/crm/v2.1/Quotes/" + input.CRM_Quote_ID; r_CreateCrmQuote = invokeurl [ url :v_Url type :PUT parameters:m_Data.toString()...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{"EmployeeID":"64","Name":"Elephant Man","Address":"123 New Street, New York City","Territory":"USA"} Source(s): Zoho Deluge — Try Now PHP Live Regex — A Live Regular Expression Tester for PHP
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
sales team would only create sales orders in CRM and don't use the invoice module (that's for their finance team using ZohoBooks), we disabled the CRM Invoice module. How? Therein lies the reason. For the quote conversion mapping, it needs the CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
here to remind me of the Deluge code I need to add/subtract time. Why? Just want to add 10 minutes to a date/time field in ZohoCRM and wanted a refresher for use in a client system. The usual error is something similar to the following: { "code":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= false; } The Result So now when I tick this decision box, I get something like the following: Source(s): Zoho Creator/Deluge: Insert rows in Subform Quick refresher: // declaring the row = .(); // assigning values for various subform fields in the row...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you can use the following code, note that the parameter is the eBay Item ID: void...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM Template, the table of line items will behave like this; specifically when there are a lot of line items as per my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *