What?
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday.
Why?
I think it's the US system which generally says that a week starts on a Sunday ...
... to the same school and updates some number fields on the matched CRM account.
Why?
For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was ...
What?
This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway).
My Data:
Account ...
What?
This is a quick article on how to convert some cells in Microsoft Excel to number values...
Why?
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...
What?
So this is an article to list methods of retrieving the number of files in a folder/directory.
Why?
Why can't we just use a loop and file pattern native to the Autohotkey programming language:
UserFolder:="C:"
-- ...
... "Joel Lipman" has a degree in Computer Science BSc and some qualification in being Superman.
Specification
The output expected by the customer is the following:
EMP
--------------------------------------------------
EmpNumber ...
Intro
Prefixing lines with their respective line number in a text file using a Microsoft Windows Operating System... I've just googled this as I couldn't remember how I did this last time and a number ...
... break
}
}
Return Result
}
Use as per usual:
ValueWithCommas:=FormatAddCommas(NumberWithoutCommas)
One taken from the AutoHotkey forums:
AddCommas(val)
{
...
Just a quick note here. This is an article based on the REG file from Kelly's Korner (@www.kellys-korner-xp.com/xp_tweaks.htm). I'm not fond of downloading REG files and running them even if I have checked ...
... are events in the past; status is a mandatory field
// NB: range is an integer and the number of records to return (default=100; max=200)
// NB: index is an integer and is the offset or starting index ...
... po."Purchase Order ID" AS "PO ID",
po."Purchase Order Number" AS "PO Ref",
po."Purchase Order Date" AS "PO Date",
po."Purchase Order Status" AS "PO Status",
poi."Item Name" AS "PO Item",
poi."Ite ...
... to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/"
v_WorkspaceID = "12345000001234567";
//
// to get the Analytics Org ID, login to Zoho Analytics, ...
... and vice-versa.
And in this use-case, my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the ...
...
How?
So first, this article shows you how to setup an API connection, and then we'll include the code to count the total number of products, and then finallly show the code to loop through all the ...
... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers):
//
// Generate a CSV of a ...
... module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the ...
... number "OrgId" there
Note this down for later use
Get the ZohoAnalytics Org ID:
Login to ZohoAnalytics and ensure you are at the "Home" level
Click on the cog icon in the top-right for "Settings" ...
... escaping backslash in the value: (Last_Name:equals:K\\)
After encoding the value: (Last_Name:equals:K%5C%5C)
To search for Date, DateTime, Lookup, Number, Currency, Boolean fields, you need comparators ...
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.