Assuming some is required, the following 235 results were found.
-
DESC LIMIT 0,50; Additional Note(s): I have added a WHERE clause which omits words less than 5 characters in length, and some other words not to count. I have added the ORDER BY to give me the highest count first in descending order. I have added a...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Applications", then on the plus icon to add new client. Fill in the new form to Create New Client: Client Name: put something descriptive so it is easy to identify if the client has 3rd-parties adding clients. eg. "JoelLipman_BooksConnector". Homepage...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
where you would want dynamic content in a Zoho Creator page without the use of JavaScript or 'Widgets JS'. How? Here are some screenshots to preview what the code below will do, simply copy the code and paste into a Zoho Creator Page. Be sure to copy...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// yields // {"First_Name":"Joel","Last_Name":"Lipman","id":"1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} Some formatting and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", "}{",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is a quick article to template some code to me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Why? At time of this article (Apr-2021), we could not find a working example that could allow us to do this. I have provided some links at the end of this article for you which we tried to use but only helped us out about half-way, the rest we guessed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £ British Pound 0163 € Euro currency 0128 ¥ Japanese Yen 0165 ƒ Dutch...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
its changes to CRM. It was actually causing a loop which used up all the API calls. How? You might already be familiar with some of the trigger options below but one that worked was initially guessed as "none" but then later found in the documentation...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Creator app Click on Plus sign to add a new form > blank Name the form, I'm going to call mine Shopify Webhook Payloads Drag some fields onto the form, this is what I did: Event Type [Drop Down: with options "Order Update", "Inventory Update", "Product...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating a custom related list on a Zoho Finance > Sales Orders...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
without processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 probably manage it in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the application. This is more for complex Creator forms which have workflows triggered from many deltas/changes. Why? Some clients have referred to this as the "spinning circle of death": they load up a Creator application or change a field and there...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of code albeit a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
held in a Zoho Creator form, and sent it to an API wanting the publicly accessible link or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see "Sources" below), the most relevant one being my article Zoho Deluge:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if I encounter any. This is simply how I fixed this error on this occasion. Consider the following code which loops through some Creator records, then loops through one of the subforms in each record: // select a bunch of creator records (ok all of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and end dates of when Daylight Savings Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and refine but here's the snippets for the various DSTs...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
up 2 schedules: one that runs on even hours and one 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?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
download the data file regularly: After all that you will be shown your data table: Additional Note(s): Here are some notes & settings you may need on your quest to setup Zoho Analytics FTP Data Sources: Zoho Analytics IP Addresses to whitelist (if...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF