Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3){width:75px;} Then I format the value within the span to make the date more prominent: div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Generate Bank Text File for Downloadhttps://joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 (as in browser downloads it to the computer immediately) and then removed from wherever it was downloaded from... All within ZohoBooks without using any other apps or software. How? Here's how to use it: Staff member clicks on button File downloads to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want a solution which sits on an external website and which talks to Zoho, then setup an externally hosted...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

25 March 2024 is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a file to be hosted within Zoho Creator for use by a JS widget that will...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 the process to tidy these all up would leave the data more and more unreliable. So Shopify want your webhooks to respond within 1 second. This is about enough time to store the record but that's it. Processing the record must be done at a later time or...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 off to contact email Contact completes and signs the form via ZohoSign ZohoSign on completion triggers worklow from within ZohoCRM ZohoCRM webhook updates the tracking record (ZohoSign Document) and attaches the signed document to the contact record...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 URL (in that exact order), and respond to eBay with an HTTP 200 OK status, including the hashed result in JSON format within the challengeResponse field. The response's Content-Type header must be set to application/json. The following instructions are...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MacOs: Transcribe Training Video using OpenAI Whisperhttps://joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 ffmpeg -i output_audio.mp3 -f segment -segment_time 600 -c copy output_chunk_%03d.mp3 Install Python and PIP Still within the terminal: brew install python Upgrade to latest PIP: pip3 install --user --upgrade pip Install Numpy As user (safest): pip3...

• Type: Article
• Author: Joel Lipman
• Category: Apple
• Language: *

ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 TaxType name and return a Zoho Tax ID (64-bit unsigned 19 digit integer) but that's more use when writing to Zoho Books. Within ZohoCRM, we only need the name and in this case the percentage rate: string standalone.fn_Xero_MapTaxRates() { /*...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 JoelLipman.com and its associates provide their services to you subject to the following conditions. If you visit or shop within this website, you accept these conditions. Please read them carefully. Privacy Please review our Privacy Notice, which also...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Disclaimerhttps://joellipman.com/static-items/disclaimer.html

30 May 2009 of those sites. The inclusion of any links does not necessarily imply a recommendation or endorse the views expressed within them. Every effort is made to keep the website up and running smoothly. However, Joel Lipman .Com takes no responsibility for,...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

How to redirect the visitor after the contact pagehttps://joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 as i have not tried it. Step One: First if you don't already have a page that you want to redirect to, you will create one within the Joomla 1.5 admin interface and make sure it is published. I have tried the method below with both an article and a...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 of how to do it here. The issue is that I wanted to make my autohotkey program change the image that the mouse hovers over (within it's own GUI). No third-party component or dll needed, just a slight modification to the mousemove tooltip in the...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Creating a Top 10 chart with less codehttps://joellipman.com/articles/web-development/php/creating-a-top-10-chart-with-less-code.html

18 February 2010 I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

Project Plan for Freelance Websitehttps://joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 (Internally Centered? / Customer Focused?) Outsources? (Is JoelLipman.Com Project Manager? other 3rd-parties?) Contacts within Client company? Budget (see Rates for Joellipman.com below) Similar looking websites and colour schemes Will the website be...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joe's Unduplicater (JUD)https://joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 http://www.joellipman.com/. OTHER NOTES: This program does not install any files. You can run it off the executable (EXE) within or run the Autohotkey file (AHK) if you have AutoHotkey installed on your computer. It was created in AutoHotkey and the...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Blank columns issue when exporting to Excel (Data Only) from Crystal Reportshttps://joellipman.com/articles/microsoft/excel/blank-columns-issue-when-exporting-to-excel-data-only-from-crystal-reports.html

15 June 2010 to use the newly uploaded report, export to a Crystal Report, which in turn we export to Excel: Note that as this is from within a web application, there are no extra options or dialogs to select. The export had to work from this point on. I can't take...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: *

UTF8 Unicode PHP MySQL for International Charactershttps://joellipman.com/articles/web-development/php/utf8-unicode-php-mysql-for-international-characters.html

22 October 2010 solution was to make the script run a MySQL command at the start: SET NAMES 'utf8' Now I need to run this command from within a Joomla! extension using the mysql Joomla! classes, here's how I've used in this script pulling IDs and titles from the a...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 In case you've been stuck for ages (as I have), I found out you cannot declare the parameters used by the software within the SQL script... So the above should look more like this: --...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

SQL Calendar in Business Intelligence Development Studiohttps://joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 I find myself searching the web for a way of producing an outlook-style calendar within Business Intelligence Development Studio (BIDS). Weekdays along the top and then dates inside. Additionally we would like this linked to events in a database. I'm...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB