Search - Joel Lipman .Com

1. Joomla Development: Possible XML Filters: / Joomla /; Applies to: Joomla! CMS 2.5.x Joomla Filter: Validation OnSave INT Forces the value to be an Integer UINT Forces the value to be an absolute number (-4.2 becomes 4.2) FLOAT Forces ...; Created on 17 October 2013
2. Excel PivotTable Filter List Ordering: / Excel /; ... summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a ...; Created on 05 September 2011
3. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... to assign the sales person. How? So after an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next ...; Created on 30 August 2021
4. ZohoCRM: Process all records of a module: / Zoho /; ... doesn't matter as long as it's a field to update In your code, sort a list by "Modified_Time", loop through and update each iterated record. (see sample code below). Go to the list view in CRM and filter ...; Created on 24 August 2021
5. Windows 10: Shortcut Apps to Settings: / Windows OS /; ... ms-settings:easeofaccess-audio Closed captions ms-settings:easeofaccess-closedcaptioning Color filters ms-settings:easeofaccess-colorfilter Cursor & pointer size ms-settings:easeofaccess-cursorandpointersize ...; Created on 30 July 2020
6. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... filter words a_FilterOutWords := [" (1)"," (2)"," (3)"," (4)","- Copy"] Loop % a_FilterOutWords.MaxIndex() v_NewName := StrReplace( v_NewName, a_FilterOutWords[ A_Index ], ...; Created on 08 July 2020
7. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex ...; Created on 04 May 2020
8. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave ...; Created on 28 June 2019
9. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... I need to add a filter which blocks out swear words and the such. Experimental - DO NOT USE: string generateRetrievalCode() { // ... refer to above functions } string generateKidSafeRetrievalCode() { ...; Created on 09 May 2019
10. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
11. Protecting your Joomla Administrator Section: / Joomla /; ... of whether you have logged out of the CMS). Add an IP filter To include this method, ensure you have a static IP address (most home broadband users are now assigned these by ISPs so that they ...; Created on 23 October 2015
12. List of Font Awesome: / Web-Development /; ...  fa-files-o []  fa-film []  fa-filter ...; Created on 04 September 2015
13. Joes Search Module (JSM): / Product Documentation /; ... these to the following: action = /index.php?option=com_search method = post role = search Issues Further searches do not include the same filters. This will be because the setting to ...; Created on 09 March 2015
14. Two icons created on Android: / AndroidOS /; What? If you're installing an app and it creates two icons: Why? I don't think I'll forget this one but I was stumped for a bit until I found it on the a forum: Stack Overflow: Android App Development. ...; Created on 20 October 2014
15. MS Excel - Sort pivottable column headings by date: / Excel /; ... made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields go in "Report Filter", "Column Labels", "Row Labels" and sum "Values". But because ...; Created on 12 April 2013
16. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I ...; Created on 28 January 2013
17. Joomla field types clear my html: / Joomla /; ... - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no wonder customers have difficulty following. How? So it's the field on the XML file /models/forms/whatever.xml which needs the filter=raw ...; Created on 09 August 2012
18. Drop If Object Exists: / Transact-SQL /; ... Replication-filter-procedure S = System base table SN = Synonym SQ = Service queue TA = Assembly (CLR) DML trigger TF = SQL table-valued-function TR = SQL DML trigger TT = Table type U = Table ...; Created on 03 August 2012
19. Select unique values in Microsoft Excel column: / Excel /; ... data range to do this to. Click on the "Data" tab. Click on "Advanced" (Advanced Filter). Tick the "Unique records only" box. A few more from Microsoft Office Help /* Count the number ...; Created on 03 July 2012
20. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... Resource Note there is no WHERE clause because we're going to use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution. Add in the ID of each entry ...; Created on 24 August 2011