Assuming code is required, the following 267 results were found.
-
With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As Worksheet On Error Resume Next...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
website admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you got from revolvermaps.com into the module parameter. Important Note: The ID it installs with is for my demo site. If you...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Here are two screenshots to demonstrate the issue: Screenshot #1: This screenshot is of the PDF preview of my HTML code where I've had to set the font size to 46pt throughout the template: Screenshot #2: This screenshot is of the PDF preview of my HTML...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
year starts from January, simply divide by 3... How? I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
ZohoCRM.settings.ALL ZohoCRM.users.ALL or to be safe ZohoCRM.modules.ALL ZohoCRM.settings.READ ZohoCRM.users.READ Problem: Code 37: The HTTP method PUT is not allowed for the requested resource This was an issue where I was trying to push a Zoho Creator...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Document (the file upload field) Downloaded (a picklist with the options "Downloaded" and "Pending Upload") Here's the code for the parent form to download the attachments and upload them to the Creator "Document" form: // // get attachments...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
A quick article with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration. Other...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is our friend. How? So we'll run a workflow that triggers on the creation of a lead and runs a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the part of adding the various field placeholders onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
app for a webhook response, would result in the end customer suddenly downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
cd to the new project name To give permissions to write sudo chmod -R 777 . open the newly created widget.html file in your code editor add the code as per the below generic script when done, save 'widget.html' then return to terminal and type zet...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for a bit. Their solution only permanently sets the default sort order to WEBLINK TITLE in order from A to Z. The below code with my modifications maintains the functionality for the user to change the sort order by clicking on the column titles. The...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
form... There are two solutions I have found that fix the problem: Method #1 I prefer this method as it changes less code and is more likely to be supported in a Joomla update. Open the file /plugins/captcha/recaptcha/recaptcha.php and find the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
browsers. If you need more, you need to edit your PHP.ini file. 4. Test your PHP file can process the data Add the following code to the receiving PHP file: echo "Upload: " . $_FILES["uploaded_file"]["name"] . " "; echo "Type: "....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! What follows is the code I'm using to convert this: v_Endpoint =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code. Obviously just omit the HTML rubbish if you want to create a calendar using just autohotkey syntax. Actually, the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
to: Microsoft Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
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 Monitors and Check it can...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB