Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... the engineer to complete Engineer to complete notes / description / additional info Engineer to sign Then the ZohoSign document gets sent to a line manager to Approve the document Then th ...; Created on 06 August 2024
2. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... = v_Counter + 1; } info "Statement execution limit is 50000"; Additional Note(s): Observation #1: Method Chaining: Contrary to my previously held belief, method-chaining still counted as separate ...; Created on 31 July 2024
3. Zoho Projects: Get All Events: / Zoho /; ... :v_EndpointEvents type :GET parameters:m_Params connection:"my_projects_connection" ]; l_FutureEvents = ifnull(r_FutureEvents.get("events"),List()); Additional: Code to get a single event: ...; Created on 22 July 2024
4. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... = Map(); m_RelatedList.put("header_context",l_HeaderColumns); m_RelatedList.put("data",l_RelatedListData); return m_RelatedList; Additional Note that for reading the data from Analytics, we cheat ...; Created on 09 July 2024
5. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... but without the correct additional parameters omitted/needed (in my case the UNTIL given a CRM/Atom date time format). m_Recurrer.put("RRULE","FREQ=DAILY;INTERVAL=1;DTSTART=" + v_StartDate + ";UNTIL=" ...; Created on 14 May 2024
6. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... Page of Copyright © My Company Ltd. All Rights Reserved. Additional Notes to Self: Some customers will want a column for VAT/Tax ...; Created on 07 May 2024
7. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... :file:f_AllProducts ] // return v_TotalProducts + " product(s) in " + v_TotalCategories + " categories across " + v_Page + " page(s)."; Additional: Total product count may differ from the actua ...; Created on 15 April 2024
8. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... receive and pass to the JS widget. the HTML You may note that I have additional CSS and JS files. I like to keep the copies local (especially if the hosting is included) so the app doesn't suddenly ...; Created on 14 March 2024
9. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... need to mark as sent as sending via the above will automatically do that in ZohoBooks. } } } Additional You can include a parameter in the request when creating an invoice which is sent = ...; Created on 07 March 2024
10. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... v_Pages; Additional Urlencoding or not didn't have much affect on the above but it is recommended you do as it did work if the criteria were encoded... The criteria is in the same syntax format ...; Created on 14 November 2023
11. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... == c_Order.Order_Date,c_Order.Order_Date.toStartOfWeek().subDay(1),c_Order.Order_Date.toStartOfWeek()).toString("w"); Additional: I'm just adding a little extra based on the further feedback, if ...; Created on 06 July 2023
12. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... = "Test.csv"; f_CSVFile = l_CsvFileRows.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename); // // yields: // Me,Myself,I // a,b,c Additional Adding to a screen output: eg. a button ...; Created on 01 March 2023
13. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... the displayed note of "Add your Note here...") input.CSS_Overrides = v_CssNotes; Additional If you don't want to apply this to the every subform on that form, you will need to brush up a little ...; Created on 28 February 2023
14. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... m_Response; Even in test mode or simply starting a Cliq conversation will now yield something like the following: Additional For every chat message, the OpenAI ChatGPT forgets what the contex ...; Created on 13 February 2023
15. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... o r_Create; v_CountProcessed = v_CountProcessed + 1; } } } } } info "Page #" + v_Page + ": Processed " + v_CountProcessed + " of " + v_CountTotal; } Additional Note(s): ...; Created on 08 February 2023
16. ZohoCRM: Import Attachments: / Zoho /; ... contain names used on other records. Additional: Here's an AHK script I wrote that produces a GUI that takes an external file where column A contains the key/ID of the Contact in the 3rd-party ...; Created on 16 January 2023
17. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... = t3."Sales Person ID" AND t3."MonthYear" = abs_month(invsopoitm."Invoice Date") GROUP BY invsopoitm."Invoice ID" Additional Here are some other queries that are required for the above ...; Created on 03 November 2022
18. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... it and click on the ellipsis/3 dots Select the REST API Enable REST API Note the REST API function and you can now call it from wherever. Done Additional Caveat(s) This currently does ...; Created on 31 March 2022
19. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... 3 @£28.99 Monitor Cable KabelDirekt - DisplayPort to DVI adapter cable 2m dual link 1 £9.89 Additional iYueshare 120mm Magentic Mesh Filter Cover Grill (2 pack) 1 £8.90 Additional Power Supply Sleeved ...; Created on 12 March 2022
20. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... needs information from additional apps installed on the Shopify store. Why upgrade to the latest version for Shopify when private apps created before February 2022 won't be deprecated? Because the ...; Created on 14 February 2022