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 CRM: Manage a subform using Client Script: / Zoho /; ... Using the following line returns all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for future reference. var l_existingSubformRows = ZDK.Apps.CRM.Deployment_Rate_Log.fetch(); ...; Created on 09 December 2022
6. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...; Created on 17 October 2022
7. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references ...; Created on 18 August 2022
8. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... fetch all payments against this customer in order of payment reference (oldest to most recent) r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks"); if(!isnull(r_SearchResults.get("customerpayments"))) { l_SearchResults ...; Created on 17 August 2022
9. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... of ebooks currently assigned to your Kindle account, all of which are shown under the Content Other options shown include Devices, Preferences, and Privacy Settings. Click on the Devices heading to show ...; Created on 29 June 2022
10. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; What? An article to remind me how to install an SSL certificate with GoDaddy. Why? A quick reference for myself as I found that with GoDaddy, a purchased SSL certificate seems to require re-installing ...; Created on 07 April 2022
11. 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
12. 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 ...; Created on 21 January 2022
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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