ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 + v_BooksOrgID; // saw this in the documentation example so will hopefully do what it says m_ShippingAddress.put("is_one_off_address",true); m_ShippingAddress.put("is_update_customer",false); // send the request via API (change connection name to your...

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

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

31 March 2022 such, I'm doing the following Function Name: fn_eBay_UploadPhoto Display Name: Fn - eBay - Upload Photo Description: What it says on the tin Category: Standalone Click on Create Give it the parameter/argument p_InventoryitemID as an Integer/Long/Number...

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

Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 remember word for this set of options, eg. "portrait". Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this custom...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday but in the United Kingdom, the week generally starts on a Monday. So let's say there's a...

• 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 designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and says things like "can we add this?", "can it say this instead?", "can it be in a bigger font?"... without pushing back too much,...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 I wanted to copy over the tag but apparently, the ID of the tag is not allowed to be copied over. The official documentation says to use remove() to remove a key from a map. In this case, the ID key and value pair. It would then tell me the list was...

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

Add a template to the dropdown in Kunenahttps://joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 template (avoid any spaces) Download the new template for the Kunena forum This is what the official Kunena documentation says: Installing another Template Download the Template package. Open your FTP Connection and go to...

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

Search and Replace in a MySQL Databasehttps://joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...

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