Assuming value is required, the following 196 results were found.
-
been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have thought of an alternative that I now use frequently in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
code snippet will get the Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), and updates the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
each v_TimeZoneOption in l_TimeZoneOptions { v_TimeZone = v_TimeZoneOption.replaceAll("",""); // replace any commas in the value (for list conversion later on) v_TimeZone = v_TimeZone.replaceAll(","," ", true); info v_TimeZone;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want to add 10 minutes to a date/time field in ZohoCRM and wanted a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in (ZohoCreator > Settings > Date and Time Settings); so as soon as you try to insert a date time and perhaps accompany that value with a timezone, several calculations happen in real-time making it really difficult to extract and use. The key trick I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
URL as the REST API Function you noted above: Copy the Webhooks key on the Xero page into your CRM function replacing the value in Line 2 of my code snippet above. > Save the CRM function. Click on "Save" on the Xero page Click on "Send 'Intent to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"$1", false); // yields 12.3 // same expression again but with a different value v_Test2 = 12.000; info v_Test2.toString().replaceAll("(\\.\\d*?[1-9])0+$", "$1", false); // yields 12.000 So this isn't quite right, so let's get a regex that rounds...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ if(!isnull(r_User.get("profile"))) { v_UserProfile = r_User.get("profile").get("name"); break; } } } } // // get field value that we want to check for v_LeadStatus = ""; if(!isnull(m_Webhook.get("record"))) { // // extract lead status v_LeadStatus =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
details and scope. Error(s) Encountered: {"code":"4401","message":"Unable to populate data, please check if mandatory value is entered correctly."}: Check your connection string. {"code":"9832","message":"Mandatory parameter(s) missing"}: Not sure why...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of options, eg. "portrait". Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against this custom parameter then press So to use...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
you go or pay as you use. Previous Models/Versions Based on the documentation: In the above code, you would change the model value to one of the following code-davinci-002 (optimized for code-completion tasks) text-davinci-002 text-davinci-003...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Deluge. If this works, we can increase the number of pages as well as the number of products per page: The GraphQL The key value to retrieve is "cursor"; we're also going to use "hasNextPage" to determine if we need to keep looping: {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ ") for more info."; } Previous Models/Versions Based on the documentation: In the above code, you would change the model value to one of the following code-davinci-002 (optimized for code-completion tasks) text-davinci-002 text-davinci-003...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
can only use this in another dataset which won't use a sub-query more than 2 levels deep. We're only displaying the maximum value alphabetically found in member status per contact per campaign (should be only 1?)
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
} c_Employee.Usual_Shift.insert(c_UsualShift); info "-------------"; } Yields something like: Error(s) Encountered Value is empty and '1234567000001234567' function cannot be applied: Possibly due to me trying to create and declare the subform before...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the year the week is in. Weeks which overlap at the end/start of the year need to be observed. As per the documentation: dateValue = '29-Dec-2019'; info dateValue.toString("yyyy"); // returns 2019 dateValue = '29-Dec-2019'; info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then statements, I can feed these maps a textual value and it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"Edit Arguments" and give it the same function name as method name, then I click under "Name" and enter p_TicketID with the value "Ticket Id" and click on "Done" Then I give it the following code: /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= if(c_Quote.Unit_Price && c_Quote.Unit_Price > 0,v_CurrencyHtmlEntity + c_Quote.Unit_Price.round(2),"-"); v_PriceValue = if(c_Quote.Unit_Price && c_Quote.Unit_Price > 0,c_Quote.Unit_Price,0); v_PriceTotal = v_PriceValue * v_ThisQuantity; v_TotalPrice =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF