Search - Joel Lipman .Com

1. XML Stylesheet Language Transformations: / Category /; Created on 05 March 2020
2. Information Desk: / Contacts / Uncategorised /; Information Desk; Created on
3. AutoHotkey: Get Media Information and Display: / AutoHotkey /; ... , "System.Audio.Format" , "System.Audio.IsVariableBitRate" , "System.Audio.PeakValue" ...; Created on 07 August 2020
4. 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
5. SITS: XET format for Export not available: / Extensible Markup Language /; 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 ...; Created on 08 August 2014
6. AutoHotkey Format Date and Format Seconds: / AutoHotkey /; ... straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString, %Format% return Formattedtime } The following function is to convert a given SQ ...; Created on 20 September 2011
7. Format Numbers in AutoHotkey with Commas: / AutoHotkey /; Just a quick note as I use this function in various scripts. This adds the 1000th separator comma: FormatAddCommas(val) { Result:=val StringLen, OutputVar, Result NumLoop ...; Created on 20 September 2011
8. Unix Date Format Specifiers: / Linux /; I could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) ...; Created on 05 July 2011
9. Formatting a date in an MDX query: / Transact-SQL /; Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as: =FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate) The ...; Created on 11 January 2011
10. Transact-SQL Date Format Conversions: / Transact-SQL /; Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx; Created on 19 November 2010
11. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to ...; Created on 12 February 2010
12. Converting SQL date in PHP to European date format and vice-versa: / Personal Home Page /; ... specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given ...; Created on 17 September 2009
13. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... is to be multiplied by 16 and then added to the value of the 2nd; this equals the RGB value. Given #00FF00 // // given value v_HexGiven = "#00FF00"; // // transform or format the submitted ...; Created on 11 October 2024
14. Zoho Workdrive: Getting Team Folder ID: / Zoho /; What? This is an article to document how to get your team folder ID, retrieve information about it, and upload to it via the API. Why? The documentation is there but making sense of it, is somewhat ...; Created on 11 September 2024
15. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Modified: 2024-08-21 (Joel Lipman) - Creates a recipient and event record in CRM More Information: https://www.zoho.com/deluge/help/sign/get-template-by-id.html ...; Created on 06 August 2024
16. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... Analytics to display different images based on a criteria or a value within a data table. As documented in an earlier article, put the URL of the image, then change it's format to show the image and not ...; Created on 25 July 2024
17. Zoho Projects: Get All Events: / Zoho /; ... send to. Here's some code to get the last 50 events: // // *********************************** // get Zoho Projects information v_BaseURL = "https://projectsapi.zoho.com"; v_Heading = ""; // // ...; Created on 22 July 2024
18. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... - Initial release Date Modified: ??? - ??? More Information: https://www.zoho.com/analytics/api/v2/bulk-api/export-data.html ******************************************************************************* ...; Created on 09 July 2024
19. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
20. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... this at the end of this function. Error(s) Encountered ,"message":"invalid reminder time","status":"error"} There was nothing wrong with the date time format here. Just that I was submitting a TRIGGER=DATE-TIME ...; Created on 14 May 2024