Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 "PO Item Tax", poi."Quantity" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line Tax", if_null(pshipping."PO Delivery", 0) AS "PO Total Shipping", if_null(pdiscrepancy."PO Discrepancy Total", 0) AS "PO Total Discrepancy", if_null(pquantity."PO Total Qty", 1)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Convert seconds to total time in PHPhttps://www.joellipman.com/articles/web-development/php/convert-seconds-to-total-time-in-php.html

31 January 2012 calculations, there are times when we have to do with PHP. This is the shortest way I know to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 o_NewLineItem.CUSTOM = o_ThisLineItem.CUSTOM; o_NewLineItem.Config = o_ThisLineItem.Config; o_NewLineItem.Cost_Line_Item_Total = o_ThisLineItem.Cost_Line_Item_Total; o_NewLineItem.Description = o_ThisLineItem.Description; o_NewLineItem.Discount1 =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 ID of the quote): // init Map m_UpdateQuote = Map(); // r_QuoteDetails = zoho.crm.getRecordById("Quotes", p_QuoteID); v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 0.2; v_GrandTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 1.2;...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 point is the HTML attribute zcpage-footerhtml; but note the 3 other CSS classes zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page of Copyright © My...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Calculating Percentagehttps://www.joellipman.com/articles/ecommerce/calculating-percentage.html

20 May 2010 percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net Amount / Gross Amount) * 100 = % eg. (12 steps / 30...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let us assume we have the following in a form/report called "Stock_Upload": RowID Name SKU Account...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 record only has 1 item. void emailMergedReceipts(Partners_Quote l_Quotes) { v_ContactFname = ""; v_ContactSname = ""; v_SubTotal = 0.0; v_TotalVat = 0.0; v_Total = 0.0; v_Total_Tax_Factor = 0.2; for each r_Quote in l_Quotes { r_QuoteDetails =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees in this department/team: To determine the total number of employees, we will use zoho.people.getRecords...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 l_HeaderColumns.add({"key":"po_ref","value":"Ref"}); l_HeaderColumns.add({"key":"po_status","value":"Status"}); // amount/total is a currency column we want aligned on the right l_HeaderColumns.add({"key":"po_amount","value":"PO...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't Googled this at the time of print so there may be a million better solutions out there, this is just...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MySQL: Display Users and Duration in Matrix Timesheethttps://www.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 Data Activities by employees with start dates and end dates in a mySQL database. Objective User Mon Tue Wed Thu Fri Sat Sun Total --------------- ------- ------- ------- ------- ------- ------- ------- --------- Me 09:00 07:30 08:00 07:00 06:00 00:00...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

MySQL: Count occurrences of words in a columnhttps://www.joellipman.com/articles/database/mysql/mysql-count-occurrences-of-words-in-a-column.html

12 March 2020 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value` FROM ( SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

20 March 2025 + ": " + r_UpdateBooksInvoice.get("message"); // // adjustments if(r_UpdateBooksInvoice.get("invoice").get("total") != v_Crm_Invoice_GrandTotal) { v_TotalAdjustments = v_Crm_Invoice_GrandTotal - r_UpdateBooksInvoice.get("invoice").get("total");...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 I had to add the following code: // // -------------------------------------------------------------------- // v_SurveyTotalScore = 0; // // build up the config to get the total score for this survey back m_Config = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 Captcha to download? --- Specify News category (to tell everyone about your new projects) --- Specify high download rate or total downloads as "HOT" --- Specify number of days a file is "NEW" --- Specify number of days a file is "UPDATED" - Added Admin...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 work is not mine and comes from a clever function by Chris Stubben in the MySQL Forums: BEGIN DECLARE i INT DEFAULT 0; -- total number of delimiters DECLARE ctr INT DEFAULT 0; -- counter for the loop DECLARE str_len INT; -- string length,self...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Zoho Deluge - Modify the product line items in an invoice modulehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

22 August 2019 null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" }, "quantity": 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock": 0, "total": 0, "id":...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 l_TaxOptions.add(m_TaxOption1); m_LineItem.put("line_tax",l_TaxOptions); } m_LineItem.put("total",5.94); m_LineItem.put("product_description","My Test Description"); l_CrmLineItems.add(m_LineItem); // m_CreateQuote = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 Cover Grill (2 pack) 1 £8.90 Additional Power Supply Sleeved Cable (White) 1 £19.99 Build & Cost Breakdown Initial Build Total (functional PC, onboard GPU, 32Gb RAM, Previous O/S): £1,099.81 Second Part Build Total (GPU, RAM doubled, Windows 11 Pro,...

• Type: Article
• Author: Joel Lipman
• Category: Articles
• Language: *