Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... on) v_TimeZone = v_TimeZone.replaceAll(","," ", true); info v_TimeZone; l_TimeZones.add(v_TimeZone); } //info l_TimeZones; Yields something like: (GMT-10:00) Hawaii Time (GMT-8:00) Alaska ...; Created on 19 October 2021
15. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... \ -H "X-Shopify-Access-Token: " Yields something like the following response: { "image": { "position": 1, "width": 3024, "height": 3024, "alt": null, "id": 12345678901234, ...; Created on 17 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... - 1); } // // output info "[" + l_ProductIDs + "]"; info l_ProductIDs.size(); } Yields something like: [ 1234567890123, 2345678901234 ] 2 Well that produces a lot of ID numbers ...; Created on 12 October 2021
17. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; ... v_BooksCurrencyID; Yields something like: { "EUR": "123456789012345678", "GBP": "234567890123456789", "USD": "345678901234567890", } 234567890123456789 Get Taxes Same as above ...; Created on 24 September 2021
18. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... + ", " + v_Minutes + " " + v_MinGrammar + ", " + v_Seconds + " " + v_SecGrammar ; // yields: 0 DAYS, 23 HRS, 54 MINS, 11 SECS Convert Total Minutes to Hours:Minutes This is for other scenarios: v_TotalMinutes ...; Created on 21 September 2021
19. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; What? This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications ...; Created on 20 September 2021
20. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; ... + v_CreatorTime.toString("Z").subString(3); info v_CrmTime; // yields 2021-09-10T12:49:31-07:00 and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard ...; Created on 10 September 2021