Assuming where is required, the following 228 results were found.
-
// // build up COQL Query v_CoqlQuery = "select Start_DateTime, End_DateTime from Events where Created_By='" + v_UserID + "' and ("; v_CoqlQuery = v_CoqlQuery + "Start_DateTime>='" + v_FirstDateOfWeek + "T00:00:00+00:00' and "; v_CoqlQuery = v_CoqlQuery...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both for outbound and inbound but local to the customer and we want to remind our customer that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
= Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where found for each v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode = v_StringToDecode.replaceAll(v_HtmlKey,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
oldest first and keep only first one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by id limit " + v_PerPage}; r_CoqlSortedProducts = invokeUrl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= "{locations(first: 5, reverse: true) { edges { node { id name } } } }"; Then using the Location of your product variant (where "1234567890" is the location ID) to get the recent 10 products updated today: { productVariants( first: 10 reverse: true...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with the days of the week which they can then click on to select a particular...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
and click on the ellipsis/3 dots Select the REST API Enable REST API Note the REST API function and you can now call it from wherever. Done Additional Caveat(s) This currently does one image from Zoho Inventory. I'll need to add to the code to retrieve...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
customer payments and updates the custom fields. Executing the function this worked as expected. Now put it on a workflow where the settings were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it includes the keywords in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
// // sometimes works but sometimes yields: // Me,Myself,I\na,b,c Works on systems where the above doesn't work: l_CsvFileRows = List(); l_CsvFileRows.add("Me,Myself,I"); l_CsvFileRows.add("a,b,c"); // v_CSVFilename = "Test.csv"; f_CSVFile =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I can confirm this works. Why? I've covered this before in a fair few articles on this website but for clients in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
+ v_PublishKey + "?filepath=/" + v_DocFileName; // // Store the link to the local file as the local image - this is where we could check on file extension and substitute with PDF, DOC, XLS extensions c_Document.Local_Image = ""; info "File: " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
without proper testing. Aggregate of total amount may be unnecessary as this could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
on Create and function to create task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition since go live and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code is sitting right now. The code snippet to get the item record from the price book Note that I'm using...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure you setup a Connection that does NOT use the credentials of the logged-in user and has as scope...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. A...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= ifnull(r_FutureEvents.get("events"),List()); Additional: Code to get a single event: The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
Notification Many ways to add a button but here's how I do it (requires some basic HTML/CSS knowledge): Place the cursor where you want the button and give it some text, I'm going to start with Accept Quote Then click on the link icon and give it the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
on the value. Assuming I have a tab called "Sales Pipeline", and "Hire Pipeline": Go to the deal record and scroll to bottom where you can see an "Edit" button for this canvas. The edit mode of the canvas will popup in a new tab. Right-click on the tab...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *