MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 to (eg. $A1:$W36000). You are then prompted for the number of rows per sheet (eg. 3000). In my example, this will produce an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted with the below (note the file...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 { input.eTag = v_eTag; // do the main code that takes into consideration all the fields triggering a change //... } An extra layer: To go one step further, and only if you notice the form going slowly when it first loads (or doesn't load at all),...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• 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 - Event Types Documentation: https://developer.ebay.com/Devzone/XML/docs/Reference/eBay/extra/stntfctnprfrncs.rqst.evntprprty.evnttyp.html */ r_Api = API_Integration[Connection_Name == "eBay API (Production)"]; if(r_Api.count() > 0) { v_AccessToken =...

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

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 and tax by their ID numbers. How? Using the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run them once, store them as a map on your function if you don't want to use up these 2 every time your...

• 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 it kept talking about AMD Crossfire/NVidia SLI and I'm doing neither). But that didn't work, then I found you need to do an extra step in your Windows OS... Now for the BIOS: Restart your PC While it is booting up (displays NZXT logo), bash the "DEL"...

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

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

16 March 2023 ZohoBooks, click on the button, and the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added a custom field that can override the full balance, to allow partial payments such as a deposit or...

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

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

06 July 2023 Additional: I'm just adding a little extra based on the further feedback, if we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year...

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

Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 increment for counting the records processed v_CountTotal = v_CountTotal + 1; // // for the response structure, we need to extrat the first key as the Zoho ID l_GoalKeys = m_GoalRecord.keys(); if(l_GoalKeys.size() > 0) { // // messy but this is the key...

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