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?
A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator.
Why?
You may have received an error that goes something like:
datatype: datetime
How?
Here are ...
What?
This is a quick article to help anyone encountering this gotcha: I have an integration field, if someone changes it, I want to save the value to the record immediately.
Why?
If you try to ...
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?
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.
Why?
I'm working with a system which stores XML strings ...
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 ...
Applies to
Transact-SQL (T-SQL)
What?
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
Why?
I have a table that ...
What?
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called ...
... columns.
How?
IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL
DROP PROCEDURE [usp_ListDistinctValuesAndCounts];
GO
CREATE PROCEDURE [usp_ListDistinctValuesAndCounts]
(
...
... the following view to generate random numbers on SQL Server.
-- Used to reference RAND with in a function
CREATE VIEW dbo.vwRandom
AS
SELECT RAND() as RandomValue;
GO
The Function
Again ...
...
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 ...
... want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you didn't pick up on this. If no type is specified (type=2) then datasources ...
... overlap at the end/start of the year need to be observed. As per the documentation:
dateValue = '29-Dec-2019';
info dateValue.toString("yyyy"); // returns 2019
dateValue = '29-Dec-2019';
info dateValue.toString("YYYY"); ...
... 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);
m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong());
m_CreateBooksItem.put("initial_stock",v_Quantity.toLong());
m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal());
m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...
... the following instructions to these instead.
ZohoCRM: Get Details as Zoho User
The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this ...
What?
This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records...
Why? ...
What?
Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay.
Why?
Our use-case is a data migration from eBay to a fresh instance ...
...
c_Employee.Usual_Shift.insert(c_UsualShift);
info "-------------";
}
Yields something like:
Error(s) Encountered
Value is empty and '1234567000001234567' function cannot be applied: ...
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.