Assuming from is required, the following 419 results were found.
-
albeit as-the-crow flies. This makes use of an undocumented function in Zoho which is acos or inverse cosine. Just lifted from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested in Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for a code or use the below to generate one. Code Here you will need your own client ID and client secret generated from the developer console in the following snippet: v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234"; v_ClientSecret =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
and type: shell:appsfolder This will open your applications in explorer (much like MacOS). You can then create shortcuts from these and more importantly see the command to open them. Note that the MS Windows 10 Mail shortcut will be something like...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
first day of the month and then loop until we find a Monday. Same for the last Tuesday except that we will count backwards from the end of the month: if(input.Switch_Over_Day=="First Monday of Month") { v_NextMonthDate = zoho.currentdate.addMonth(1);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
in left side of a Criteria". There used to be an old solution for doing this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of an access token used in OAuth2.0 for an API. How? All with deluge but we will split the date and time value obtained from a CRM field and compare it to the current time combined with a timezone. In this particular case, we will switch the current...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for each r_UserDetails in l_MatchingUsers { info r_UserDetails.get("id"); } List CRM Users (ActiveUsers) from Creator or other Zoho App Note the use of .toMap() required for other apps to read this JSON string response: l_Users= List(); m_UserType =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= r_NewSoDetails.get("salesorder_id"); v_NewRefNum = r_NewSoDetails.get("salesorder_number"); // // build up a reference map from the line items of the newly created sales order m_NewLineItems = Map(); for each r_NewLineItem in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A_LoopFileName, "." A_LoopFileExt, "") a_ThisFileName := StrSplit( v_ThisFileName, A_Space, ".") ; remove converter comments from file name v_NewName := "" Loop % a_ThisFileName.MaxIndex() { v_FoundUnderScore := InStr( a_ThisFileName[A_Index], "_") if(...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
to the setting itself, just displays it to the user for them to make the choice. Why? I needed a command that can be run from the command-line in an AutoHotkey app to open the notifications page of the Windows 10 Settings panel to allow users to...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product line item list. If I run...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and paste into a Zoho Creator Page. Be sure to copy the code directly into a page and NOT to be in a function that is called from the Zoho Creator page. Functions are read by Zoho and certain CSS attributes (such as position and float) will be removed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name, and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// field we want to sort by v_SortingKey = ifnull(r_Record.get("date"),""); if(!isNull(v_SortingKey)) { // as this is a date from CRM (atomic date format), arrange so it can be sorted alphabetically in reverse order v_DatePart =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
characters not found on your keyboard or on a Qwerty UK/US keyboard layout. Why? Being able to type international characters from other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
like myself can misread the documentation. This particular article shows you how to customize the search results or response from using zoho.creator.getRecordById(). Why? My use case scenario is that I was trying to build a related list in Zoho CRM with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
permission to access the Quote Conversion Mapping page... Why? I wanted to map a billing street 2 and shipping street 2 from the Account module to the Quote module, then on convert, to map these to the Sales Order in CRM. As my client's sales team would...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// v_AddressIndex = 0; m_ShippingAddress = Map(); // set field api names that we will read from and write to l_CrmShippingAddress = {"Shipping_Street","Shipping_Street_2","Shipping_City","Shipping_State","Shipping_Code","Shipping_Country"};...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"UNKNOWN"); m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id")); // // getting the last ID from the Shopify sort instead of making Zoho sort a list v_LastID = r_ShopifyProduct.get("id"); } } } // // output info m_Sku_IDs; info m_Sku_IDs.size(); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF