Search - Joel Lipman .Com

1. XML Schema Reference: / Extensible Markup Language /; XSD Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for ...; Created on 13 August 2014
2. SSIS: Add Reference Microsoft.SqlServer.TxScript: / SQL Server Integration Services /; What? This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under ...; Created on 03 June 2014
3. DBMS Random Reference: / Oracle PL/SQL /; What? How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing ...; Created on 21 August 2012
4. MySQL Data Type Reference Table: / MySQL /; A data type reference table. If you're designing a database then you don't need me to tell you what this is. My personal opinion is to always try to use the minimal type and length of the value required. ...; Created on 15 February 2010
5. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetItemTransactions Documentation: https://developer.ebay.com/devzone/xml/docs/Reference/eBay/GetItemTransactions.html ...; Created on 22 January 2022
6. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an order ...; Created on 21 January 2022
7. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... = List(); if(!isnull(r_GeoCode.get("latitude"))) { // add user licence key (you'll need to get your own at https://timezonedb.com/references/get-time-zone) l_Params.add("key=123456789ABCD"); l_Params.add("format=json"); l_Params.add("lat= ...; Created on 15 December 2021
8. Zoho Creator: Change Radio into Tabs: / Zoho /; What? This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match ...; Created on 22 October 2021
9. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... snippet is a separate function to run (standalone) and will return to you the templates and the field references: r_Templates = invokeUrl [ url: "https://zohoapis.com/writer/api/v1/templates" ...; Created on 21 October 2021
10. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... More Info: - API Explorer Test Tool: https://developer.ebay.com/DevZone/build-test/test-tool/default.aspx?index=0&env=production&api=trading - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html ...; Created on 13 October 2021
11. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... It took me a while of playing about with the placeholder reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what these display. What I had: $ $ $ $ ...; Created on 07 October 2021
12. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons ...; Created on 22 September 2021
13. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... = r_Api.Access_Token; } } else { //info "Re-using Token"; } } return v_Output; } Get Notification Preferences [Optional] Here's a function to run just to see what the current ...; Created on 20 September 2021
14. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM users to think about tax and probably manage it in Zoho Books leaving it to their ...; Created on 02 September 2021
15. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... = "crm_reference_id=" + v_OwnerID; l_AllSalesPersons = zoho.books.getRecords("salespersons", v_BooksOrgID, v_Filter, "joel_books"); for each r_SalesPerson in l_AllSalesPersons { if(r_SalesPerson.get("crm_reference_id") ...; Created on 30 August 2021
16. Xero API: Send Multiple Invoices: / Xero /; ... [ { "Type": "ACCREC", "Contact": { "ContactID": "abcdef01-2345-6789-abcd-ef012345678" }, "Reference": "TEST Invoice (DO NOT ACTION) 1", "DueDate": "2021-09-13", ...; Created on 15 August 2021
17. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... r_CreateTimeLog; You will find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06 ...; Created on 30 April 2021
18. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Quote". Within your function you can use the following as a reference. In theory, you could loop through each submitted quote but I do a call at the beginning of each iteration of the loo ...; Created on 06 December 2020
19. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... their own text to display to their users. A preset form/page with openUrl could do the same thing but it's a fixed width/height and question of preference. There are cases however when the openUrl method ...; Created on 06 November 2020
20. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... HTML,CSS and JS). Files referring to Creator specifically: ./app/widget.html: reference to script src at https://js.zohostatic.com/creator/widgets/version/1.0/widgetsdk-min-js ./app/custom.js: my ...; Created on 24 October 2020