Search - Joel Lipman .Com

1. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... print (6 June 2022) and I wanted to make sure it didn't 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. ...; Created on 29 June 2022
2. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... 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 would be referring to 2 status ...; Created on 11 February 2022
3. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... 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 v_Test3.toString().replaceAll("^(^-?\\d+\\.\\d*[1-9])(0+$)|(\\.0+$)", ...; Created on 08 February 2022
4. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... 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 variable names: // select a bunch of creator records ...; Created on 17 November 2021
5. Zoho Creator: Change Radio into Tabs: / Zoho /; ... 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 ...; Created on 22 October 2021
6. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... 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 a text editor, then escape the double-quotes, then prepend with ...; Created on 19 October 2021
7. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; 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 ...; Created on 11 January 2021
8. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; What? This is an article documenting how to create a Zoho Creator Widget which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at ...; Created on 24 October 2020
9. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... 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 documentation that says "This task ...; Created on 19 October 2020
10. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... 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 ...; Created on 27 September 2019
11. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; 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 ...; Created on 10 July 2019
12. Zoho Templates - Font size is inexplicably tiny: / Zoho /; ... floating over it at the center of the page as well as a logo fixed to the header of every page. The logo image was quite a big image at 2501x805 pixels. By resizing it to the final output size (464x99 ...; Created on 22 February 2019
13. Accessing Apimo WebService API: / API Miscellaneous /; ... server request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as the error messages were somewhat ...; Created on 29 March 2016
14. Sort an associative array by values in Javascript: / JavaScript /; What? An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. ...; Created on 29 September 2015
15. Convert XML UTF-16 to JSON UTF-8 with PHP cURL: / Personal Home Page /; Previously titled Fix PHP cURL: parser error: Document labelled UTF-16 but has UTF-8 content What? This is an article with notes for me on how to convert some received XML encoded in UTF-16 to ...; Created on 28 March 2015
16. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; ... CHARINDEX(@Delimiter, REVERSE( @Haystack )) -- yields "8" SELECT SUBSTRING(@Haystack, CHARINDEX(@Delimiter, REVERSE(@Haystack)), LEN(@Haystack)) -- yields ".String2.String3.String4" Not quite ...; Created on 28 January 2013
17. Delete related records from multiple tables: / MySQL /; ... statement but I've added it here as I use it quite often: SELECT s.sessionId, ssf.sessionId, sst.sessionId FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT ...; Created on 11 January 2013
18. Sync Outlook 2007 Shared Calendar with SharePoint 2007: / SharePoint /; ... to open the event and specify the recurrence rate. Sharing is Caring Now my colleagues have set up the calendar in their instances of Outlook, they can also add to the calendar quite easily as we ...; Created on 09 November 2012
19. The greatest invention in IT: / IT Support /; ... 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)." Source: Behavioral ...; Created on 13 September 2012
20. Basic Joomla 2.5 Mootools Form: / Joomla /; ... Additional Notes You have no idea how long it has taken me to get this code in working order and as easy as it may be to others, this has been quite a challenge. I have tried so many examples, ...; Created on 20 August 2012