ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 } // // ---------------------- QUOTE LINE ITEMS ---------------------- // line items get via api v2.1 or greater l_BooksLineItems = List(); r_CrmProductLineItems = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Quotes/" + p_QuoteID type :GET...

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

Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer is one...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 be done in the PcWorldRssParser.java (without it crashing the app). The gist is to check for a description (the first two items do not have one). The following will also return a publishing date: Find the List function in: PcWorldRssParser.java...

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

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 the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this article because I keep forgetting on how to do this. I have a...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? My use-case scenario here is that we have a Zoho Creator app...

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

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

28 February 2023 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 into it and hide the delete icon...

• 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 display:inline-block; min-width:100px; } #my-content table:first-child tr td:nth-child(2){ width: 240px; } /* line items */ #my-line-items thead tr th{ color: #777; text-align:right; text-transform: uppercase; vertical-align: bottom; border-bottom: 1px...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 clicks on the plus icon next to "Invoices" in the left sidebar? This script will map over the core fields, address, and line item. This took me a while to get the right syntax for writing to the invoice line items as well as setting the value of lookup...

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

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 - The following terms will be used throughout this tutorial. You may use these links for a more in-depth description of each item. HTML DOM, JavaScript, COM, Methods, document, value, element, form, name, ID, Input, Tag, selectedIndex, checked,...

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

Vertically align an asterisk on a linehttps://www.joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 (*, 1, 2, 3...) and for styling reasons I want the asterisk to be the same size as the numbers but not overlap any list item beneath it. By increasing the size of the asterisk, this often increases the line-height and causes the overall line height to...

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

Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 reset only) • Your public name (full Name) • Your membership type • Your app preferences • Any user-specified shared item What is stored on your device about you: • Your public name • Your email address • Your aircraft details and equipment • Your...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article Zoho...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 words, listings on eBay get downloaded to Zoho Inventory but not vice-versa. Then there's an added delay of 4 hours. Then item specifics in eBay's listings don't get parsed into custom fields in Zoho Inventory... and the list goes on. So in my job, we...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 Books so when pushing an invoice, there's a strong chance of being a cent/penny off. Let's take the following example of an item with a list price of 12345.545: ZohoCRM Line Item ZohoBooks Line Item How? Here's the immediate solution I have applied now...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 update a record using invokeUrl. Why? Because my designers keep including custom fields in their transactional modules line items (quotes, sales orders, invoices, purchase orders). The only way to update these are by using the API and deluge function...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 $site_structure_string = preg_replace('/[^a-zA-Z0-9_\\/]/', '', $site_structure_string); var $site_structure_item = $_GET['myFiles']; var $site_structure_array = explode('/', $site_structure_string); // yields $site_structure_array[0] = 'blog'...

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

MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 null); // set the hint of the EditText in the AlertDialog EditText inputText = (EditText) v.findViewById(R.id.hangar_item_menu_name_field); inputText.setHint(hangar_aircraft_name); // Start building the AlertDialog AlertDialog.Builder b = new...

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

Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 main activity and any other activity would be a sub-activity; returning to the map activity would restart the app as a menu item, it would need to launch a new intent... I wanted to change my previous example so that the homepage of the app (the...

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

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 of an invoice record seems straightforward but it isn't. Undocumented, the trick is to remove the existing ID of the line item and posting the map back to the record. In the following example, we are swapping out the product "123456789012345678" with...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION expression Another...

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