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 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 templates and want the HTML to be...

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

Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 of each month, to say the first Monday of the month (ignoring bank holidays) or to say the last Tuesday of the month. How? Quite easily. For the first Monday of the month, it is likely that even if today was the first day of the month and coincidentally...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 -- COLLECTION value cannot be assigned to 'mySubform' or expecting ZC_SUBFORM_70 expression found COLLECTION expression How? Quite simply the error is because the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to what the...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at time of print (2020-10-24), Zoho Creator does not allow you to use JavaScript anywhere in its app. HTML and CSS...

• 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 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, last_name,...

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

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 client but would need adapting to match the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have tabs along the...

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

Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 = r_SubformRow.Start_Time; } } // yields // UnPredictable exception, Invalid statement found Line:(20) The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different...

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

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 v_Test2 = 12.000; info v_Test2.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false); // yields 12.000 So this isn't quite right, so let's get a regex that rounds numbers up but pays attention to where the decimal point is: v_Test3 = 12.000; info...

• 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 read-only to first-line agents also wouldn't help as some of the options should be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent...

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

Amazon Kindle: Send PDFs to your Kindlehttps://www.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 just disappear or be difficult to find in future. How? The process of sending a PDF file to your Kindle device is also quite straightforward. All you need to do is send the PDF file to your Kindle email id. It is here that things might begin to seem a...

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

First and Last Entry on a Page using Modulus Remainderhttps://www.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 I know it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 I shouldn't say unfortunately as I don't see myself doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string...

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

The greatest invention in IThttps://www.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo' command)."...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *