Assuming following is required, the following 283 results were found.
-
upload photos of the problematic product to the ticket. They then want an Analytics report to show these photos. How? The following is simply the steps to create a data table in ZohoAnalytics, then the code to list a ticket's attachments and push them...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
to connect a JS widget to the data held in Zoho Creator. Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I added all the layers of complexity, I want to have...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Why? This took me the best part of an hour to determine by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{... } isBlank() can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "---------------------- Value of TEST is a BLANK String"; v_Test = "";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
which differs to Zoho Books so when pushing an invoice, there's a strong chance of being a cent/penny off. Let's take the following example of an item with a list price of 12345.545: ZohoCRM Line Item ZohoBooks Line Item How? Here's the immediate...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
display name, description, and set category to "Standalone": I'm calling mine "fn_Deals_RetrievePipeline" Give it the following code: string standalone.fn_Deals_RetrievePipeline(String p_DealID) { /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the comments will also match. If however your article IDs don't match in both versions of your site, consider using the following update script, this will change the IDs of the JComments comments to be associated to articles from your Joomla 2.5 site...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
$this_user_name = $row->username; $this_user_realname = $row->real_name; } Chaining A quick note on how to chain, the following two statements are equivalent: -- note the semi-colons at the end of each line $query->select($db->quoteName(array('user_id',...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Camtasia movie Create a new PHP file in your /extensions/bukb_camtasia_player folder called "BUKB_player.php" with the following code: * @version 1.00 * * Changelog * ========= * * 1.00 - Initial release * */ // Extension credits that show up on...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
the scalar local variables worked I have two parameters that will be submitted (GivenDate and GivenCampus). Consider the following script: -- =============================================================================== -- Description: Gets the room...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
text box in the row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the following: =IIF(RowNumber(Nothing) Mod 2, "#ffffff", "#eeeeee") or =IIF(RowNumber(Nothing) Mod 2, "WhiteSmoke", "Garamond") This is...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
[Room] into "Rows", and [Status] into "Details". 5. Save and close the report wizard Pretty much there you should have the following 6. Preview the report Ta daa! Ok it needs a lot more work in terms of design but the functionality is there. Adding...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
clause. A student always has a "Student Reference" but not necessarily a student AD account (enquired/applied only). So following the above, I end up with: Then I want the ID parameter ("@StudentReference") to populate itself if it is left blank when...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
solution that I initially used but my end-users were asking why is it always 0 seconds. This was because we were using the following MDX statement which had seconds as its smallest denominator: ="Execution Time: " +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a SharePoint 2007 site and we have been asked to migrate links and calendar from an existing system. I was worried when following other instructions because I thought my personal calendar in Outlook 2007 would be completely shared with everyone who had...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
below. If you have never used the system registry before, ask someone who has. Additional (intended for Vista users) The following is an excerpt from http://www.howtogeek.com/howto/windows-vista/dealing-with-windows-vista-time-sync-problems/ Change the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
following describes how to setup a database user with read-only access to the AdventureWorks database. Using SQL Server Management Studio 2008: Connect to your database server. Expand Security > Logins. Right-click on the user who will be set as having...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
below example which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE PROCEDURE [usp_GenerateSearchbySoundexQuery] (...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
With inspiration from: "Obfuscating your SQL Server Data" by John Magnabosco but tweaked for our purposes. NOTE that the following has only ever been run on development environments and I would not recommend running this on a production system as I have...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy a given table into a temporary table all the while maintaining the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *