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 & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... there's more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other articles ...; Created on 21 June 2022
3. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... / return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List(); l_Disallowed.add("Joel"); if(l_Disallowed.contains("")) { in ...; Created on 11 February 2022
4. Zoho Creator: Change Radio into Tabs: / Zoho /; ... tabs along the top to display each section. How? The way we do this is by applying our own stylesheet and overriding certain CSS elements that the vanilla or out-of-the-box Zoho Creator ones provide. ...; Created on 22 October 2021
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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