Assuming script is required, the following 98 results were found.
-
and record editing when compared to API v2. How? Note that this is using Zoho Deluge and not another server-side script such as PHP to send the requests via API. Following standard OAuth 2.0 procedures, we will get a Code to generate a Refresh token,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate or populate a list of the files in the script directory, the 2nd to do the actual renaming. A text field is provided (defaults to A_ScriptDir) to specify what folder to...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company name. The issue is that if you use zoho.crm.searchRecords() this will work...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_LineItem_Name = r_QuoteDetails.Product_Name; v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
code I create a workflow that when the decision box "Copy Monday to the Other Days" is clicked it runs the following deluge script: // only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for this). But we also want to push an image from Zoho Inventory to eBay. How? Again, there is a caveat in that the subscription you have or your client has, needs to be Zoho One. Because we're going to use Zoho Creator as a middleware. Just to add to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
mode: add a workflow to the form whenever it is created or edited, on load of the form; I call mine "OnLoad". For Deluge Script, add the following: // // CSS overrides v_CssNotes = ""; // // this line hides the delete/cross icon next to each row...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_Endpoint2 type: POST parameters: m_Params.toString() headers: m_Header connection: "zanalytics" ]; info r_AddRow; } Save Script and Save the workflow Change the field type to image in the ZohoAnalytics report: Go to the Attachments Data Table in Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list). Instead the below script will show you how to use this API having a few email addresses as the recipients: A sample code snippet: For the below, I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
our custom notifications exist // note that installing other apps may create similar webhooks so you need to make sure the script below is looking for your custom webhook for each m_ThisWebhook in r_ShopifyWebhooks.get("webhooks") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_CreateEvent.put("zohosign__ZohoSign_Document",r_ZCrm_ZSDoc.get("id")); m_CreateEvent.put("zohosign__Description","Sent out for signature"); r_CreateEvent = zoho.crm.createRecord("zohosign__ZohoSign_Document_Events",m_CreateEvent); } } // // over to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do that instead. PHP to TXT header('Content-Type: text/plain; charset=utf-8'); header('Content-Disposition: attachment;...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article' Combined with a PHP script this could be a few lines for something really small. The quick trick to this is to do it all in one query: UPDATE table1 SET...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This article is so that I don't spend so long in googling what the TxScript referenced assembly is when creating an SSIS custom component. How? This is simply the "Script Component" under "Extensions". No MSDN website said this... obvious to Microsoft...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
demo a regex and a one liner, here's a typical regular expression (match all characters not from 0 to 9) in a Zoho Deluge script: v_PaymentTermsNumber = v_PaymentTerms.replaceAll("[^0-9]",""); // yields 30 And if working with money/currencies, a one...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF