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. ZohoBooks: Code 15 Ensure Billing Address has less than 100 characters: / Zoho /; ... ---------------------- QUOTE SHIPPING CHARGE ---------------------- if(r_QuoteDetails.get("Apply_VAT_to_Shinpping_Charges") && v_ShippingCharges > 0) { m_CreateEstimate.put("shipping_charge_tax_id",m_Taxes.get("20")); } else { m_CreateEstimate.put("shipping_charge_tax_id",""); } m_CreateEstimate.put("shipping_charge",v_ShippingCharges); // / ...; Created on 18 September 2023
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... string is a no go. Set it to an atom time or nice SQL date/time (eg. "yyyy-MM-dd HH:mm:ss") and then apply the function .toTime() Source(s) Zoho CRM v3 Organization API Zoho Community Forums ...; Created on 28 March 2023
4. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... the displayed note of "Add your Note here...") input.CSS_Overrides = v_CssNotes; Additional If you don't want to apply this to the every subform on that form, you will need to brush up a little ...; Created on 28 February 2023
5. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... client script which will manage a subform. The module we are applying this client script to is a custom module called "Deployments". The field which triggers it is called "Which_rate_card_is_this_based_off". ...; Created on 09 December 2022
6. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... display above the sales person (eg. "Sales Person") Alongside the Value field, enter $.LABEL Under Label: Display 'Unknown' as, enter a dash/hyphen to indicate not known. Click on the button Apply ...; Created on 24 October 2022
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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