Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 { English_Ordinal = Ordinal_Map.get(My_Date_Field.toString("d")); } Method #3: Given the current date and using the last character of the date, we can do the following: v_EnglishOrdinal = "th "; v_ThisDayDateLastChar =...

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

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 } l_UpdateLineItems.add(m_LineItem); } // // now update the current invoice with the sales order details m_UpdateInvoice = Map(); m_UpdateInvoice.put("line_items",l_UpdateLineItems); m_UpdateInvoice.put("reference_number",v_NewRefNum);...

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

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

19 October 2020 in the row . = ; . = ; // insert the row into the collection .insert( ); // insert the collection into the subform on the current form input..insert( ); // or insert the row(s) into the subform through the record variable r_LeadDetails = Leads[ID ==...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 It will then initialize some NPM dependencies and it will ask you to type the following commands; to change current directory to the app directory and then to run the toolkit cd joels_awesome_app zet run The terminal response will advise that it is...

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

Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

27 July 2021 an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as well as...

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

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

20 September 2021 > 0) { //info "Access Token Expires at: " + r_Api.Access_Token_Expiry; v_Output = r_Api.Access_Token; // // zoho.currentttime can be server time as this function will check expiry against the server time anyway if(zoho.currenttime >=...

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

Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

13 October 2021 p_Page, int p_PerPage) { /* Function: fn_eBayQuery_GetActiveProducts() Purpose: Fetches current listings / active products Date Created: 2021-10-13 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...

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

Zoho Deluge: Generate List of TimeZoneshttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 America/St_Barthelemy America/St_Johns America/St_Kitts America/St_Lucia America/St_Thomas America/St_Vincent America/Swift_Current America/Tegucigalpa America/Thule America/Thunder_Bay America/Tijuana America/Toronto America/Tortola America/Vancouver...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 the source of truth and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than 100 products are modified in a...

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

Zoho Deluge: Proper Case for Nameshttps://joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // set first and last name v_FirstName = "BILLIE-JO"; v_LastName =...

• 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 on every page. The key point is the HTML attribute zcpage-footerhtml; but note the 3 other CSS classes zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page of...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 timestamp indicating when eBay user made the data deletion request notification.publishDate timestamp indicating when current notification was sent notification.publishAttemptCount integer indicating how many times the notification has been sent to this...

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

Increase Recent Documents Number in Windows XPhttps://joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 them even if I have checked what it's doing. I'm putting a note here just for me: Start > Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name it "MaxRecentDocs"...

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

MySQL day of week ending on Fridayhttps://joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 -- next Friday Not sure why this works, thinking about it hurts my head but it worked with my test data (selecting current week days then the following saturday and sunday -- both saturday and sunday returned week ending date as next week). If you were...

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

Oracle: order by subquery missing right parenthesishttps://joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *