Search - Joel Lipman .Com

1. Applying a button and centering it in the RocketTheme Affinity template: / Joomla /; This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled ...; Created on 15 September 2009
2. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... The advantage of working in a team of Zoho developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query which works ...; Created on 08 October 2021
3. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... and applying the method .toString("dd/MM/yyyy") is dependent on the settings. But making a date into a SQL format or from largest denominator to smallest in "yyyy-MM-dd" will usually handle the date better. ...; Created on 01 September 2021
4. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... Zoho Bookings as documented in the official documentation. Not sure why anyone would want to leave this enabled without applying the fix. So the fix is a setting: Login to Zoho Bookings as the admin ...; Created on 01 September 2021
5. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... Replace all commas in between a pair of double-quotes: Well I couldn't find a single regex that can do this in one go but by applying the same regex to the same value (line 29), solved this for the sample ...; Created on 26 August 2021
6. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... for the next step: CSS styling): Apply the following styling (this will depend on the theme you are using): .zc-Save_and_Close-group .decision-box-field label{ display:none !important; } .zc-Save_and_Close-group ...; Created on 27 July 2021
7. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... are on a laptop and can apply a function lock (fn) and the numbers on the right of your keyboard are enabled. Which numbers you might ask? Well every character is built of a collection of digits ...; Created on 03 June 2021
8. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; What? This article documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee ...; Created on 10 December 2020
9. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... base URL such as https://creatorapp.zoho.com/myowner/myapp/#Page:Notify. CSS styling affects all contents: Any styling on an embedded form on the popup would need to apply specifically to the contents ...; Created on 06 November 2020
10. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... were so custom that they didn't apply to you because of the app owner, name, view link name, etc. The fastest way I know how to get to it is to publish the report and right-click on the attachment to see ...; Created on 15 May 2020
11. 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
12. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records: ... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)]; ... Lastly, there ...; Created on 21 November 2019
13. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it ...; Created on 20 August 2019
14. GDPR Privacy Policy: / Static Items /; ... IF THESE LAWS APPLY TO YOU, SOME OR ALL OF THE ABOVE DISCLAIMERS, EXCLUSIONS, OR LIMITATIONS MAY NOT APPLY TO YOU, AND YOU MIGHT HAVE ADDITIONAL RIGHTS. APPLICABLE LAW By visiting MYCOMPANY, you agree ...; Created on 14 February 2019
15. Excel - Check a column for values found in another column: / Excel /; ... (ie. not relative). Sheet1!A1 is the cell to search for those words. Note how I don't add a dollar, this is so that the formula will apply to each row and increment based on how you copy the formula ...; Created on 14 February 2019
16. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... F5 to run the code. This will prompt you twice: It is prompting you for the range of all the data to apply this to (eg. $A1:$W36000). You are then prompted for the number of rows per sheet (eg. 3000). ...; Created on 11 February 2019
17. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; ... updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one ...; Created on 30 January 2019
18. Migrating from Joomla 2.5.x to 3.4.x: / Joomla /; ... this if there aren't many to do. In this example, I am applying -- this to the "uncategorized" category. -- ********************************************************************* SET @uncategorisedCategoryID_new ...; Created on 12 September 2015
19. Joes Word Cloud (JWC) Download: / Downloads /; ... apply the CSS to the module title. - Removed Joomla! Admin Option: Code Override - Removed Joomla! Admin Option: Cached-Mode - Amended Font-size to base on number of words available.- Date Uploaded: ...; Created on 07 September 2015
20. Quadcopter App with Flight Restrictions (JQA): / Product Documentation /; ... on account of death or injury to any person or damage to any property or product arising from or in connection with any products sold or supplied by JoelLipman.com. This indemnity shall apply without ...; Created on 24 October 2014