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 ...
... for this, I created the following Creator form:
The fields:
Calendar Day Select (link name: Calendar_Day_Select || type Radio)
Form CSS (link name: Form_Css || type Add Notes)
Selected Value for ...
... = r_User.get("profile").get("name");
break;
}
}
}
}
//
// get field value that we want to check for
v_LeadStatus = "";
if(!isnull(m_Webhook.get("record")))
{
//
// extract lead status
v_LeadStatus ...
...
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 ...
... "$1", false);
// yields 12.3
// same expression again but with a different value
v_Test2 = 12.000;
info v_Test2.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false);
// yields 12.000
So ...
What?
This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify.
Why?
Previously, we would receive an eBay notification and create an ...
... above:
Copy the Webhooks key on the Xero page into your CRM function replacing the value in Line 2 of my code snippet above. > Save the CRM function.
Click on "Save" on the Xero page
Click on ...
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.