Search - Joel Lipman .Com

1. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference ...; Created on 07 March 2014
2. 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
3. Does Google Chrome Frame really improve performance: / Google /; The jury's still out on this one. I have noticed a slight improvement in my page loads but will have to carry out proper tests on the weekend. Instructions to a hard-coder The Google Chrome Frame (or ...; Created on 23 September 2009
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve the document before it gets sent ...; Created on 06 August 2024
5. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... first designing the template, there could have been a fair few improvements right out of the gate. Then the client comes back and says things like "can we add this?", "can it say this instead?", "can it ...; Created on 07 May 2024
6. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023
7. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; What? A quick article on the SPF & DKIM setup to improve email deliverability from a ZohoApp and methods to check. Why? Not sure how I came across it as most of our customers don't use ZohoMail, ...; Created on 04 May 2023
8. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... CARD // Send in as payment endings: eg. $100.00 == payment approved 00 Payment Approved 01 Payment Declined // call issuer code 05 Payment Declined Generic 55 Payment Declined Incorrect ...; Created on 16 March 2023
9. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; What? Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM. Why? Because it is a serious improvement ...; Created on 06 March 2023
10. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...; Created on 17 October 2022
11. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... location, for that’s the email id you need to send files to for those to show up on your Kindle. Getting your email ID approved Just having your Kindle email address won’t suffice unless you ...; Created on 29 June 2022
12. Zoho CRM: searchRecords with sorted results: / Zoho /; ... Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: // ****************** CODE USING ...; Created on 10 February 2022
13. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... which in turn generates an order in Shopify. This article is primarily for myself as I need to do this for some other clients and I just want to continuously refine and improve my code below. How? ...; Created on 21 January 2022
14. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated ...; Created on 10 January 2022
15. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... an example showing how you can get all results irrespective of whether they are converted or approved: response = zoho.crm.searchRecords("Quotes", "(Ref:equals:QU-00001)",1,200,); Done. Ta daa! ...; Created on 29 July 2021
16. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... = Map(); m_Params.put("approved","both"); m_Params.put("converted","both"); r_InvoiceDetails = invokeurl [ url :"https://www.zohoapis.eu/crm/v2.1/Invoices/" + p_InvoiceID type :GET parameters: m_Params connection:"joels_connector" ]; inf ...; Created on 17 May 2021
17. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked ...; Created on 10 December 2020
18. Zoho Deluge - Determine Quarter from Date with Fiscal Year: / Zoho /; ... :: Quarter: 1 Month: September :: Quarter: 1 Month: October :: Quarter: 1 Month: November :: Quarter: 2 Month: December :: Quarter: 2 And just to prove the same code snippet works for any month, ...; Created on 31 January 2020
19. Minimal Privileges for MySQL Database Backup Cron Job: / cPanel /; ... TRIGGER, SUPER, REPLICATION CLIENT, SHOW VIEW ON *.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Suggestions? I'm all up for any suggestions people might have on how this can be improved ...; Created on 20 March 2019
20. GDPR Privacy Policy: / Static Items /; ... information to improve our products and services. We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email ...; Created on 14 February 2019