Search - Joel Lipman .Com

1. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... to get workspace ID, look at the URL in ZohoAnalytics and take the number straight after the word "workspace/" v_WorkspaceID = "12345000001234567"; // // to get the Analytics Org ID, login to Zoho Analytics, ...; Created on 02 July 2024
2. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... because you have it processing data rather than responding straight away (less than 1 second requirement) to Shopify with "yes received" response. As such, here's a function which lists the Shopif ...; Created on 22 April 2024
3. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...; Created on 17 August 2022
4. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... print (6 June 2022) and I wanted to make sure it didn't just disappear or be difficult to find in future. How? The process of sending a PDF file to your Kindle device is also quite straightforward. ...; Created on 29 June 2022
5. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... for outbound and inbound but local to the customer and we want to remind our customer that they have an appointment in 1 hour with us. How? The code is actually pretty straightforward but you will ...; Created on 16 December 2021
6. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... and remind us that we need to phone this Lead. How? It sounds straightforward: schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... ...; Created on 18 November 2021
7. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... page for each minor issue. How? So I'm going to try and list solutions to minor errors we run into. Problem: Zoho OAuth Connection: ERROR_invalid_operation_type Sounds rather straightforward, ...; Created on 06 February 2020
8. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... product that they didn't stock. How? So editing the product_details field of an invoice record seems straightforward but it isn't. Undocumented, the trick is to remove the existing ID of the line ...; Created on 22 August 2019
9. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; ... the data source used in the report. For static data source connections, this is straightforward but in our case, we have a report which points to different servers based on a report parameter. How? ...; Created on 11 November 2013
10. SharePoint 2007: Change profile picture with minimal permissions: / SharePoint /; What? This is a quick article on how to change your profile picture in your company's sharepoint site. Sounds straightforward but without being allowed to upload images or edit other profiles, each user ...; Created on 07 November 2013
11. Access MySQL databases using Oracle SQL Developer: / MySQL /; ... SQL Server instances but it wasn't practical to link this to mySQL databases. How? So this is how I did it, I found the process rather straightforward anyway so let's begin: Download the JDBC ...; Created on 01 February 2013
12. Delete related records from multiple tables: / MySQL /; ... DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent represented by aliases ...; Created on 11 January 2013
13. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; ... other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT ...; Created on 10 October 2012
14. Joomla article modal with clear button: / Joomla /; ... the solution is really that straightforward. Feel free to check for any dodgy code but I've simply added the clear button to the existing article modal file (Joomla 1.6.x to 2.5.x). Don't overwrite any ...; Created on 27 August 2012
15. Basic Oracle Stored Procedure Structure: / Oracle PL/SQL /; ... second query which we're hoping will be quicker than a straightforward table join. Syntax CREATE [OR REPLACE] PROCEDURE stored_procedure_name [ (parameter [,parameter]) ] IS | AS ...; Created on 16 January 2012
16. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... a million better solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away which is the better report; ...; Created on 02 December 2011
17. AutoHotkey Format Date and Format Seconds: / AutoHotkey /; ... straightforward form FormatTime( TimeString, Format ) { FormatTime, FormattedTime , TimeString, %Format% return Formattedtime } The following function is to convert a given SQ ...; Created on 20 September 2011
18. Joes Quicklist Weblinks (JQW): / Product Documentation /; ... and popups are CSS3 driven. These will only really display properly in browsers that support CSS3 (Chrome, Firefox 3.5+, Safari 4+, MS Internet Explorer 9+). Other users should just see a straight angl ...; Created on 03 July 2011
19. Room Availability Calendar in Business Intelligence Development Studio: / SQL Server Reporting Services /; ... code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix Tablix: We want all rooms on the left and the time along the top. We select a matrix ...; Created on 23 March 2011
20. This file contains HTML or script code that may be erroneously interpreted by a web browser: / Hypertext Markup Language /; ... Edit your /includes/specials/SpecialUpload.php file and add the following line shortly after the declaration of detectScript function: if ($extension === 'swf') return false; I put it straight ...; Created on 08 October 2009