Search - Joel Lipman .Com

1. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; What? I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want ...; Created on 11 November 2021
2. 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
3. Adding a selectable background to a Yootheme template: / Joomla /; Applies to: Joomla 2.5.8 Yootheme Template 2012 What? For any web-developer who can program in PHP/HTML, this would be easy to hard-code and override. However, the article below demonstrates ...; Created on 19 November 2012
4. SSRS Zero Padding: / SQL Server Reporting Services /; Quick Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We ...; Created on 10 November 2011
5. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; What? An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for ...; Created on 04 November 2024
6. Zoho Creator: Input Color Picker: / Zoho /; What? An article on creating a color picker from a specific palette using an input field of a radio type. Why? At the time of print, this feature is not provided out-of-the-box and getting our ...; Created on 14 October 2024
7. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Go back to the contact record, and upload the file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders ...; Created on 06 August 2024
8. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... the item relates to. How? At time of print, adding the lookup to the line item will automatically display a related list on the Sales Order but does not associate any records... not sure why this ...; Created on 09 July 2024
9. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
10. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... #111; font-family: 'Lato', sans-serif !important; font-size: 10pt; font-weight:300; } .my-table{ width: 100%; margin-bottom:20px; } .my-table td, .my-table th { padding: ...; Created on 07 May 2024
11. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; What? This is an article to show you how to, using Deluge code, generate all the email signatures in the user profile in ZohoCRM. Why? To simplify the on-boarding process. A client of ours has ...; Created on 05 December 2023
12. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... == c_Order.Order_Date,c_Order.Order_Date.toStartOfWeek().subDay(1),c_Order.Order_Date.toStartOfWeek()).toString("w"); Additional: I'm just adding a little extra based on the further feedback, if ...; Created on 06 July 2023
13. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... adding label because -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { ...; Created on 06 July 2023
14. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
15. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
16. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... = "Test.csv"; f_CSVFile = l_CsvFileRows.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename); // // yields: // Me,Myself,I // a,b,c Additional Adding to a screen output: eg. a button ...; Created on 01 March 2023
17. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time ...; Created on 28 February 2023
18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... " "); // adding an apostrophe/single-quote to ID values so MS Excel doesn't round them up v_ProductIDStr = "\"'" + v_ProductID + "\""; v_VariantIDStr = "\"'" + v_VariantID + "\""; v_InventoryIDS ...; Created on 20 February 2023
19. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... called "Zoho Inventory Package Slips" and I'm adding these to a Creator form called "Appointment", my code should be something like the following: // // get 100 most recent appointments where this field ...; Created on 18 August 2022
20. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... cable (so from £5 to £9) and the more expensive one worked on my old Acer monitors. Adding older GPU in PCIe 3.0 x4 Slot (put in a cheap GPU to run more than 4 screens they said): Stopped my RTX 3060 ...; Created on 12 March 2022