Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 " + v_NextDay.toString("d") + v_Day3_Ordinal + " " + v_NextDay.toString("EEEE") + " " + v_NextDay.toString("MMMM") + " "; Generate a list of working dates given a number of days So here's another scenario where you have a start date and you are asked to...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 "); input.Note_BookedTimeSelection = v_ResultInformation; Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of...

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

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by...

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

ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

10 January 2022 // // ******************************************************************************* // Generate your access token to connect to Xero and query Xero records // See my article:...

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

Zoho Creator: eBay: Get Item Transactionhttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

22 January 2022 XML of a GetItemTransactions request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you can use the following code, note that the parameter is...

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

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

14 February 2022 as the inventoryQuantity so might as well reduce those costs (by almost a half!). Source(s): Shopify Partners - How to Generate a Shopify Access Token (legacy) Shopify Community - API To Search Products By SKU Zoho Deluge: Push Item to Shopify API...

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

ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

28 February 2023 of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate an Access Token to your client's eBay store as that's covered in my article: Zoho Creator: Push to eBay Listings. Getting...

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

Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 and till v_OrdersFrom = v_Year + "-01-01T00:00:00.000Z"; v_OrdersTill = v_Year + "-12-31T23:59:59.000Z"; // // now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages =...

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

Zoho Books: Get Invoice Payment Terms via APIhttps://joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 "Due end of next month" } ] } } Usage: This is just a snippet of usage and obviously not the whole function to generate an invoice. Please refer to the Zoho Books API documentation for what fields are required to complete a request within your system....

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

Zoho Books: System Values Mapshttps://joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 are no contact persons associated with this Invoice. - Encountered when trying to use the send an invoice API - Need the generated invoice to pre-select a contact person to email - Superceded by including "send=true" in the invoice creation request More...

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

Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 } // ====================== // upload the file to this folder if(v_WorkdriveFolderID != "") { v_PermaLink = ""; // // generate a test CSV v_NewLineChar = hextoText("0A"); l_Csv_File = {"Header1,Header2","Row1_Data1,Row1_Data2","Row2_Data1,Row2_Data2"};...

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

Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

04 November 2024 push a response so when clicked, it loads up a page in a browser (redirect from a zoho page) if(b_ValidResponse) { // // generate HTML page when clicked (please amend the following variables) v_CompanyName = "Joel Lipman Ltd"; v_CompanyStrapline = "The...

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

Joes Chart Generator (JCG) Downloadshttps://joellipman.com/component/content/article/joes-chart-generator-jcg-downloads.html?catid=92

07 September 2015 VersionPlatform ChangeLogOptions1.0+ Group all the data by a specified column + Generate interactive flash charts - Date Uploaded: Wed, 15th Sep 2010 Download

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