Assuming going is required, the following 158 results were found.
-
3000 rows each, and then output each sheet to a separate file that is formatted as XLS (Not *.xlsx). How? In summary, we are going to move the Excel file to a folder of its own. We're going to run two VBScripts in two stages, firstly to split the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Note that you have to do this as the super admin to get organization level messages. But in ths example below, we're going to query a message to the ChatGPT bot: // // initialize m_Response = Map(); v_Message = message.trim(); v_ChatID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
moved the bottom screens in the display settings to be next to each other as I found moving my mouse from 4 to 5 involved going up to 2, right through 3 to 1, then down to 5... Now it all blends together: Error(s) Encountered: DisplayPort to DVI cable...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
methods for controlling webpages, similar to how the AHK Control Commands can control Windows Applications. This tutorial is going to be high level, but will provide links to those who want to dig deeper into these concepts. You don't need to have much...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
monitors... and now multiple desktops. How? The following example is assuming you have 3 monitors and 3 desktops. I'm going to cover the basic code to: 1) get all monitors, 2) open an app on a specified monitor, 3) switch to another desktop. Count...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
available for download 24/7 so in the event that we lose contact with each other, the project manager has the option of going to another developer with the source files in order to continue the work. JoelLipman.Com will produce a signed-off production...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Windows XP Microsoft Windows 7 Microsoft Windows 8 for Vista and Windows 2008 without XCOPY, try ROBOCOPY. How? We're going to use MS-DOS because I'm that old. Robust File Copy: Open a command prompt (Start > Run... > CMD > ok) Type the following:...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
restrictions in a given area Description As a quadcopter flier myself, I wanted an app to show me a map of the area I was going to film or fly. I wanted it to display the flight restrictions of the area and any other hazards I might need to take into...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
various methods, so here's a couple using the built-in functions of Zoho deluge. Method #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, 2, 3,... 29,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the owner of the Creator app to another person and adding our previous Super Admin account as a "Developer". How? I'm going to demo two methods here using the Setup the Connection Link Login to ZohoCRM as the creator super admin/owner (might not be the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
oauth token","status":"error"}: Can happen if the request is out of scope but also if your endpoint is going to .COM instead of .EU (or vice-versa). You can check this by logging into your Zoho product (eg. CRM) and looking at the top level domain // If...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
In the following code, consider that the date field we want to set is called "Switch_Over_Day". For the first Monday, we are going to select the first day of the month and then loop until we find a Monday. Same for the last Tuesday except that we will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho OAuth Connection: ERROR_invalid_operation_type Sounds...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
have to do it this way apparently. So setup a Zoho Oauth connector (see the end of this article if you don't know how), I'm going to call mine myZohoConnector, with the scope: ZohoCRM.settings.fields.READ Then check your URL is correct. The format for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and discussion forums that do cover this but it takes me so long to find the solution with the right syntax. How? So I'm going to start with 1 method and then update this article with other methods. Method #1: Display and access without login So the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
type: GET connection: "joelconnector" ]; How? So in the following example, we are going to setup a connection in Zoho Books on an EU datacenter: First determine what datacenter your client is using Register the App Setup the Connector How do I determine...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to style the notification as any modal would. 1. Create a page This will be the page containing the styled modal. I'm going to call it "Notify". Add the 2 parameters p_NotifyTitle and p_NotifyContent to the page: Then drag a HTML snippet onto the page...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
code to search for and count holiday clashes: First we need the code to search for other requests with these dates, we're going to use a range of 1 month before and 1 month after the requested date (so this works as long as no one books longer than a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that usually I could customize the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *