Assuming numbers is required, the following 43 results were found.
-
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 ID,Name,Phone,Record ID...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Right-click on "shell" and create a new key with the action name (eg. "Prefix_with_line_numbers") Right-click on this new key and add a key to this one called "command" Under the "command" key, double-click the "(Default)" string in the right-pane and...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Just a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop := (OutputVar // 3) DNum = 3 Loop, % (NumLoop+1) { StringRight,Digit,Result,%DNum%...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both for outbound and inbound but local to the customer and we want to remind our customer that they have an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or strings. There are workarounds however. How? The first note is that there is something that can emulate a random number......
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
aware of is a regular expression. So the first expression I came up with worked to a certain point but didn't round up the numbers, in other words, it didn't remove the unnecessary zeros. Note that in the following regex, and if using Zoho Creator, you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Why? Playing around with VAT / Tax, inclusive /exclusive, but in this case it is the rate that gets rounded. The numbers at the end still need to match what's in CRM and with ZohoBooks rounding differently can make cent/penny errors into 100s of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Mod 2, "WhiteSmoke", "Garamond") This is telling the report to be white (=#ffffff) in row 1 (odd row numbers) and a very light grey (=#eeeeee) in row 2 (even row numbers). The first row being of all rows in the dataset and not for a particular...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to be a floating point value BOOL Forces the value to be true or false WORD Strips anything that is not letters (including numbers) ALNUM Forces the value to be alphanumeric (Letters and numbers only. No special characters) CMD Forces the value to be...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
It ignores spaces before and after any text. If you haven't specified a name, then it just reverts to using 6 digit numbers. Question Something has happened to my images folder, does it matter? Answer: No, the program checks if a folder called...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
you to change name and photo) Tap on the Manufacturer or Model name under "Specification" to change the details (lots of numbers!). Tap on Quick Reference image to change image. (if you have a different led, you can take a picture or use a screenshot...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
+ "]"; info l_ProductIDs.size(); } Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
{ // // invalid searches will return 200 results non-matching, so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
2019 dateValue = '29-Dec-2019'; info dateValue.toString("YYYY"); // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() ==...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *