Search - Joel Lipman .Com

1. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; ... p_QuoteID is the ID of the quote): // init Map m_UpdateQuote = Map(); // r_QuoteDetails = zoho.crm.getRecordById("Quotes", p_QuoteID); v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * ...; Created on 20 August 2019
2. Convert seconds to total time in PHP: / Personal Home Page /; ... to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":"; $total_time.=str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":"; $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); // ...; Created on 31 January 2012
3. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... r_CreateTimeLog; You will find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06 ...; Created on 30 April 2021
4. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees ...; Created on 10 December 2020
5. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... l_Quotes) { v_ContactFname = ""; v_ContactSname = ""; v_SubTotal = 0.0; v_TotalVat = 0.0; v_Total = 0.0; v_Total_Tax_Factor = 0.2; for each r_Quote in l_Quotes ...; Created on 06 December 2020
6. MySQL: Count occurrences of words in a column: / MySQL /; ... of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) ...; Created on 12 March 2020
7. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let ...; Created on 02 September 2019
8. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock" ...; Created on 22 August 2019
9. Excel - Check a column for values found in another column: / Excel /; ... purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 ...; Created on 14 February 2019
10. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... in the top right) ' Press F5 to run the code. ' You will be prompted for the total range (eg. $A1:$W36000) ' And then prompted for the number of rows per sheet (eg. 3000) ' Run everything Sub RunAll() ...; Created on 11 February 2019
11. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... Subroutine: LoopThrough: loops through folders and counts file sizes (including subfolders) LoopThrough: SB_SetText("Reading current directory...") vTotalSize = 0 Loop, Files, %MyBaseDir%\*, F { ...; Created on 28 January 2019
12. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; What? A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above ...; Created on 24 September 2015
13. XML Schema Reference: / Extensible Markup Language /; ... zero pattern Defines the exact sequence of characters that are acceptable totalDigits Specifies the maximum number of digits allowed. Must be greater than zero whiteSpace Specifies how ...; Created on 13 August 2014
14. AHK Countdown Tooltip: / AutoHotkey /; ... ; TOTALS ThisManySeconds:=DateDiff( A_Now, FinalDate, "s" ) ThisManyMinutes:=Floor(ThisManySeconds/60) ThisManyHours:=Floor(ThisManySeconds/3600) ...; Created on 17 July 2014
15. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... are not populated. In addition, we also need a second dataset in our report which gets the total count of all the rows matching the selection criteria (the parameters). The concern was that this ...; Created on 07 March 2014
16. Export Joomla Users script: / Joomla /; What? Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why? Why? I want to move a client's list of Joomla users to a new system which ...; Created on 28 February 2014
17. Generate a Timesheet in MySQL: / MySQL /; ... environment but the SQL basics are here to help me adapt it to whatever environment people keep throwing at me. What I want: ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday ...; Created on 05 December 2013
18. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... ComObjCreate("Scripting.FileSystemObject").GetFolder(ThisFolder).Files.Count FolderCount := ItemCount - FileCount TotalFileCount += FileCount TotalFolderCount += FolderCount } ...; Created on 04 June 2013
19. Proposed Budget i3 PC under £200: / IT Support /; ... and Emergency Eject - Sony £17.77 Other 2 X Serial ATA Sata Hard Drive Data Cable Lead - Unbranded £0.90 Total £189.75 Confirmed for January 2013 (2 suppliers): ...; Created on 26 January 2013
20. Slideshow div layer through a window: / MooTools Framework /; ... Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not using XML, or is that AJAHtml? AJAH?), anyway, we can send each new info to the next slide and use only two slides in total ...; Created on 11 September 2012