Assuming used is required, the following 201 results were found.
-
row 12 (so 2 rows will be returned). Sheet1$B11:AL Selects all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
:: MINimum file AGE - exclude files newer than n days/date. /MAXLAD:n :: MAXimum Last Access Date - exclude files unused since n. /MINLAD:n :: MINimum Last Access Date - exclude files used since n. (If n...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
in such a situation, here's the design mode of the report (apologies for the red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the page would end on a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
items somewhere. How? The fix that I use involves a change to #__menu table in the database for that website. The example used here will be to create an about-us page but I already have two items using the alias "about" and "about-us": Login to the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
for a module extension I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker. Script Function...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I tried the example as per the Apimo...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
The Gist Don't load in images bigger than an A4 sheet... Additional Notes I found that some classes are reserved words used by the Zoho built-in renderer. I am making a list here to see if that helps: Wrapping all your HTML in : Ok it's used in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
method and it will return a string of 5 random uppercase letters. Method #2: Convert time to letters I've previously used substring to extract the milliseconds into 5 numbers and get the remainder from dividing it by 26 (modulus)... This is NOT to be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article to document how to output the most frequently used words in a MySQL database column. How? Note this only applies to MySQL. So the following query will return a count of each word in your database column by order of most used first...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
example is at the end of the current month: so add 1 month, go to the start of that month, subtract 1 day. .toEndOfMonth() used to work but appears to be deprecated. Invoice_Ref_ID is excluded from being copied as it was an autonumber in our example....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Why? Setting up a connection avoids the hassle of having to generate access/refresh tokens using OAuth2.0. Usually used with an invokeUrl: response = invokeUrl [ url: "https://books.zoho.com/api/v3/estimates?organization_id=12346789" type: GET...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Deluge syntax I was using to insert subform rows was wrong. Contrary to what the documentation that says "This task can be used in the following events", effective as of today October 19, 2020, I have not found a place you cannot use this deluge script....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 only be used on a load of a form, on a change of a field or on the validate process. And because info can only be displayed to an admin and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Params.put("ApplicationDeliveryPreferences",m_AppDeliveryPrefs); /* only used for wireless applications? m_EventProperty=Map(); m_EventProperty.put("EventType","FixedPriceTransaction"); m_Params.put("EventProperty",m_EventProperty); */ // include the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
my home PC. The way to do this might be different for you depending on the components of your PC. So here's a list of what I used: Type Component Quantity Price (GBP) Reused components Monitor Acer K242HL 2 ~@£100.00 (at time of purchase) Monitor Dell...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging to the same school and updates some number fields on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the client script which will manage a subform. The module we are applying this client script to is a custom module called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots below are made up. the Attachments.csv A data backup or export of the Attachments from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF