Assuming additional is required, the following 125 results were found.
-
to add in this custom field per line item, but also requires a change to the other fields in the line item. There is an additional note that when using v2.1, you no longer post to the "Product_Details" key but to the respective module line item API name...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Question 0191 ª Feminine Ordinal 0170 º Masculine Ordinal 0186 « Left angle quote 0171 » Right angle quote 0187 Additional "Alt Codes" can also be used in HTML. For example the British Pound sign (£) can be typed by holding the ALT key and entering...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Billing_Address.country=v_AddressCountry Line_Items=c_LineItems ]; From the documentation Additional Note that any bidirectional relation field that exists will be prepopulated using the method above. Clear subform of all its rows: input..clear();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= input.Account.toLong(); } else { //... code to create new record r_NewRecord = insert into [ = = = ]; } Done: Additional Remember that an integration field on the interface is returned as a string and needs to be converted to a number to be assigned,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
r_Contact.get("id").toLong(), m_UpdateContact); } return "Deleted " + v_CountDeleted + " of " + v_Count; Additional Notes As a preliminary measure, I deactivate any workflows in CRM that this process would affect. In the example above, all workflows...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ v_SalesPersonID = r_SalesPerson.get("salesperson_id"); break; } } m_CreateSO.put("salesperson_id",v_SalesPersonID); } Additional Note(s): Scope(s) required: for the connection I think it was ZohoBooks.settings.READ for the sales persons and then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
********************* 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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: Zoho
- 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
- Language: *
-
ZohoCRM: Import Attachmentshttps://joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html
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
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF