Assuming added is required, the following 114 results were found.
-
m_Delete); } } Update 2025 Having to do this again in 2025 and things seem to have changed. I've added a multi-user lookup on the quotes record called "Requires_Approval_Users". A quick setup method is now to use the CRM interface to add a couple of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy hh:mm a"); // // future proofs v_ExchangeRate = if(v_ExchangeRate == 0,1,v_ExchangeRate); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" (similar to team name) and wanted any Opportunity record to have...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Zoho Creator ones provide. First, let's add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need to be changed as well to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
we're not bother with Daylight Savings Time. The field is a text line field called Customers_Requested_Time and I have added a few more date time fields called GMT_Date_Time_Start, GMT_Date_Time_End, System_Date_Time_Start, System_Date_Time_End,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
stuff. It’s true you need to go through an initial set-up process which essentially boils down to getting your email ID added to the approved list as well as finding out the email address of your Kindle. Once you are done with that, you can send as many...
- Type: Article
- Author: Joel Lipman
- Category: Kindle
- Language: *
-
customer and the problem happened in that the workflow would simply not trigger when the invoice was paid. The customer had added 3 custom fields: Payment Method, Payment Date, and Last Four Digits. They needed these because sometimes their customers...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
here was to figure out how to convert the CRM record into a PDF using a customer's template. // // initialize (this is code added to a button so should alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
ZohoRecruit, it was helpful on the CRM record to see how many candidates had been placed at this particular CRM Account. We added several fields which get populated when a candidate was modified in ZohoRecruit. How? As mentioned, we're going to update...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
r_Data in r_Associated.get("data") { if(!isnull(r_Data.get("id"))) { // // search by record name to see if we've already added this record before // note the endpoint and then the field comparison here v_SearchEndpoint =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
- Matt Wolfe - Install Stable Diffusion Locally. Ok it isn't MidJourney... But it's free. Defaulting some parameters to be added to every prompt /prefer suffix This defaults certain arguments to any prompt you submit. I don't really recommend this...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
Deluge Code So this is a Zoho Creator function that I'm going to call API.fn_ShopifyQuery_UpdateAllProducts() and it will be added to a nightly schedule. It's aim is to recover all the modified records of a day and ensure that the data in Zoho is the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an invokeURL, the key here...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: 21917182) - Modified to check that there are some orders....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"my_creator_connection"); // // SUCCEEDS: with r_Create = {"code":3000,"data":{"ID":"1234567000012345678"},"message":"Data Added Successfully"} Source(s): Zoho Creator / API Status Codes Zoho Community / Zoho One / Using Zoho One Zoho Community / Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
key here is that there were no contact persons on the customer record. Instead, when building 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF