Search - Joel Lipman .Com

1. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... > Modules and Fields Hover the mouse cursor over the "Products" module and then over the ellipsis Click on "Customize Tax Rates" For our clients in the UK, we tend to specify the tax rates as "Standard ...; Created on 02 September 2021
2. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... the file You may note that this generates a text file rather than a CSV, this is because our JS widget won't pack a CSV but it will pack text files. // // generate a CSV or TXT v_CSVFilename ...; Created on 25 March 2024
3. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... here an example that demonstrates a basic search on a table of data and returns one record as a result. The use-case here is that we are enhancing a quote builder form in Zoho Creator. The JS widget ...; Created on 14 March 2024
4. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... generates all email signatures (no criteria). You will need to change the HTML signature and use the Image Source URLs returned from the above function to generate a HTML signature, then use placeholders ...; Created on 05 December 2023
5. Zoho Books: Generate Bank Text File for Download: / Zoho /; What? This is an article to document how we created a button off a Bill record in ZohoBooks which generates a text file to be sent to a bank and downloads it to the staff member's workstation. Why? ...; Created on 02 October 2023
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... to view taxes and chart of accounts Setup a connection called "joel_inventory" that has the necessary scopes to do everything under the sun Setup a function that generates an access token of the Trading ...; Created on 27 April 2023
7. ZohoCRM: Import Attachments: / Zoho /; ... and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with ...; Created on 16 January 2023
8. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... a rate without any preset values. Rates will be taken from the Opportunity record. If these are blank then enter the rates manually below: Rate Year 1.0, Rate Year 1.5, ..."); } // updat ...; Created on 09 December 2022
9. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Another REST API CRM function which generates an eBay Access Token for me r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003."); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToke ...; Created on 31 March 2022
10. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... which in turn generates an order in Shopify. This article is primarily for myself as I need to do this for some other clients and I just want to continuously refine and improve my code below. How? ...; Created on 21 January 2022
11. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... You will note that I use the access token function (one that regenerates an access token or reuses if not expired). Thereafter, I use the GetMyeBaySelling API Call with specific criteria to only return ...; Created on 13 October 2021
12. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; What? This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in ...; Created on 08 October 2021
13. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... but to get the tax rates and their IDs: // our made up books org id but enter your own v_BooksOrgID=20210924095; // // get taxes m_Taxes = Map(); r_Taxes = invokeUrl [ url: "https://books.zoho.eu/api/v3/settings/taxes?organization_id="+v_BooksOrgID type: ...; Created on 24 September 2021
14. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name ...; Created on 20 September 2021
15. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... the following code which generates a sample CSV and then loops through storing each row as a data record and outputting it to screen: // generate a sample CSV file v_DataCSV = "1,Joel Lipman,Kings ...; Created on 26 August 2021
16. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it. 0007 Test Product 1 TEST001 This email address is being protected from spambots. You need JavaScript enabled to view it. The code is a for loop which iterates through each row, assigning an entry for a new product ...; Created on 02 September 2019
17. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
18. A for loop within a for loop in MS-DOS: / MS-DOS /; ... following loops through directory and separates by underscores FOR /F "tokens=2,3* delims=_" %%A IN ('DIR InitializingFile*') DO ECHO %%A -- yields: 123.csv 456.csv So that's our first loop, here' ...; Created on 03 October 2013
19. Adding a selectable background to a Yootheme template: / Joomla /; Applies to: Joomla 2.5.8 Yootheme Template 2012 What? For any web-developer who can program in PHP/HTML, this would be easy to hard-code and override. However, the article below demonstrates ...; Created on 19 November 2012
20. Sync Outlook 2007 Shared Calendar with SharePoint 2007: / SharePoint /; ... a program on your computer (opens Outlook). Confirm the prompt your Outlook instance generates as a result. You now have a new calendar under Other Calendars, you can open another calendar alongside ...; Created on 09 November 2012