What?
This article demonstrates how to return a list of unique values in a particular field in a CRM module.
Why?
My use-case is a data-migration where the records exist in a staging module in ...
What?
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook).
How?
So for demonstration ...
What?
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters.
Why?
I use MS Excel for organizing data and then converting to MySQL commands. ...
What?
An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...
What?
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...
... columns.
How?
IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL
DROP PROCEDURE [usp_ListDistinctValuesAndCounts];
GO
CREATE PROCEDURE [usp_ListDistinctValuesAndCounts]
(
...
...
This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells.
Display all Unique
Found this note on one of Microsoft Help sites:
Office 2010:
Select the ...
... on the left grey margin of this and select "Insert Row" then "Below".
Repeat with all values you want to compare.
For each Data cell, Set the background fill expression as per the MDX expression ...
... = "div.zc-Calendar_Day_Select-group";
//
// set initial hidden date field
input.Selected_Date = zoho.currentdate;
input.Starting_Date = zoho.currentdate;
//
// set the values for the calendar select ...
...
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:
// ****************** CODE USING ...
... == "Customer_s_Timezone")
{
// loop through all the picklist values of this dropdown
for each r_TimeZone in r_Field.get("pick_list_values")
{
if(r_TimeZone.get("display_value").containsIgnoreCase(v_TimeZone))
{
v_CustomerTimeZon ...
... 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 ...
What?
This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store.
Why?
The use-case was that I wanted to retrieve ...
What?
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 ...
... every month"...
How?
Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...
...
The Code to read, parse, create a holding record and generate a link for the customer portal user to click on:
// accessing zoho.eu (not zoho.com) so adapt the 2 values
v_CreatorBaseUrl = "https://creator.zoho.eu";
v_ZohoApisDC ...
... on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report:
Click on the plus icon to create a new form
Select a blank form, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.