Search - Joel Lipman .Com

1. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... How? So I'll go over what happens in the real world process; then cover some technical information; and even include the function that makes it work: Business Process Customer visits website to ...; Created on 26 January 2024
2. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... = v_CSVString.tofile("PaymentRun.txt"); Attach the file Attach this to any record. Here we'll use the last record used initally to generate this CSV/Text file; which happens to be a bill: // // ...; Created on 02 October 2023
3. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... return false to prevent saving of record return false; Caveat(s) This only happens if the record is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. ...; Created on 20 July 2022
4. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
5. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... window"); Known Issues Popup opens in the parent window: This only happens on certain machines and I couldn't narrow down the cause. I have tested on both Mac and PC but I had a client usin ...; Created on 06 November 2020
6. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... Now access this application and preview your masterpiece! The following screenshot shows what happens when I change the parameter: Additional Note(s): I have found that adapting Widgets ...; Created on 24 October 2020
7. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... DON'T insert into Product table v_ProductID = l_ProductDetails.ID; } What Happens: In the example above, the count to see if "Myproduct1" exists counts as zero (0). It doesn't think the product ...; Created on 21 November 2019
8. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... day of the month and coincidentally a Monday, then we would want to specify the field date to be the first Monday of the next month. If however we want the last Tuesday of the month and that Tuesday happens ...; Created on 27 September 2019
9. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... Common Error(s): : Happens if you have a wrong CODE or generated another one after the one you're using. You need to use the latest CODE as any new one expires any previously generated ones. A code ...; Created on 17 July 2019
10. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; ... What I DON'T Want (happens if you use list-style-position: outside) 1. Item 1 1.1 Item 1a 1.2 Item 1b ... 1.9 Item 1c 1.10 Item 1d 2. Item 2 How? I'v ...; Created on 10 July 2019
11. Forgotten Super User Password in Joomla 2.5.x - 3.x: / Joomla /; What? A quick article on how to set a password using the database tools for super users. Why? It happens to us all, especially me. I like to use different passwords for every site but this came ...; Created on 06 February 2015
12. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; ... webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. Why? The problem happens because of ...; Created on 11 November 2013
13. SSIS Skip Blank Rows in Flat File Source: / SQL Server Integration Services /; ... problem also happens when you have a Data File of varying column numbers. My solution below will also fix this. How? My data file had some empty rows amongst the data. The easy fix is by dealing ...; Created on 23 April 2013
14. MS Excel - Sort pivottable column headings by date: / Excel /; What? This is a quick note to myself so that I never use parentheses in the column headings again. Basically I have a pivot table in Microsoft Excel 2010 with the projects down the left (in the first ...; Created on 12 April 2013
15. Export/Import Database using MySQL Workbench: / MySQL /; ... We're going to go on the basis that you already setup a connection to your database under the SQL Development section. Export/Import happens under the Server Administration section: Let's create a ...; Created on 05 February 2013
16. Set up Desktop SlideShow in Windows 7: / Windows OS /; ... "clicking on Desktop Background", "browsing to the Picture Location". The problem happens when browsing to the picture location and it doesn't seem to remember which folder you selected. At home, this would ...; Created on 22 January 2013
17. Inline Labels in Form Fields using Javascript: / JavaScript /; ... case, if the value is "Name:", then clear the field and change the color to black (so when they type they can see what they're typing). onBlur() - happens when the user clicks outside of the field or moves ...; Created on 21 August 2012
18. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... but has an ID number, then the first query returns NO ROWS and then the second query errors and the whole stored procedure fails. The same problem happens when using these as a subquery which has an empty ...; Created on 24 January 2012
19. SSRS Repeat Headers in PDF Report: / SQL Server Reporting Services /; ... When I run the report in BIDS, the whole report (despite spanning 10 pages when printed) is on the same page. The same happens when I run this on the Reporting Server. My Setup - XP Workstation ...; Created on 26 October 2011
20. T-SQL Record Separator: / Transact-SQL /; ... different to previous row)... Stage #3: Use dummy separator row Thinking logically, Stage #2 overwrites data in the last row of the day (the one marked with a separator) which happens to be data ...; Created on 11 October 2011