Assuming based is required, the following 108 results were found.
-
program will confirm that it will begin batch processing, (if more than 20 then it won't list them all), it processes them based on the options you set under "Tools > Options". When it's done it will popup an alert and then try to open the folder...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
"Joel Lipman is a technical consultant working with Ascent Business Solutions, the top Zoho Reseller based in the United Kingdom."); l_Messages.add(m_MessageTraining1); // // this message m_ThisMessage = Map(); m_ThisMessage.put("role", "user");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
instructions on how to get an API key from DHL as a developer and then I'll include the code to query the shipment status based on a tracking number. Becoming a DHL Developer Browse to https://developer.dhl.com/user/register to Signup Complete the form...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works. Why? I've...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
by sending all the data including the custom fields per line items to ZohoAnalytics; and in ZohoAnalytics importing a table based on a query which joins the sales orders and purchase order items by the custom lookup field. What follows is the code...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Here's the code that I added to the workflow for when a performance goal is created or modified (this will upsert it based on the Goal Record ID): // /* ******************************************************************************* Function: String...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
(accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was meant to be based on the pull from invoices article I wrote earlier but with quotes from Xero, things panned out differently: Date/Time values...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
calculated and not blank/null): So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on about "forward dependencies". This is obviously going to error,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
there, here's an overview of some: Method #1 Create one report with all selectable reports as subreports - toggle visibilty based on parameter. Method #2 Add a button below "View Report" linked to some script code (requires change to ASP pages on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
'nchar', 'varchar', 'nvarchar', 'text', 'ntext') ** ** AND TABLE_SCHEMA='dbo' ** ** ** ** - For performance, return results based on string length which is 1 greater or lesser than the original ** ** string value: ** ** Automatic: ** ** @minStringLength...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Failure, Unknown. My images are circles with the background being transparent. I want the first column to display an image based on the status result. If I simply insert an image, the report would use the background color of the report. How? The issue...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Forum Ruleshttps://joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
Members who hack will instantly be permanently banned without any warnings. No Discrimination, - You may not insult members based on their religion, race, sex, political beliefs, or whether they are gay or straight. This is worse than flaming, because...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
if you have AutoHotkey installed, run the Unduplicater.ahk file) FUTURE CONSIDERATIONS: Compare the file sizes and delete based on this Specify to ignore EITHER suffix or prefix SCREENSHOTS: MORE DETAILS AS WELL AS COMMENTS/SUGGESTIONS: You can leave a...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
not a form or report but a page). Why? This is written at a time when Javascript or interactive pages that change on the fly based on a mouse event in Zoho Creator automatically get removed on Save/Update of the page. The following uses the built-in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
focuses on getting the available slots. Why? This is for a Creator app which had a form to allow customers to make a booking based on the configuration and appointments in a ZohoBookings instance. How? The getAvailableSlots function requires as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted to assign the sales person. How? So after an hour or so trying to get the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
A quick 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- 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: *
-
Rule Name can be whatever you want, I'm calling mine "Calls - Send SMS Reminder 1 Hr Before" When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
// // get the xero ID of the record (hexadecimal) v_Xero_ResourceID = r_Event.get("resourceId"); // // do different things based on the category of the update if(r_Event.get("eventCategory").containsIgnoreCase("CONTACT")) { // get contact record from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *