Assuming that is required, the following 494 results were found.
-
files" between two coordinates given the latitude and longitude of each. Why? Well, you can pay for a good Google solution that will distance following roads and the such but.. the following is free albeit as-the-crow flies. This makes use of an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
info v_ExpiryTimeCheck.toTime(); // yields // 25-Mar-2020 20:41:07 // 25-Mar-2020 21:41:07 Setting a TimeZone to a value that is in Zoho date time format - DO NOT USE v_CurrentTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss", "Europe/London");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
error is because the Creator Deluge syntax I was using to insert subform rows was wrong. Contrary to what the documentation that says "This task can be used in the following events", effective as of today October 19, 2020, I have not found a place you...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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 ID. What I want...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and someone may want to open this in Google...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to the Sales Order in CRM. As my client's sales team would only create sales orders in CRM and don't use the invoice module (that's for their finance team using ZohoBooks), we disabled the CRM Invoice module. How? Therein lies the reason. For the quote...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
The issue here is if you want to do something when a user resizes your program. If you search and search, you'll find that GuiClose responds to when you close the app, and GuiSize will run when you resize the app. Syntax: GuiSize: GuiControl, MoveDraw,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID numbers....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
confuses me now and again. So I'm writing this to remind me and to keep reminding me of how to do this. Why? My use-case is that I have a photo in Zoho Creator but the source doesn't really matter as the part I struggled on was uploading it to CRM. I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
a distinct list variable... But what if there are 20000+ records? The advantage of working in a team of Zoho developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
We're going to parse the created date and time parts as well as the timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
The form I have looks something like the following: and displays as something like this: The 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently logging time in our CRM. We're meant to do 40 hours, not just for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_Page, 200, m_SearchParam); // // loop through search results for each r_Result in l_SearchResults { // check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record......
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
here's an article on creating a Meeting or an Event using Zoho Deluge. Why? Because at time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Note that for the below code, only 1 image is accepted at the moment, and the endpoint will depend on your datacenter (eg. COM or EU), and lastly the connection "joel_books" is my connection to ZohoBooks: // // declare ID of item in Zoho Inventory...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
false; Caveat(s) This only happens if the record is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. user clicked on field in view mode and edited just one field). The only other event you can use this in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *