Search - Joel Lipman .Com

1. RokDownloads Manager does not list files: / Joomla /; Well this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager ...; Created on 28 October 2010
2. Does Google Chrome Frame really improve performance: / Google /; The jury's still out on this one. I have noticed a slight improvement in my page loads but will have to carry out proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame ...; Created on 23 September 2009
3. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent ...; Created on 06 August 2024
4. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... "Dashboard": Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any query and any field. It doesn't matter which one here, as ...; Created on 25 July 2024
5. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... the item relates to. How? At time of print, adding the lookup to the line item will automatically display a related list on the Sales Order but does not associate any records... not sure why this ...; Created on 09 July 2024
6. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... you setup a Connection that does NOT use the credentials of the logged-in user and has as scope ZohoAnalytics.metadata.read. The code /* ******************************************************************************* Function: ...; Created on 02 July 2024
7. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... doesn't do the popup on the CRM as well. A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is ...; Created on 14 May 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. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... You would need to record the attachment ID and only push it to Analytics if Analytics doesn't have that attachment ID in its table already... or updates it if it does. You might want to add to the code ...; Created on 05 December 2023
10. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... = 0; v_CrmProductID = r_CrmLineItem.get("Product_Name").get("id"); v_CrmProductName = r_CrmLineItem.get("Product_Name").get("name"); // if the product doesn't exist in Books (sync hasn't happened yet), ...; Created on 18 September 2023
11. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... void fn_Joel_Test() { /*** - tried with getUrl() but this doesn't work. - has to be an invokeUrl - set param name required - if file comes from a Creator form, no InvokeURL needed c_Form ...; Created on 20 July 2023
12. Zoho Deluge: Proper Case for Names: / Zoho /; ... other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended ...; Created on 13 July 2023
13. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023
14. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... I'm storing this here as a reference and taking the bits that I need for the various clients that request an eBay integration. This is a comprehensive snippet which does the whole lot. How? Using ...; Created on 27 April 2023
15. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
16. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
17. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... sometimes works but sometimes yields: // Me,Myself,I\na,b,c Works on systems where the above doesn't work: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename ...; Created on 01 March 2023
18. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time ...; Created on 28 February 2023
19. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... " "); // adding an apostrophe/single-quote to ID values so MS Excel doesn't round them up v_ProductIDStr = "\"'" + v_ProductID + "\""; v_VariantIDStr = "\"'" + v_VariantID + "\""; v_InventoryIDS ...; Created on 20 February 2023
20. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... = zoho.currenttime.toLong() / 1000; // // by default gets last 100 messages (doesn't return anything if no parameters specified) v_Endpoint = "https://cliq.zoho.eu/api/v2/chats/"+v_ChatID + "/messages?fromtime=" ...; Created on 13 February 2023