Assuming where is required, the following 226 results were found.
-
lines/line breaks/carriage returns are at the end of a line.... for example, maybe your CSV contains multi-line fields; eg. where address street is on a different line to address city but in the same column... The following regex will replace new lines...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
field2 when field1 is changed. When field2 is changed, it is told to update field1. This causes a recursive or endless loop where each field triggers an workflow/automation, even if the value has not changed, to modify another field and vice-versa. This...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= v_Css2 + ""; input.Note_TabCSS = v_Css2; Label Placement #4: If you've selected the form customization label palcement 4 (where the labels are inside the field): Then use the following onload CSS: // // change radio group into tabs v_Css = ""; v_Css =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ " " + v_NextDay.toString("MMMM") + " "; Generate a list of working dates given a number of days So here's another scenario where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
statement found Line:(20) The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records (ok all of them)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// // 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
- 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
- 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
- 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
- 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
- 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
- Language: *
-
are unnecessary on the O11 Dynamic Mini and air flow isn't perfectly balanced. I'd opt for the O11 Air Mini (newer one) where fans can be mounted to the front and it supports an ATX Power supply. I bought 9 Coolmoon fans (3 x 3-packs) but left the 2...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- 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: Zoho
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF