Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
2. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at least 10'000: // v_Counter = 0; l_Loop ...; Created on 31 July 2024
3. Zoho Creator: Sendmail a list of attachments: / Zoho /; What? This is a very quick article on sending an email with Deluge which needs a dynamic number of files attached to it. Why? This came up during a call with another developer and it occurred ...; Created on 20 July 2023
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... join all together v_FullName = trim(v_FirstName + " " + v_LastName); info v_FullName; // // yields: Billie-Jo McDonald-O'Leary II of Cambridge-Worcester-Oxford Caveat(s): This solution does not ...; Created on 13 July 2023
5. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... Monday, 26-Jun-2023 1 26 // yields: 26 // // Sunday, 02-Jul-2023 7 27 // yields: 26 // // Monday, 03-Jul-2023 1 27 // yields: 27 // // Sunday, 09-Jul-2023 7 28 // yields: 27 Originally, ...; Created on 06 July 2023
6. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... This should yield something as follows: { "code": 0, "message": "success", "data": { "payment_terms": [ { "payment_terms_id": "123456000000000123", "payment_terms": ...; Created on 06 July 2023
7. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... = invokeUrl [ url: "https://www.zohoapis.com/crm/v3/settings/business_hours" type: GET connection: "mycrmconnection" ]; info r_OrgDetails; Yields something like { ...; Created on 28 March 2023
8. 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
9. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize m_Respon ...; Created on 13 February 2023
10. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... yields // https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567890,https://i.ebayimg.com/00/s/SAMPLE/z/ELPMAS/$_57.JPG?set_id=1234567891 Note that for the below code, only 1 image is accepted ...; Created on 21 June 2022
11. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... (eg. "Wednesday9March"), which yields the following: Then I get rid of the label with the following CSS: label.zc-Calendar_Day_Select-label Then get rid of the round circles for radio inputs ...; Created on 09 March 2022
12. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... + "/graphql.json"; r_GetProduct = invokeurl [ url :v_Endpoint type :POST parameters: m_GraphQl.toString() headers:m_Header ]; return r_GetProduct.toMap(); } Job done! Yields something ...; Created on 14 February 2022
13. 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
14. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... "$1", false); // yields 12.3 // same expression again but with a different value v_Test2 = 12.000; info v_Test2.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false); // yields 12.000 So ...; Created on 08 February 2022
15. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... v_DecodedString; // yields: Father & Sons A more comprehensive list v_HtmlEntityNames = "amp,lt,gt,nbsp,iexcl,cent,pound,curren,yen,brvbar,sect,uml,copy,ordf,laquo,not,shy,reg,macr,deg,plusmn,sup2,sup3,acute,micro,para,middot,cedil,sup1,ordm,raquo,frac14,frac12,frac34,iquest,Agrave,Aacute,Acirc,Atilde,Auml,Aring,AElig,Ccedil,Egrave,Eacute,Ecirc,Euml,Igrave,Iacute,Icirc,Iuml,ETH,Ntilde,Ograve,Oacute,Ocirc,Otilde,Ouml,times,Oslash,Ugrave,Uacute,Ucirc,Uuml,Yacute,THORN,szlig,agrave,aacute,acirc,atilde,auml,aring,aelig,ccedil,egrave,eacute,ecirc,euml,igrave,iacute,icirc,iuml,eth,ntilde,ograve,oacute,ocirc,otilde,ouml,divide,oslash,ugrave,uacute,ucirc,uuml,yacute,thorn,yuml,OElig,oelig,Scaron,scaron,Yuml,fnof,circ,tilde,Alpha,Beta,Gamma,Delta,Epsilon,Zeta,Eta,Theta,Iota,Kappa,Lambda,Mu,Nu,Xi,Omicron,Pi,Rho,Sigma,Tau,Upsilon,Phi,Chi,Psi,Omega,alpha,beta,gamma,delta,epsilon,zeta,eta,theta,iota,kappa,lambda,mu,nu,xi,omicron,pi,rho,sigmaf,sigma,tau,upsilon,phi,chi,psi,omega,thetasym,upsih,piv,ensp,emsp,thinsp,zwnj,zwj,lrm,rlm,ndash,mdash,lsquo,rsquo,sbquo,ldquo,rdquo,bdquo,dagger,Dagger,bull,hellip,permil,prime,Prime,lsaquo,rsaquo,oline,frasl,euro,image,weierp,real,trade,alefsym,larr,uarr,rarr,darr,harr,crarr,lArr,uArr,rArr,dArr,hArr,forall,part,exist,empty,nabla,isin,notin,ni,prod,sum,minus,lowast,radic,prop,infin,ang,and,or,cap,cup,int,there4,sim,cong,asymp,ne,equiv,le,ge,sub,sup,nsub,sube,supe,oplus,otimes,perp,sdot,lceil,rceil,lfloor,rfloor,lang,rang,loz,spades,clubs,hearts,diams"; v_HtmlEntityChars ...; Created on 27 January 2022
16. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... } } info "Start Date (Next Year): " + v_DST_StartTime.toString("EEEE, yyyy-MM-dd HH:mm"); info "End Date (Next Year): " + v_DST_EndTime.toString("EEEE, yyyy-MM-dd HH:mm"); Yields: Start Date (Current ...; Created on 07 December 2021
17. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... { v_StartTime = r_SubformRow.Start_Time; } } } // yields // UnPredictable exception, Invalid statement found Line:(20) However, I'm not bad at producing errors ...; Created on 17 November 2021
18. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... = v_NextDay.addDay(1); } info v_Today.toString("EEEE dd-MMM-yy"); info v_Tomorrow.toString("EEEE dd-MMM-yy"); info v_NextDay.toString("EEEE dd-MMM-yy"); // // yields: // Saturday 30-Oct-21 // Monday ...; Created on 02 November 2021
19. Zoho Creator: Change Radio into Tabs: / Zoho /; ... = v_Css + ".zc-Tabs-label"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then aligning these radio options horizontally: v_Css = ""; v_Css = v_Css + ".zc-Tabs-label"; v_Css = v_Css ...; Created on 22 October 2021
20. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", ...; Created on 21 October 2021