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. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; What? A follow on from my article Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want ...; Created on 14 March 2024
3. 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
4. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... = zoho.people.getRecords("P_Employee",0,200,l_SearchCriterias); v_TotalDeptEmployees = l_DeptEmployees.size(); // ensure total is not zero as we need to divide by it (defaulting to 2 because if 1 the ...; Created on 10 December 2020
5. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This ...; Created on 22 October 2020
6. Zoho Deluge - Determine Quarter from Date with Fiscal Year: / Zoho /; ... year starts from January, simply divide by 3... How? I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months ...; Created on 31 January 2020
7. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... // don't do ssl checks curl_setopt($ch1, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch1, CURLOPT_SSL_VERIFYHOST, false); $my_beautiful_body = ' --joes_awesome_divider Content-Type: ...; Created on 29 October 2018
8. Generate a Timesheet in MySQL: / MySQL /; ... I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into ...; Created on 05 December 2013
9. SSIS Skip Rows in Excel Source file: / SQL Server Integration Services /; ... inserting blank rows to act as dividers. Microsoft Certified Responses: "In the Excel connection you cannot skip Nth rows." "It is not possible." I am shocked at how responses to this and opinions ...; Created on 04 April 2013
10. Three boxes, two roll over, one falls out: / Cascading Stylesheets /; ... the same height, and in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel left over, more the fact that the scripts use that 1 pixel (ceiling rather ...; Created on 21 January 2013
11. Win32 Constants: / AutoHotkey /; ... = $6A Const VK_ADD = $6B Const VK_SEPARATOR = $6C Const VK_SUBTRACT = $6D Const VK_DECIMAL = $6E Const VK_DIVIDE = $6F Const VK_ATTN = $F6 Const VK_CRSEL ...; Created on 05 July 2011
12. Alternate row background colour in Reporting Services: / SQL Server Reporting Services /; ... want a bigger border at the bottom of the overall report and a light one to divide each record. Staying within the properties pane, you can do the following: BorderColor: #efefef, , , White, =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, ...; Created on 04 February 2011
13. Joomla banners not rotating: / Joomla /; The issue here is that you have added all your banners, divided between clients and categories and you're looking for a solution which doesn't involve installing a 3rd party applicatoin. Unfortunately ...; Created on 20 October 2009
14. Countdown: Created on 30 December 2018
15. Homepage (default): Created on 10 January 2018
16. Header (Transparent): Created on 01 January 2018
17. Header (Flex): Created on 30 December 2017
18. Header (Centered): Created on 17 April 2017
19. Header (Adspace): Created on 17 April 2017
20. Gallery: Created on 17 April 2017