Assuming returns is required, the following 90 results were found.
-
r_RecordDetails.Account. Line:(442) How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a number with .toLong()....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), and updates the Opportunity/Deal/Potential record. In this example, the custom field is called "Division": // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
lot of ID numbers delimited by a comma. However, to match my use-case, I want a list to which I can give it an SKU, and it returns the Shopify Product ID (not of the variant but of the product). In which case, I need to tweak the above function a little...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
} // don't save record? return false; Note(s) Using the following line returns all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for future reference. var l_existingSubformRows =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
fn_DHL_CheckShipmentStatus(string p_TrackingNumber) Purpose: Queries DHL for tracking information about a shipment and returns the status code (eg. "delivered") Date Created: 2023-03-21 (Joel Lipman) - Initial release Date Modified: 2023-03-21 (Joel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
// get the ID of this record var v_ThisRecordID = $Page.record_id; // get the full name of this contact (not sure why this returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
added all the layers of complexity, I want to have here an example that demonstrates a basic search on a table of data and returns one record as a result. The use-case here is that we are enhancing a quote builder form in Zoho Creator. The JS widget...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= invokeurl [ url : v_PriceBookEndpoint type :GET parameters: m_Params connection:"zbooks" ]; // // tests show this only returns the 1 relevant item from a pricebook of many more items l_PriceBookItems = ifnull(r_ThisPriceBook.get("items"),{}); for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
time of print, this hasn't happened yet. Here's a function in deluge that takes a 3 or 6 character hexadecimal color and returns the RGB values for you. How? Very quickly, we take each character from the given string and convert it to its RGB value....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the CRM. The cause of the problem is the same as covered in my article Joel Lipman - ZohoCRM: zoho.crm.searchRecords only returns certain records. Consider the following code: /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
send it a bit of code in HTML and we want a PDF file returned. I have severaly instances of an API which accepts HTML and returns a PDF file. Nothing complex but issues with one of the servers being down, or inaccessible due to certificate expirys,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to a new variable name, it will fail. In other words: m_NewTag = m_Tag.remove("id"); // yields null m_Tag.remove("id"); // returns m_Tag map without the ID key-value pair The use-case This is a snippet that gets the tags of a contact and copies it over...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Date Created: 2025-03-31 (Joel Lipman) - Initial release Date Modified: 2025-03-31 (Joel Lipman) - Removed crmAPIResponse. Returns as list (JSON string) More Information: Any information that may help...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the canvas view page on each of the tabs. Then we'll make an OAuth function that can be executed by the client script which returns the value of the Pipeline given a deal record ID. Finally, we'll have client script execute this function, then show/hide...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
latest responses that a respondent has completed; this means that if they have completed the same survey twice, this only returns the latest one they completed. SELECT i."Attempt ID" AS "Survey Response", max(i."Survey") AS "Survey", i."Page Number",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
Xero API so here's the pull of the first page of invoices by most recent first (invoice date). There is also a table that returns the name of tax rates and then the percent that these equate to which I've copied below this invoices pull function. the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
will need to delete the manual ones. Escalate with your Zoho partner if you cannot disable/refresh the feed. If disabling returns the “linked with an integration” message, raise a ticket with Zoho Books or Partner Support. Ask them to reset or remove...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
database, and there is one specific article you visit a lot, it would be nicer just to type a number like "1234" and this returns that specific article. In the case of Joomla, we'll use the article ID. Pre-Notes: This article consists of instructions to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB