Zoho Creator: Retrieve record with case-insensitive queryhttps://joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 v_ProductID = l_ProductDetails.ID; } What Happens: In the example above, the count to see if "Myproduct1" exists counts as zero (0). It doesn't think the product exists because it is searching with case-sensitivity enabled. It tries to insert into the...

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

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

10 December 2020 v_TotalDeptEmployees = l_DeptEmployees.size(); // ensure total is not zero as we need to divide by it (defaulting to 2 because if 1 then it's 100%, as 2 it's 50% might have it booked off) v_TotalDeptEmployees = if(v_TotalDeptEmployees 80 &&...

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

Zoho CRM: Standard Setup for Tax Rateshttps://joellipman.com/articles/crm/zoho/zoho-crm-standard-tax-rate-setup.html

02 September 2021 Click on "Customize Tax Rates" For our clients in the UK, we tend to specify the tax rates as "Standard Tax" @ 20% and a "Zero Vat" @ 0% Click on "Save" and you've pretty much specified the tax rates that this CRM can use; but... do the next steps for...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 in l_SearchResults { if(!isnull(r_Result.get("id"))) { v_DealID = r_Result.get("id").toLong(); } } } // // if Deal ID is not zero, then it was found! if(v_DealID != 0) { r_DealDetails =...

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

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 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 of print, this is the only way I know: add a note field to inject some CSS...

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

ZohoBooks: Stripe Terminal Integrationhttps://joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 for a payment atempt Date Modified: 2023-02-24 (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST CARD // Send in as payment...

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

Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 Prime Meridian and when no daylight savings are in effect, the hour difference to UTC (Coordinated Universal Time) should be zero, then for checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 // // initialize l_AllProducts = List(); v_TotalCategories = 0; v_TotalProducts = 0; v_Page = 1; // do not set this to zero!!! v_PerPage = 100; // // API keys v_MyWordPressSiteUrl = "https://mysite.com"; v_ConsumerKey =...

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

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

07 May 2024 Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page to PDF - Used more for links to open the PDF renderer in a new tab. Zoho Creator - Developer...

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

SSRS Repeat Headers in PDF Reporthttps://joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 and checked the box "Repeat header columns on each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't...

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

Ordered List of over 1000 Itemshttps://joellipman.com/articles/web-development/css/ordered-list-of-over-1000-items.html

08 February 2013 solution is a bit of aesthetic styling. ol{margin:4px} -- yields 995. 996. 997. 998. 999. 000. 1000 Ordered list resets to zero after the ninth item Ordered List Maximum

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *