Search - Joel Lipman .Com

1. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this ...; Created on 20 March 2023
2. ZohoCRM: Import Attachments: / Zoho /; ... := "1.0" v_GuiBgColor := "FFFFFF" v_GuiWidth := 300 v_GuiHeight := 120 v_GuiOptions := "-Caption -Border +OwnDialogs +AlwaysOnTop -ToolWindow" v_GuiXpos := A_ScreenWidth - v_GuiWidth SysGet, ...; Created on 16 January 2023
3. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... could help others. It's also a chance to show off my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream ...; Created on 12 March 2022
4. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
5. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... How? Well as always, I'm going to cheat. My solution here was to simply repurpose a decision box field in Creator; then re-style it to look like a button; then add a workflow on click of this field. ...; Created on 27 July 2021
6. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... type: GET connection: "joelconnector" ]; Additional I'd always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of ...; Created on 12 August 2020
7. CSS Center an iFrame Horizontally and Vertically: / Cascading Stylesheets /; ... of its app. The alert message is always at the center of the iframe but if the iframe has a height of 2000 pixels, the iframe gets aligned to the top of the parent... How? We're going to use a touch ...; Created on 23 September 2019
8. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... which screen but always on Desktop 1. In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot ...; Created on 18 July 2019
9. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... array(); // loop concatenating unit value to its label for($i=0;$i0 ? $a_UnitValues[$i].' '.$a_UnitLabels[$i] : ''; // grammar for plural/singular (should always be a positive number) ...; Created on 16 May 2019
10. CSS Printing - Page Break Inside with Headers and Footers: / Cascading Stylesheets /; ... @page { size: A4; margin: 0cm 0cm 0cm 0cm; } .page { page-break-after: always; width:21cm; height:29.7cm; ...; Created on 22 February 2019
11. 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
12. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; ... ); $file_xml = simplexml_load_string( utf8_encode( $file_content ) ); // works! DONE! Stop reading any further and tell your boss it was always in hand. Other things I tried but to no avail ...; Created on 02 August 2016
13. A quick run through of setting up an export process in SITS: / Extensible Markup Language /; ... up the Table Update Process (TUP) I always think of this as the trigger but it's required for your TOTs. Run TUP from the menu system Enter the relevant dictionary and entity For table update ...; Created on 21 August 2014
14. XML Schema Reference: / Extensible Markup Language /; ... namespace to a document key Specifies an attribute or element value as a key (unique, non-nullable, and always present) within the containing element in an instance document keyref Specifies ...; Created on 13 August 2014
15. Joes Password Analyzer (JPA): / Product Documentation /; ... Security through Obscurity "Security through Obscurity" is always ultimately fallible. This password checker can not guarantee the passwords will be easy to memorize or to type quickly. Companies ...; Created on 03 January 2014
16. Client Services: Website Development Agreement: / Static Items /; ... every solution. As an IT developer, I often get told I may win the lottery or get run over by a bus, so I am used to needing a backup plan. My aim is always to hand over the project so that I am ...; Created on 15 November 2013
17. Regular Expression Basic Usage Examples: / Web-Development /; ... class is always nested within the brackets for the character list in the regular expression. POSIX Collating Sequence The POSIX collating sequence element operator [. .] lets you use a collating ...; Created on 28 October 2013
18. Split a row into multiple rows based on a column value: / Transact-SQL /; ... is but it doesn't seem to affect the functionality of the above and you could always hardcode a 1.00 if its confusing. In theory, if you know the shift patterns of an employee, you could enhance ...; Created on 23 August 2013
19. Convert Decimal (Person Days) to Time in Excel: / Excel /; ... it would appear can book whatever time, eg. 5mins). 30 minutes for us translates to 0.07 in person days (a person day being 7 hours and 24 minutes or 26640 seconds). How? The answer was always ...; Created on 13 February 2013
20. Proposed Budget i3 PC under £200: / IT Support /; ... of our developer's equipment and the verdict is that our workstations need upgrading (it always is). So on a budget (ie. as cheap as possible), we'll skip Windows 8 and wait for Windows 9, but in the meantime ...; Created on 26 January 2013