Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that will be displayed under the "Search Only:" heading and then a list of components. Find...

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

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 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 documentation and it worked! There were a few adjustments to make which I'm documenting...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 has focus in the first subroutine "RunAll". Here's a quick summary of what the below script does: Splits one spreadsheet to several sheets within the same workbook. Inserts a blank row at the top of each of the created sheets. Copies the header from the...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? Zoho doesn't have a function to generate random numbers or...

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

CSS Ordered List 1, 1.1...1.10 Formatting and Alignmenthttps://www.joellipman.com/articles/web-development/css/css-ordered-list-1-1-1-1-10-formatting-and-alignment.html

10 July 2019 outside) 1. Item 1 1.1 Item 1a 1.2 Item 1b... 1.9 Item 1c 1.10 Item 1d 2. Item 2 How? I've been refining this based on several examples and the following solution seems to be the most stable: ol { list-style-type: none; counter-reset: myCounter;...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 find any search result via Google or DuckDuckGo (can't say for Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 me and sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 !important;} .fa.fa-close::before,.fa.fa-close::after{background:#999 !important;} 2. Trigger the notification There are several ways to display this as a popup, the first use example is on report workflow (click of a button in a report row) but I've...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 as little time as possible of the third-parties involved, plus the documentation online was in parts and requires going to several pages across the Internet. Here I have 1 page and 1 article documenting the process. How? I'm breaking this down into 3...

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that...

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

Zoho CRM: Get Unique Values of a Text Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

08 October 2021 } ], "info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 > Date and Time Settings); so as soon as you try to insert a date time and perhaps accompany that value with a timezone, several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 an article. The ability to block field picklist options from being selected based on the profile of a user. Why? There were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would have a...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 The Attachments folder must contain no subfolders and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with...

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

Splatter Logohttps://www.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 Shop Pro and felt I could do the same. It's just so complicated in Photoshop when web-developers need to be able to run several programs at the same time and simplicity is king. In PaintShop Pro you would simply: How? Insert text as floating, leave the...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

MyALN.bournemouth.ac.ukhttps://www.joellipman.com/component/content/article/myalnbournemouthacuk.html?catid=33

07 September 2010 MyALN is a web-project where the original developer ended their support for the site. I was called in to fix several underlying issues and integrate it into the university systems. The Additional Learning Needs team at Bournemouth University use their...

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

MySQL Updating a database table from another tablehttps://www.joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 A quick article on how to populate a database column from another table using a string comparison. Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written...

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