Search a database for a value and count matching rowshttps://joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 any table only changing the parameter column. ** ** ** ** Usage: ** ** EXEC [usp_CountRecordsPerTablePerColumn] '3', 'Customer_ID'; ** ** ** ** Parameters : ** ** - Value: the value you want to match on (eg. Customer_ID) ** ** - Column: the column name...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 is not. My only solution was to propose to set the background as white (#f7f7f7 - white with a tint of grey) and show the customer the unnoticeable difference: /* CORRECTED CSS: STABLE AND CONSISTENT !!! */ background-color: #f7f7f7; background-clip:...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 medium), accompanied by a written offer, valid for at least three years and valid for as long as you offer spare parts or customer support for that product model, to give anyone who possesses the object code either (1) a copy of the Corresponding Source...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

T-SQL concatenate an incremental row numberhttps://joellipman.com/articles/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

24 May 2013 has a degree in Computer Science BSc and some qualification in being Superman. Specification The output expected by the customer is the following: EMP -------------------------------------------------- EmpNumber QualificationRef 001 00101 001 00102 002...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Client Services: Website Development Agreementhttps://joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 to continue the work. JoelLipman.Com will produce a signed-off production site as per the initial specification: Front-end customer facing interface as per an agreed template. Back-end administration interface for managing the website (GUI based for...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Submit form as a server and not the client with cURLhttps://joellipman.com/articles/automation/api-misc/submit-form-as-a-server-and-not-the-client-with-curl.html

20 February 2015 sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to connect their Mobile App to a third-party API. The third-party only accepts requests from a static and permitted...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 be displayed to an admin and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup using the built-in popup of Zoho...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

07 October 2021 as the same as the billing address... Or more specifically, the primary contact, company, address and phone from the customer record and not from the sales order change. How? The key is a setting you need to change by going to Settings > Preferences >...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has to go to the CRM record, click on Mail Merge, which opens...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 '2021-11-19 11:12:34'; // // manual setting to specify system/application offset v_ApplicationTimeOffset = "-05:00"; // // customer is in (America/Los_Angeles) v_CustomerCallTime = '2021-11-19 08:12:34'; // // set system/application date time start in...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

25 January 2022 possibly the same name but with a suffix such as "Copy", "Clone" or "2" (or your own company initials just to show the customer who's boss). Now click on the pencil icon of the cloned template Right-click on the text box causing the issue and select...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-inventory-upload-image-to-item-record.html

21 June 2022 listing in Zoho Inventory. Why? We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. We want the photo on eBay to be downloaded and uploaded to the Zoho Inventory record for the respective record. As Zoho...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 A noteworthy article in my opinion on how to send a CRM quote record using a template the customer created from a button. Why? Yes you can do this already by going to the record, clicking on the ellipsis or three horizontal dots button in the top right...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 step (repeat this step if you fail) STEP 3: GENERATE A REFRESH TOKEN For the following, browse to Zoho Sign, login as the customer, click on Settings > API Tokens > then API token - deployment > Get Started Fill out the client ID and client secret along...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, a package slip/delivery note, a shipment order; as well as record any payments,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 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, but there is a Zoho Toolkit to run some checks on the email deliverability for a customer:...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Change System Field Lengthhttps://joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 an article documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead record to an opportunity (or Deal) record. If you are using custom...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so here's a quick...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

05 December 2023 and then to push the attachment from ZohoDesk to ZohoAnalytics using the API. The use-case here is that a client wants customers to submit ZohoDesk tickets and upload photos of the problematic product to the ticket. They then want an Analytics report to...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Basic Widget with Zoho Datahttps://joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I added all the layers of complexity, I want to have here an example that demonstrates a basic search on a table...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *