Assuming values is required, the following 106 results were found.
-
This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
This has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
search. Method #1: zoho.crm.searchRecords() Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: As of 2025, this method no longer works....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for all the invoices against a sales person. It adds to the effect on loading the page that a widget has clearly defined values based on the filters I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
v_Shopify_Updated = v_Shopify_UpdatedStr.getPrefix("Z").replaceAll("T"," "); // adding an apostrophe/single-quote to ID values so MS Excel doesn't round them up v_ProductIDStr = "\"'" + v_ProductID + "\""; v_VariantIDStr = "\"'" + v_VariantID + "\"";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
Aggregate of total amount may be unnecessary as this could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the 3rd tab "Settings" and the preview should automatically display the image alongside the data. I'm going to the sub tab "Values" and change the displayed label to a constant text set to "CRM Account Data": I then click on the "image" sub tab and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the given string and convert it to its RGB value. Replace letters A...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click on one...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
balance invoice with the deposit deducted. Because these line items have custom fields, we need to copy over all the custom values to the new line items. How? This is about an hour's work doing it on a CRM workflow (save of record) but here we're going...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Let me show you how we used to connect and then what the new code will be. The preamble to both of these is how to get the values to include in the invokeURL headers and payload. Previously on... m_Header = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
retrieving the parameters of the request m_RequestParams = crmAPIRequest.toMap().get("params"); // // retrieving the set of values from 'arguments' passed in the javascript code m_Arguments = ifnull(m_RequestParams.get("arguments"), Map()); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
on-guide/zoho-crm/articles/how-to-merge-subform-fields-and-image-field-via-zoho-writer-s-merge-apis#Step_5_Pass_Image_Field_Values_in_Merge_API ******************************************************************************* */ // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
based on the pull from invoices article I wrote earlier but with quotes from Xero, things panned out differently: Date/Time values don't include a timezone Issues with tax rates meant replicating a tax list copy from Xero to Zoho the Client doesn't use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
alias (eg. for "about" give it the alias "about_new") Login to your database and browse to the #__menu table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
a Quick string replacements These are merely for reference for myself. Their purpose are for quick tweaks to the database values after a migration. -- Replace stringtofind with the string you want to find -- Replace stringtoreplace with the string you...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of the month...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
this with more information about the failure. All this blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such as COMMA (,) and therefore the parsing (to extract year for...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB