Assuming could is required, the following 151 results were found.
-
is changed to remove every instance of the "distinct" list, then I'll have to come up with a different solution. Maybe Zoho could introduce a removeFirst() if they change removeAll().. The number of duplicates may easily differ to the loop of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ v_PublishKey + "?filepath=/" + v_DocFileName; // // Store the link to the local file as the local image - this is where we could check on file extension and substitute with PDF, DOC, XLS extensions c_Document.Local_Image = ""; info "File: " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
use by a dynamic auto-suggester dropdown; one of those fancy ones that includes photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but as I'm not downloading it, this is apparently not the process. How? As a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
sales order is created to do some further calculations based on a surcharge rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code is sitting right now. The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
so."Sales order ID" LEFT JOIN "Sales Order Items" soi ON so."Sales order ID" = soi."Sales order ID" Initially we thought we could take the purchase order by simply going through the comments but this only shows Purchase Orders raised from a Sales Order...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
browser tab if using Google Chrome and select "Duplicate"). I then arranged the two browser windows side-by-side so that I could copy the image address from the library to the 2nd column in my data table. So in the duplicate browser, go to modify a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click on one to select it. When are colors used? Well in this use-case, we are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
*/ // // initialize v_AccountID = ""; v_Output = "Error: Could not retrieve given CRM Account ID"; // // ****************************** GENERIC CODE BELOW ****************************** // // retrieving the parameters of the request m_RequestParams =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
An article on some Zoho ANSI-SQL (in other words, queries that work in Zoho Analytics) as I couldn't find any examples online on how to do this. Why? I've been tasked with generating a radar/spider/web chart based on the results from a survey....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
one documents a pull and mapping into CRM invoices. Why? This took me a whole afternoon so I wanted a template function I could use in future when I get this request again. The additional benefit of having this template is that it includes creating...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// What I want www.joellipman.com/category-alias/article-alias.html How? You could buy an SEF extension that does this for you or spend time tweaking your .htaccess file. Or you can take advantage of a Joomla update and do this without any coding......
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to find ALL articles I noticed that if I search for some of my articles, they weren't appearing in the smart search but I could see them in the category blogs. Login to Administrator > Components > Smart Search > Index Click on the "Index" button in the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
prompt: rephrase the following so that it makes sense to a trainee: "" // wait for completion and if paragraph is ok Could you do the same with the attached please? Feel free to include details of what you know of [Video Topic]. Give the transcript to...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
from another location. This wasn't the issue, once I had the right SHA1 registered in the Google APIs console other users could download the file from my website and see the maps. I'm not saying it won't fix a problem for you, just that downloading from...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a proof of concept, I created one lookup task that executes a SQL query...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Dunno about you guys but I've searched the WWW for a solution and couldn't find it. The work around I've documented is a "solution" to my situation and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
have problems because when there are no matching rows (so zero results), BIDS doesn't seem to know what to do with this. We could add a row with a SELECT UNION statement but I found this can be resolved by adding a counter, so the above becomes: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
hour or so I came across "Cascading Parameters" (http://technet.microsoft.com/en-us/library/dd255197.aspx). Maybe the answer could be in that mess of a Microsoft article but this I can already do and it didn't quite do what I wanted. I ran out of time...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB