Assuming that is required, the following 494 results were found.
-
the string to search (in this case a single cell value). Sheet2!$A$1:$A$4 is the range of words to find from Sheet2. Note that there is a dollar in front of both column name (eg. "A") and the row number (eg. "1") so that these don't automatically change...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing each year despite it's expiry in a couple years time. The...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
must have been so obvious to everyone else that nobody bothered to write an article on it... till now. Situation I have a report that returns room bookings based on a user and given a date range. The problem is that there are a few thousand users and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Well we're all happy that the iPlayer from the BBC has come to PS3 in Europe but I'm less impressed about the multi-audio output. My setup is that the sound goes from the Playstation to the Sound System via Optical Out. I found that if you do enable...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
use the Chr() function: msgbox % Chr(24) ; upwards arrow msgbox % Chr(25) ; downwards arrow, unstable Generate list of those that work for you: loop 255 fileappend,% a_index . A_Tab . A_Space . Chr(a_index) . "`n",ascii-chartable.txt A bunch of others...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Windows 7 Professional - Service Pack 1 AutoHotkey v1.1.33.02 What? So this is the documentation for a snippet of code that will list files of a directory using an AutoHotkey GUI and display what it will name them. The app needs to rename files but...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
and your IT service desk say everything is functioning normally and it's just YOU! Script Function If you are on a network that frequently loses connection or simply forgets what intranet site you were trying to access and your usual solution is a...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
other scripts but do I really need a complex solution? So here I am making my own again. I wanted something really basic that simply lets me style content within the tags: Use PHP or JavaScript (avoiding Framework conflicts) You select what words are...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
» Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
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... well it's not really random, it involves getting the milliseconds from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article because there was no documentation that I could find that describes how to do this. When an invoice is created, not by clicking on the "convert sales order to invoice" button, I needed a way to programmatically link the sales order to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember is that all multi-select lookup and multi-user lookup fields are held in temporary CRM modules called a "LinkingModule" (as opposed to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
backend code, Zoho refer to Issues as "Bugs". Why? At time of this article (Apr-2021), we could not find a working example that could allow us to do this. I have provided some links at the end of this article for you which we tried to use but only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
At time of print, the documentation on the Projects API would only show responses rather than requests. Sure it lists fields that are required in the request but not a sample request packaged to be sent. How? Let's assume that my custom fields have as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
solution. How? So the article below shows how to do this Zoho CRM and how to do it in Zoho Books... The example below is that we are going to search for some records in Zoho Creator and display these in either Zoho Books or Zoho CRM. For demonstration...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve a list of all the listed active products in a fixed price item listing. The example below is a function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has to go to the CRM record, click on Mail Merge, which opens Writer, then has to click on various settings...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's Time Zone" on the lead record in ZohoCRM. It should be auto-populated... How? As...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *