Assuming point is required, the following 34 results were found.
-
of 12.50%. Well there might be a longer solution without using a regular expression (regex), as in check for the decimal point, check each digit thereafter to see if there are zeros... But I'm keen on avoiding using loops where possible so we don't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
after being muted for 10 days will be banned for a month, and for 2 months for the next offense. Permanent ban - At this point, it is obvious that will never learn your lesson, thus, a permanent ban is necessary to be rid of the problems you cause. The...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
LIVE to TEST (Operations > Copy to... > untick "Create Database") Done! and you have all the necessary backups for a restore point. Additional Notes Don't forget the .htaccess file for Search-Engine Friendly (SEF) website addresses as a lot of web-based...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
control of the website. If you are dissatisfied with our services or need another developer to take over, you can at any point control which server your website visitors will go to when they type your domain name. Important: You only need the domain...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Dynamic Zones are created using data fed for extreme weather conditions, earthquakes (by earthquake.usgs.gov) and at some point temporary flight restrictions. Currently Listed Zones: Worldwide airports as listed by IATA.org Worldwide airfields for...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
and will be either .COM, .EU or as per your region. If the first part of your URL says: https://zoho.com/ then use the endpoint https://www.zohoapis.com/crm/v2/coql https://zoho.eu/ then use the endpoint https://www.zohoapis.eu/crm/v2/coql...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
how to create your first widget in a MacOS environment. I aim to create a WindowsPC version of this document at some point for my colleagues. The below instructions follow a fresh install as if this is the first time this computer has created a Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
app with the scope: ZohoCRM.modules.ALL (potentially you could try just using ZohoCRM.modules.Attachments.READ but at this point I couldn't be asked). Then publish the report of this form (eg. "Download File Report") and get the long publish key it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
fields from one module to another, sometimes you need to manage existing multi-lookups/users in a record. How? So the key point to remember is that all multi-select lookup and multi-user lookup fields are held in temporary CRM modules called a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
on how to do this but I thought I'd write this article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM users to think about tax and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
or ZohoCRM.settings.ALL as well; I've called it "zcrm". Standard Call for Module Record Count: v_PerPage = 200; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count"; r_MaximumCount = invokeurl [ url :v_Endpoint type :GET connection:"zcrm"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
+44 (0)1234 567890 sales@mycompany.com QUOTE The Quick Answer: the footer This repeats the footer on every page. The key point is the HTML attribute zcpage-footerhtml; but note the 3 other CSS classes zcpage-pagenumber, currentPageNumber, and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Now we need the webhook added to ZohoSign so that when a document is completed, it tells ZohoCRM. First, let's create an endpoint for the webhook in ZohoCRM: Login to ZohoCRM > Setup > Functions > and hover the mouse over the function you just created...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A really quick article on demonstrating a nested try...catch()... statement working in Zoho CRM. Why? To prove a point to ChatGPT who said this was not possible... and to deal with a scenario which exists for a client of mine. The use-case for my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
(eg. quotes, sales orders, invoices, purchase orders), then it will delete the older one (referred to as keep ID). Another point is that this is using COQL to sort the records and tries to keep the first version of the record (sorted by ID ascending)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
then to reconcile these. This particular case covers where the Cx had a working automatic bank feed for a while but at some point simply stopped working. How? First let's go through a resolution and get the official response on what impact this has on...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
the string you want to find -- Replace stringtoreplace with the string you want to replace with -- REPLACE FROM A STARTING POINT -- Read-Only (see changes to commit) SELECT a.`fieldtochange`, SUBSTRING(a.`fieldtochange`, INSTR(a.`fieldtochange`,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
SQL Server Integration Services Script Component * Write scripts using Microsoft Visual C# 2008. * ScriptMain is the entry point class of the script.*/ using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
as the "My Documents" folder on every computer I use. It was fine with my 16Gb one but my 32Gb ones have all failed at some point. I went for a cheap one on Play.com (Verbatim 32Gb@£49.99 & Kingston DataTraveler@?) and an even cheaper one on Ebay.com...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB