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 ...
...
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 ...
... is attached to the last record of the source data
File identifying number is returned from being attached
File is opened in a new tab/window to trigger downloading.
File is deleted from attachments ...
... you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include ...
What?
This is a very quick article on sending an email with Deluge which needs a dynamic number of files attached to it.
Why?
This came up during a call with another developer and it occurred ...
... to work using Zoho Deluge.
How?
There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names:
//
// ...
What?
There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with ...
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.