... added row in that subform (on user input). This sets the document name for display later:
if(!isnull(row.Document_File))
{
v_FileDetected = row.Document_File;
if(v_FileDetected.contains("_"))
{
v_SubstringStart ...
What?
This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter.
Why?
Mostly for debugging but here's the code that will quickly get ...
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 ...
What?
A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting.
Why?
As developers, we're keep account of our time and we are currently ...
... timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field:
//
// parse date into yyyy-MM-dd (using subString - reliable)
v_LeadCreatedDate = r_LeadDetails.get("Created_Time").subString(0,4) ...
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 ...
... date format), arrange so it can be sorted alphabetically in reverse order
v_DatePart = v_SortingKey.getPrefix("T").toDate().toString("yyyy-MM-dd");
v_TimePart = v_SortingKey.getSuffix("T").getPrefix("+").subString(0,5);
v_SqlDateTime ...
... as `total`, `value`
FROM (
SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value`
FROM (
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(ExtractValue(t.`introtext`, ...
... return v_Output;
}
This is my preferred method and it will return a string of 5 random uppercase letters.
Method #2: Convert time to letters
I've previously used substring to extract the ...
What?
This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again.
Why?
I want to modify a picklist and fill ...
...
AND t1.`extension`='com_content'
AND t2.`extension`='com_content'
SET
c1.`catid`=t1.`id`;
-- Joe-Code: LIST Rows to be affected (for test purposes)
-- SELECT SUBSTRING(a.`name`, 1, INSTR(a.`name`, ...
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.