Assuming check is required, the following 173 results were found.
-
if(v_CreatorPhotoUrl!="") { // // download photo from your Creator (change connection and check TLD) v_Endpoint1 = "https://creatorapp.zoho.com" + v_CreatorPhotoUrl; r_CreatorPhoto = invokeUrl [ url: v_Endpoint1 type: GET connection: "joels_creator" ];...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
that we need to phone this Lead. 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
TLS/SSL, and SFTP - SSH File Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: Schedule with Timezone...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
v_SearchCriteria, v_Page, 200, m_SearchParam); // // loop through search results for each r_Result in l_SearchResults { // check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
r_Download = invokeurl [ url :v_AttachmentEndpoint type :GET connection:"ab_crm" ]; r_Download.setParamName("file"); r_CheckIfDocumentAlreadyExists = Document[Parent_Record == v_CrmContactID.toString() && Document_Name == r_Attachment.get("File_Name")];...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
ZohoInventory.shipmentorders.READ // // init (put your own ZohoBooks/ZohoInventory Org ID v_BooksOrgID = 123456789; // // check the form was ticked and there is a package ID specified if(input.Mark_as_Complete && input.Zoho_Package_ID != "") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
// get the email on this contact record var v_ContactEmail = r_ContactDetails.Email; // check it isn't blank if (v_ContactEmail != "") { // display the found value in the field called "Vendor Contact Email"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// // get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory level or stock check of all the products that are currently listed in a client's eBay store; we want to get the stock level and then use this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
set at the organization level in ZohoCRM. How? Using an invokeURL, the key here is you'll find them in the settings; so check that your connection has the scope to access both Organization details (ZohoCRM.org.READ is enough - perhaps optional) and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
we would create a separate table to manage this data. I can't do this for every client, so here's a quick snippet to just check if Daylight Savings are in effect for the United Kingdom. How? Based on the fact that the United Kingdom is on the Prime...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
7, followed by 1 for Monday, 2 for Tuesday, and so on... How? The logic behind this would be to take the date of the order, check if the order date is a Sunday, subtract a day, and return the week number: c_Order = Order[ID == 123456890123456890];...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with that key. I can't sit there entering one customer at a time. Even a loop...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
a data table in ZohoAnalytics, then the code to list a ticket's attachments and push them to the ZohoAnalytics data table. Check that ZohoDesk is sync'ing with your ZohoAnalytics: Login to ZohoAnalytics as an Admin with access to ZohoDesk Make a note of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
: v_ProductPrice; ZDK.Page.getField("Unit_Price").setValue(v_ProductPriceFormatted); // and if we don't want/need to check, just round em (also means you don't need the above function to count decimals) var v_ProductCost =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// // add into subform (actual form "Document"). Uses row.ID as the identifier to prevent duplicates. c_CheckDoc = Document[Subform_Row_ID == v_ImageRowID]; // // if exists then update if(c_CheckDoc.count() > 0) { c_CheckDoc.Image=c_ImageRow.Image;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the actual product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the total number of products (wp-admin > Products > All Products). Source(s): WooCommerce - List all products WooCommerce -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= invokeUrl [ url: v_EndpointPortals type: GET connection: "my_projects_connection" ]; info r_Portals; // // once we check the JSON, we can select a portal name and ID, this avoids the need of using up an API request to get the portal v_PortalName =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
and go into the workspace you want to create the monitoring system. Preferably use the workspace that has the data to check. For demo purposes, I'm going into the CRM Reports workspace > Click on "Create" > Then select "Dashboard": Then in the top right...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than proposing an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *