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. ZohoBooks: 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Burton Theo van Doesburg Thomas Cole Toyin Ojih Odutola Wayne Thiebaud Victor Vasarely Vincent van Gogh Wassily Kandinsky Wilfredo Lam William Blake Willem de Kooning Xu Bing Xu Zhen Yayoi ...; Created on 11 February 2023
15. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... doesn't exist, so let's add it if(v_CountExists == 0) { // // prevent duplicates by updating record with existing name if exists v_Name = v_CandidateZohoID + "" + r_Data.get("id"); // ...; Created on 08 February 2023
16. ZohoCRM: Import Attachments: / Zoho /; ... then include in the upload "Contacts_001.csv") The mandatory field 'Attachment Id' must be mapped: Give a unique value for the column attachment ID (filename column does not need to be unique) and ensure ...; Created on 16 January 2023
17. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... if this doesn't work, enable one of the following 2 lines //r_File.setParamName("attachment"); //r_File.setParamName("file"); r_File.setFileName(v_DocumentName); r_Attach = zoho.crm.attachFile("Deals",v_DealID,r_File); info ...; Created on 17 October 2022
18. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... create a button that sits on the view page of a record and the staff simply click on and it does all the aforementioned. How? The difficult part here was to figure out how to convert the CRM record ...; Created on 18 August 2022
19. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... you simply add an option to the picklist and then specify which of the options are selected. In this case, simply giving it the IDs should work... but it doesn't. Assuming my multi-lookup field is ...; Created on 18 August 2022
20. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... view mode and edited just one field). The only other event you can use this in inline editing mode in is the Canvas mode. Error(s) Encountered Contacts doesn't seem to appear in Client Script IDE. ...; Created on 20 July 2022