Search - Joel Lipman .Com

1. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... doesn't do the popup on the CRM as well. A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is ...; Created on 14 May 2024
2. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... from a public domain, no user wall. The key here which the official documentation is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. ...; Created on 20 July 2023
3. Zoho Inventory: Enable Tracking using the API: / Zoho /; What? One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory ...; Created on 04 May 2023
4. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company ...; Created on 28 August 2020
5. 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
6. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
7. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
8. Joes Google Map for Joomla (JGM): / Product Documentation /; ... Points of Interest (POI). Considering I spent a good month styling Google Maps for Android OS on a mobile app, having access to the Google Map API v3 in JavaScript is a doddle... And incredible ...; Created on 13 April 2015
9. MS Excel: Convert a text to a number: / Excel /; What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...; Created on 15 November 2013
10. Autohotkey Count Number of Files/Folders in a Directory: / AutoHotkey /; ... contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual processing ...; Created on 04 June 2013
11. Convert Decimal (Person Days) to Time in Excel: / Excel /; What? We have an excel spreadsheet which reports against a mySQL database and reads time spent on projects by IT Service colleagues. The main report is a pivot table with staff members along the top, ...; Created on 13 February 2013
12. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...; Created on 19 January 2012
13. Strip HTML in MySQL: / MySQL /; Just putting a note as I have spent ages looking for a solution and getting it to work in my environment. What? Need to be able to omit HTML tags in certain fields of a mySQL database. Why? ...; Created on 06 December 2011
14. Excel PivotTable Filter List Ordering: / Excel /; ... summarizes for our guys at the top, all the activities and time spent by staff. There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a ...; Created on 05 September 2011
15. SSRS Redirect after a report is run: / SQL Server Reporting Services /; ... page after a certain time. Conclusion In the end, this came down to a design decision. Time spent on trying to find a solution was not considered to be warranted. My reports use a parameter ...; Created on 12 August 2011
16. The ReportServer Database: / Databases /; Amazing, I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation ...; Created on 08 August 2011
17. CSS keeping the footer at the bottom: / Cascading Stylesheets /; Spent enough time trying different methods across the web but only 1 article worked for me using the "push" div layer. Loosely based on Ryanfait: Make a Footer Stick to the Bottom of the Page Aim: ...; Created on 25 April 2011
18. SSRS - Lost window with datasets: / SQL Server Reporting Services /; ... I spent a bit of time enabling/disabling toolbars before I found this. Open a Report solution (or have one open already?) The menu link is "report data" and it's right at the bottom of the "View" ...; Created on 25 March 2011
19. Border settings not saving in SSRS: / SQL Server Reporting Services /; This may sound silly to some but I've written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells ...; Created on 24 March 2011
20. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; Well I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing ...; Created on 23 March 2011