Assuming article is required, the following 356 results were found.
-
A quick article on if you want to extract the link from some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
A quick article on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password. How? This...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to: CSS HTML What? A quick article on how to get a div layer to increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
A super quick article to show how to link to the thumbnail image of a Google Drive file, in this case a video file. How? The hardest part of this is to get the Google Drive File ID (which you need for the below). The image link (src) will be as below...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Zoho Deluge - MD5 functionhttp://www.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html
So this is NOT an article on how to create a MD5 function for an ETag in Zoho Deluge as I expected it would be. At time of print, the Zoho documentation (and Google search results) make no mention of using MD5 in an encryption task. Why? I'm trying to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
So I thought I'd write an article to help me resolve the particular issue where the organization details and the header of the product line items table would display on the first page, the product line items would then print on the second page, with the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
Calculate Aspect Ratiohttp://www.joellipman.com/graphic-design/calculate-aspect-ratio.html
So this is a quick article on how to maintain an aspect ratio when resizing an image. How? These are the calculations to work out the new height given the width or the new width given the height: (original height / original width) x new width = new...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments Deprecated: Methods...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A super quick article to demonstrate an example where we create a project with custom fields. Why? 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- 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
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF