Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 I found a cheat/workaround: Click on the list to see your datasheet (has a MS Access icon in the top left to remind you what you're getting yourself into) Go to Settings Select Create View Select Datasheet View (you could probably use a "Standard View",...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...

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

Joes Network Transmission Detector (JTD)https://www.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 this is a program I've been wanting for ages. Only way to be sure it doesn't have any malicious code and that it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network....

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

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which...

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

Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/articles/automation/ms-dos/batch-process-to-rename-multiple-files-using-windows-dos.html

09 August 2014 to: Microsoft Windows 7 Professional Ms-DOS Command Prompt (6.1.7601) What? A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and...

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

Add attribute xsl:nil=true on empty elements using XSLThttps://www.joellipman.com/articles/web-development/xml/xslt/add-attribute-xsl-nil-true-on-empty-elements-using-xslt.html

18 August 2014 What? An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...

• Type: Article
• Author: Joel Lipman
• Category: XML Stylesheet Language Transformations
• Language: *

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 to SITS:Vision v8.7.0 Uniface v9.6.03 Microsoft Windows 7 Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 What? "Quick" may not be the right word, so this is a somewhat summarized article on how to get data out of SITS, up to running the monitors and...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• 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 What? A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/invoice...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 What? A very quick article on how to push a multi-select picklist from CRM to Creator. Why? We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 What? This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading...

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

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name,...

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

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 What? This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes...

• 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 What? This is an article documenting how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 What? This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article...

• 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 What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column...

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

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

09 March 2022 What? Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on...

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

Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-error-code-2945-extra_key_found_in_json.html

04 October 2023 What? A quick article on how I resolved this error and how the online forums and documentation did not. Why? I don't often do this to create a Creator record but I'm going to use the shortcode function zoho.creator.createRecord() and wanted to update...

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

List last modified files using FTP Command-linehttps://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 So let's say my FTP client is not the most expensive (was FREE), nor the most advanced client out there, and I want to know what were the most recent files I modified and uploaded to a site, how do I do it using just Microsoft Windows? How? I don't have...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

SITS: XET format for Export not availablehttps://www.joellipman.com/articles/web-development/xml/sits-xet-format-for-export-not-available.html

08 August 2014 What? Trying to export a STU record but I want to use the XET template I created rather than the pre-installed XML export formats. When I try to export using data format XET, the system has never heard of it. Why? To test the XET I created, I want to...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

What's the problem? Amusing computer issueshttps://www.joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 the new corporate template for our website and it's not displaying properly on my colleague's computers". [Priority 1] What's a web guru? Well this might be obvious to some but these are self-proclaimed highly qualified web-gurus in the marketing...

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