Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... r_Coql; Additional If you wanted the unique values of a picklist/dropdown, then consider an invokeUrl looping through the fields settings in CRM. Source(s): Zoho CRM Developer Docs API v ...; Created on 08 October 2021
18. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... that any change was made. Instead, I need to add an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it. // get given ...; Created on 19 September 2021
19. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; ... Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge .toList() fails the function ...; Created on 01 September 2021
20. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; ... == v_OwnerID) { v_SalesPersonID = r_SalesPerson.get("salesperson_id"); break; } } m_CreateSO.put("salesperson_id",v_SalesPersonID); } Additional Note(s): Scope(s) required: for ...; Created on 30 August 2021