Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
2. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify the maximum number of orders you think you have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest ...; Created on 29 March 2023
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... Possibly due to me trying to create and declare the subform before having specified any record to insert it into. Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried ...; Created on 28 March 2023
4. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... - GetMyeBaySelling Documentation: https://developer.ebay.com/devzone/xml/docs/reference/ebay/getmyebayselling.html */ // // declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify ...; Created on 01 March 2023
5. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... a split for any multi-line item orders: // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonOrders = List(); // // loop through orders in ...; Created on 28 February 2023
6. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... ZDK.Page.getForm().setValues(); ZDK.Page.getForm().setValues(); // start subform management // ***************************************** // declare the new row and JSON argument ...; Created on 09 December 2022
7. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... specified in a previous multi-line text field l_PackageRefs = c_Appt.Associated_Package_Slips1.toList(); // // important to declare this as a list of integers l_PackagesToAdd = List:Int(); for ...; Created on 18 August 2022
8. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks: // // declare ID of item in Zoho Inventory v_InventoryId ...; Created on 21 June 2022
9. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... of the logged-in user and allows the change or not ******************************************************************************* */ // // declare m_Output = Map(); v_UserID = 0; v_UserProfile ...; Created on 11 February 2022
10. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... another row (declare as many rows as required) = .(); // assigning values for various subform fields in the row . = ; . = ; // declare a variable to hold the collection of rows = Collection(); .insert( ...; Created on 17 November 2021
11. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... replace the my_owner and my_app with your Zoho Creator owner and app name respectively) Update 2022: I've included the code to verify the webhook came from Shopify: // // declare response variable back ...; Created on 15 July 2021
12. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... will use to sort in ascending/descending order and a map created to hold all the records. Loop through the sample map to create the new map we can sort as well as to add keys to the list declared previously. ...; Created on 29 January 2021
13. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... error popup if over 80%, else success ******************************************************************************* */ // // declare v_TotalClashes = 0; v_TotalDeptEmployees = 0; v_OutputMessage ...; Created on 10 December 2020
14. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... for inserting a row into a subform: // declare a variable to hold the collection of rows = Collection(); // declaring the row = .(); // assigning values for various subform fields in the ...; Created on 19 October 2020
15. URL Alias uniqueness with PHP & MySQL: / Personal Home Page /; ... TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE INSERT ON my_table_name FOR EACH ROW BEGIN declare original_url varchar(255); declare url_counter int; ...; Created on 06 May 2019
16. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... '] = 'https://www.googleapis.com/auth/drive'; $api['gapis']['drive']['files'] = 'https://www.googleapis.com/drive/v3/files'; 4. Declare a PHP function to send requests using cURL A stand ...; Created on 02 February 2019
17. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; What? This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...; Created on 30 January 2019
18. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
19. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... on the code. How? So the plan is: Declare the functions. Authenticate on page load by checking timestamp in token file: If token is required, redirect user to Consent page and rewrite token ...; Created on 31 October 2018
20. Import Excel CSV file as JavaScript array: / Excel /; ... split contents into array of rows // store each line of the CSV file into a JS array var my_csv_rows_array = my_csv_file_contents.split("\n"); // declare a blank array to store ...; Created on 05 October 2015