Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... / return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List(); l_Disallowed.add("Joel"); if(l_Disallowed.contains("")) { in ...; Created on 11 February 2022
10. Zoho CRM: searchRecords with sorted results: / Zoho /; ... Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: // ****************** CODE USING ...; Created on 10 February 2022
11. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... 12 Additional Note(s): You might ask why not use the built-in round() function? Well I admit that round() needs to be used for currencies. The issue is that round() only rounds up decimals to ...; Created on 08 February 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 Analytics: Setup DataSource via FTP Connection: / Zoho /; ... setup a schedule for the import to automatically download the data file regularly: After all that you will be shown your data table: Additional Note(s): Here are some notes & settings ...; Created on 12 January 2022
14. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated ...; Created on 10 January 2022
15. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... Year): Sunday, 2021-03-28 01:00 End Date (Current Year): Sunday, 2021-10-31 01:00 Start Date (Next Year): Sunday, 2022-03-27 01:00 End Date (Next Year): Sunday, 2022-10-30 01:00 Additional Note(s): This ...; Created on 07 December 2021
16. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Additional: Daylight Savings Time Just to cover all aspects of this, I create a Zoho Creator form with the timezone names, their offset and their DST offset as well as a boolean to say whether ...; Created on 07 December 2021
17. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... ) +". "; } // // return response to user return v_OutputMessage; Additional Change Name of file // // to generate and attach r_DownloadResponse = zoho.writer.mergeAndDownload(v_TemplateID,"pdf",m_MergedData,"ab_writer"); v_Filena ...; Created on 21 October 2021
18. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... v_PositionIndex, v_ShopifyImageSrc); } v_PositionIndex = v_PositionIndex + 1; } info "Re-uploaded Photos to Shopify"; } } Correction / Additional The above solution means that ...; Created on 17 October 2021
19. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
20. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... the last element. At time of print, I ran this to retrieve 1970 active product IDs and their SKUs without erroring by going over the Zoho Deluge statement execution limit. Additional: See my ...; Created on 12 October 2021