Assuming returned is required, the following 67 results were found.
-
new record r_NewRecord = insert into [ = = = ]; } Done: Additional Remember that an integration field on the interface is returned as a string and needs to be converted to a number to be assigned, eg: r_Details = myForm[ID == 1234567980123456789];...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
return m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list cannot be displayed.: You are trying to return (an empty...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
"id": "123456789000000006" } ], "info": { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
+ "?filepath=/" + v_Filename; l_ShopifyPictures.add(v_ImageSrc); } // after I've pushed the product to Shopify and it returned to me a Product ID: if(v_ShopifyProductID != 0) { // do photos if(input.Photos_Changed) { v_PositionIndex = 1; for each...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
How? It sounds straightforward: schedule a call using the GUI then write a test function to check the JSON that is being returned for API names... If that were the case, it would have been a 5 minute job. Instead, it's turned into over an hour of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
omit the parenthesis. If multiple expressions then separate each with parenthesis joined by "and" or "or". Nulls are not returned. Set the "ModuleToSearch" to the API Name of the module you want to search. Method #1: zoho.crm.searchRecords() Contrary to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for the relevant Deal record in CRM. Why? A client wants that when this field is entered and the document signed and returned, it attached the signed document to the Deal record. How? The following is the process from registering the app to call on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
+ v_SchoolName,1,10,m_Blank,"zcrm"); for each r_School in l_SchoolSearch { // check no search error and valid records are returned if(!isnull(r_School.get("id"))) { // check this record is the same school...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
2 separate API calls after you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include these in her estimate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
in the background: File is generated FIle is attached to the last record of the source data File identifying number is returned from being attached File is opened in a new tab/window to trigger downloading. File is deleted from attachments based on its...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
generates all email signatures (no criteria). You will need to change the HTML signature and use the Image Source URLs returned from the above function to generate a HTML signature, then use placeholders for the code to replace these with the user's...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
up related list rows l_RelatedListData = List(); for each m_DataRow in l_DataRows { // double-check in case books has returned 1st page rather than filtered rows if(m_DataRow.get("SO ID") == v_SalesOrderID) { m_Details = Map();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Cx is that they need documents converted from HTML to PDF — as in we 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
- Get Quoted Items Trigger: Triggered by a client script to retrieve quoted items Purpose: Standard Product_Details can be returned in client script. The purpose of this function is to retrieve the crm v2.1 Quoted_Items (custom fields of a line item)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{"p_DealID": v_ThisRecordID}); // Parse the response to retrieve just the pipeline value (returned string) var v_DealPipeline = r_DealDetails._details.output; // set all tabs to hidden ZDK.UI.getElementByID("Tab_SalesPipeline").setVisibility(false);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
API Key and OAuth enabled (hover over function in CRM setup and select REST API, then tick both to the "on" position). The returned output from this function should be the HTML that will be displayed in your JS Widget: string...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
page with the affinity template finally worked!!! Chuffed to bits as you might imagine but clicking on any other link returned an error something along the lines of "template tpl load file styles prosilver login body does not exist empty". I backed up...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
K2 Items disappearhttps://joellipman.com/articles/cms/joomla/k2-items-disappear.html
the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should be repaired The Quick Fix I managed to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
-- If you select the part of each expression from the SELECT and run these -- to see what results are returned, it is reading only and not making any -- changes. It will show you what data the query is planning to migrate. -- EXAMPLE: -- SET...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
is for when you want any of the values from one resulting row. You will need to know the column order the results are returned in. $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select(array('name', 'email', 'username'))...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB