Assuming additional is required, the following 128 results were found.
-
********************* 1975-01-07 07-Jan-1975 Tue, 7 Jan 1975 ********************* 1975-01-07 07-Jan-1975 Tue, 7 Jan 1975 Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
then it means there was a change. If not then it is unlikely that any change was made. Instead, I need to add an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
type :POST parameters:m_Params.toString() connection:"joels_coql_connection" ]; // // output info r_Coql; Additional If you wanted the unique values of a picklist/dropdown, then consider an invokeUrl looping through the fields settings in CRM....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
retrieve 1970 active product IDs and their SKUs without erroring by going over the Zoho Deluge statement execution limit. Additional: See my other articles for integrating Shopify API with Zoho Creator: Zoho Deluge - Push Item to Shopify Zoho Creator -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
file" + v_Grammar + " to " + r_ContactRecord.get("Email") +". "; } // // return response to user return v_OutputMessage; Additional Change Name of file // // to generate and attach r_DownloadResponse =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
+ " "); v_ResultInformation = v_ResultInformation.concat(" "); input.Note_BookedTimeSelection = v_ResultInformation; Additional: Daylight Savings Time Just to cover all aspects of this, I create a Zoho Creator form with the timezone names, their offset...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Sunday, 2021-10-31 01:00 Start Date (Next Year): Sunday, 2022-03-27 01:00 End Date (Next Year): Sunday, 2022-10-30 01:00 Additional Note(s): This has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for the import to automatically download the data file regularly: After all that you will be shown your data table: Additional Note(s): Here are some notes & settings you may need on your quest to setup Zoho Analytics FTP Data Sources: Zoho Analytics IP...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
v_Test8 = 12.000; info v_Test8.toString().replaceAll("^(^-?\d+\.\d*[1-9])(0+$)|(\.0+$)", "$1", false); // yields 12 Additional Note(s): You might ask why not use the built-in round() function? Well I admit that round() needs to be used for currencies....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Contrary to the documentation saying there are only the approved and converted values supported in additional parameters, I find the below works in CRM just fine: As of 2025, this method no longer works. Please refer to method 2 using a search API or a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
+ "\""); m_Output.put("status","error"); } } // // return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List(); l_Disallowed.add("Joel");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 the other photos from Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
ID" = t3."Sales Person ID" AND t3."MonthYear" = abs_month(invsopoitm."Invoice Date") GROUP BY invsopoitm."Invoice ID" Additional Here are some other queries that are required for the above but you may want to use the out-of-the-box modules instead:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
The Attachment ID column must contain the unique field names. File name column can contain names used on other records. Additional: Here's an AHK script I wrote that produces a GUI that takes an external file where column A contains the key/ID of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= v_CountProcessed + 1; } } } } } info "Page #" + v_Page + ": Processed " + v_CountProcessed + " of " + v_CountTotal; } Additional Note(s): To create a connection in ZohoRecruit: Go to Setup > Developer Space > Functions Create or Edit a function At the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
return m_Response; Even in test mode or simply starting a Cliq conversation will now yield something like the following: Additional For every chat message, the OpenAI ChatGPT forgets what the context of the conversation was about: Well we can populate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
add to the notes field (also overrides the displayed note of "Add your Note here...") input.CSS_Overrides = v_CssNotes; Additional If you don't want to apply this to the every subform on that form, you will need to brush up a little on your CSS with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
= l_CsvFileRows.toString(zoho.encryption.urlDecode("%0A")).toFile(v_CSVFilename); // // yields: // Me,Myself,I // a,b,c Additional Adding to a screen output: eg. a button response or response of info: try holding down the ALT key and pressing 255, then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
== c_Order.Order_Date,c_Order.Order_Date.toStartOfWeek().subDay(1),c_Order.Order_Date.toStartOfWeek()).toString("w"); Additional: I'm just adding a little extra based on the further feedback, if we're generating a reporting year and week, we have to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
]; v_MaxCount = ifnull(r_MaximumCount.get("count"),0).toLong(); v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Additional Urlencoding or not didn't have much affect on the above but it is recommended you do as it did work if the criteria were...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *