Search - Joel Lipman .Com

1. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page of Copyright © My ...; Created on 07 May 2024
2. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... the days of the week which they can then click on to select a particular day. Some navigation is required in the form of a left arrow and right arrow to see previous or next weeks respectively. What ...; Created on 09 March 2022
3. ZohoCRM: Process all records of a module: / Zoho /; ... field update if(!isnull(r_Record.get("Account_Name"))) { // do other stuff v_CountUpdated = v_CountUpdated + 1; } // // update the record irrespectively m_Update.put("Processed",true); r_Update ...; Created on 24 August 2021
4. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... replace the my_owner and my_app with your Zoho Creator owner and app name respectively) Update 2022: I've included the code to verify the webhook came from Shopify: // // declare response variable back ...; Created on 15 July 2021
5. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... let's call it "Notifications". Drag a single-line field and a multi-line field onto the form called "Title" and "Content" respectively. If you use this method to populate your notifications, you can send ...; Created on 06 November 2020
6. Excel - Check a column for values found in another column: / Excel /; ... purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 ...; Created on 14 February 2019
7. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
8. T-SQL: Parse an XML value: / Transact-SQL /; ... -- exist() returns 1 or 0 if node exists or not respectively SELECT Event_XML.exist('/STAFF/EMPLOYEE_NUMBER') FROM [dbo].[XML_EVENTS] -- query() returns typed XML SELECT Event_XML.query('/STAFF/EMPLOYEE_NUMBER') ...; Created on 27 March 2014
9. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... For example, specifying a string like \obj\ or .obj will exclude all files underneath the directory obj or all files with the .obj extension respectively. ...; Created on 23 February 2014
10. Delete related records from multiple tables: / MySQL /; ... s and sst respectively and to leave SessionStaff table unchanged: DELETE s, sst FROM `Session` s LEFT OUTER JOIN `SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` ...; Created on 11 January 2013
11. SSRS Querying on either of 2 Parameters: / SQL Server Reporting Services /; ... of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...; Created on 19 July 2011
12. Set default parameter dates to start and end of month: / SQL Server Reporting Services /; ... googling and reading up on is asking for an article on my own site. Besides this is how I did it and what worked for me... Set the default values for your from and to date respectively: -- From ...; Created on 05 April 2011
13. Invalid arguments passed in router.php on line 325: / Joomla /; ... site has been switched to SEF in the global configuration (where all SEO settings are set to "Yes") and works fine irrespectively. In time, if I ever learn to use it properly, I may change my ...; Created on 03 August 2010