Search - Joel Lipman .Com

1. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... long as I can get to the 3rd tab of the widget (it becomes enabled once you've completed enough on the 1st tab): I'll click on the 3rd tab called "Settings" then on the sub-tab "Image", and click on ...; Created on 25 July 2024
2. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... was not accurate enough... but here's the snippet: r_CommentsHistory = Map(); l_Comments = ifnull(r_CommentsHistory.get("comments"),List()); for each m_Comment in l_Comments { if(m_Comment.get("description").containsIgnoreCase("Purchase ...; Created on 09 July 2024
3. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... to tidy these all up would leave the data more and more unreliable. So Shopify want your webhooks to respond within 1 second. This is about enough time to store the record but that's it. Processing ...; Created on 22 April 2024
4. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...; Created on 03 July 2023
5. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... to not adjust stock level if item has enough quantity then that purchased - Adds tracking number and carrier to shipment record on either creation or modification. - Only creates shipment order ...; Created on 27 April 2023
6. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... your connection has the scope to access both Organization details (ZohoCRM.org.READ is enough - perhaps optional) and access to Settings (ZohoCRM.settings.READ). I'm calling mine "mycrmconnection". r_OrgDetails ...; Created on 28 March 2023
7. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... of mine (see my pinterest) to build a nicer looking computer and I was given £1000 towards a new computer... It's more than enough to get a running White Snow Edition PC but I put in some more to get the ...; Created on 12 March 2022
8. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... that runs on odd hours to change this to every hour. It's not enough for some, so the below details on how you can get Xero to tell Zoho when a contact or invoice has been updated immediately. How? ...; Created on 10 January 2022
9. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons ...; Created on 22 September 2021
10. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... to get me a Session ID. Once I've used this and signed in once, it will last a few seconds, long enough for me to do my Fetch Auth'n'auth token process: string API.fn_eBayConnect_AuthToken_GetSessionUrl() { /* Function: ...; Created on 20 September 2021
11. Zoho Creator: Add a subform while creating a record: / Zoho /; ... go. How? Here's a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below example, my ...; Created on 14 July 2021
12. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... may want to find: Company Name: Father & Sons (Incorporated) Contact Name: O'Reilly How? Well I've tried various replace methods with regular expressions but the only method reliable enough ...; Created on 28 August 2020
13. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... not appear to be included in any sync... This method would be enough if the action was instantaneous and the attachments were also attached to the Sales Order in Books... but it isn't and doesn't. It only ...; Created on 15 May 2020
14. Convert foreign characters to English alphabet: / MySQL /; ... We need to ensure that a search for any of these kind of words will return results of similarly typed/sounding words. How? Here's just a splurge of SQL but I use this often enough: UPDATE ...; Created on 13 June 2016
15. Joes Google Map for Joomla (JGM): / Product Documentation /; ... fun! I've added the options to style the map while trying to keep it simple enough for my clients. Why am I giving it away for free? Could be malicious or could be that I made this for a website, ...; Created on 13 April 2015
16. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; ... connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source ...; Created on 13 June 2014
17. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... to refine the search enough to get the records they need. Granted this may not be a viable solution for your case, but this did what we were asking and is a serious improvement to the user experience. ...; Created on 07 March 2014
18. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; What? A quick note on how I got round one this one. Why? Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get ...; Created on 05 December 2013
19. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... every package). Here is the near enough final version of my script (or more like an experienced colleague's comprehensive script to which I have merely added my transform part) added as a data flow ...; Created on 04 October 2013
20. Improve Default Joomla Search: / Joomla /; ... near enough). How? I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving ...; Created on 07 May 2013