Assuming quick is required, the following 247 results were found.
-
A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than proposing an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article on how to use remove() on a map variable as well as a snippet of code to copy tags from a contact to a deal record. Why? Anything that stumps me for 30 minutes is worth writing a quick article on. In this case, I had a function querying...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Apologies for posting yet another article on how to access the Joomla Database using the Joomla classes but this is just a quick note for myself as a reference sheet. Plus the official documentation don't have enough examples in my view. Source:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
are "checked-in" (Do a "Global Check In") Install new Joomla: Install Joomla! CMS v3.4.x with Demo Content (eg. 3rd-party QuickStarts): [Personal Option] Modify admin ID to NOT use a text editor (ie. "Text-editor=None") If you are going to delete an...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
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 in the old column and which ones are new... Why? Consider the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using the MidJourney Bot Signup to Discord.com Visit Midjourney.com Go to the Midjourney's discord...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. Unless you can monitor when these type of schedules are failing,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
I'd put a quick note here, I tried a fair few solutions that didn't work and then found this hidden away in a forum: Quick Count =INT(SUMPRODUCT((A3:A1000"")/COUNTIF(A3:A1000,A3:A1000&""))) This returns the number of unique values in the range A3 to...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
What? A quick follow-on article to my previous article on Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. Why? Connecting to OpenAI ChatGPT is all very well and good, but this forgets what you were talking about after each chat. So it's good for 1...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article could help others. It's also a chance to show off my build....
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
:= ComObjCreate("Scripting.FileSystemObject").GetFolder(UserFolder).Files.Count FolderCount := ItemCount - FileCount -- quick if looking at one directory. -- just as slow if looping for subdirectories: Loop, %UserFolder%\*.*, 1, 1 { ThisFolder :=...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the drive and display the size of all the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
allocate. They will do the investigative work to get the service up and running again. Having a small chain-of-command and quick development cycle, there are advantages to working on my own: I can keep costs low, I have scripts which have sped up...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
A quick note on how to copy files and folders over without overwriting existing files. It's easy to say "Yes" and replace all files. What I need is something that synchronizes files on an internal hard drive to an external one. I wanted it to copy only...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
this plugin is mostly hard-coded and most of the parameters have no effect. It was initially built for someone as a quick syntax highlighter that recognizes SQL; but I am working on getting it to recognize more programming languages so that I can use it...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *