Assuming will is required, the following 359 results were found.
-
doing it on a CRM workflow (save of record) but here we're going to do it in client script: Additionally, the line items will be sourced from the quote that was converted to the invoice. For this to work, we've mapped a field on the invoice (not a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
we deal with in our Zoho CRM. I want our sales team to be able to click on a button off the CRM account record which will call an API returning all the credit information about a company. Unfortunately, if you do this simply using Zoho Deluge in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
fields/columns added to it. Turns out, it's a system report you can't change. Enter Zoho Analytics... well almost, Analytics will sync with Zoho People but I wasn't able to select the performance modules (Client Review and Placement Tech Survey having...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
but the more basic the receiving data the better. In my example, I'm returning some HTML but for security and stability, you will want this to use an XML file depending on the level of detail you want back. The biggy The following code is basically the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
pressing the word GO handled = true; } return handled; } }); Other Noteworthy Actions android:inputType In some cases, this will change the keyboard layout (eg. Numbers) text // Normal text textNoSuggestions // No suggestions/autocorrect...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
+ "-" + SUBSTRING(Date,3,2) + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833)...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
but it still didn't work for me. But the idea of inserting a NULL entry to select sounded good. Aim / Objective The plan will be to replace the default "" with a custom null entry and the end-user will be none the wiser. OLD: Dataset to populate the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
shared with everyone who had access to the SharePoint site... It doesn't. The following steps show you how SharePoint will open a shared calendar if you don't already have it in your Outlook 2007. Similar to you opening a shared calendar, the sharepoint...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you refresh the data, it will retain the carriage return in the column headings. Additional: Only appears obvious in SQL Server Management Studio...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
other alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: ....
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
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] ( @p_SearchString VARCHAR(max),...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Name (should be system name followed by Live/Test/Dev for reference) Description can be some long winded text that very few will ever use TCP/IP Server is the server name (without the DNS suffix) or the IP address of the server Port should be 3306 by...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
incomplete! Will post a final solution but here are the basics What? This article is a quick note to myself on the idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press F5 to run the code. This will prompt you twice: It is prompting you for the range of all the data to apply this to (eg. $A1:$W36000). You are then prompted for the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
can be accessed if people work out the link. "Stealth" mode is only available in the most expensive subscription plan. NSFW will likely be blocked. Installing Stable Diffusion on a local server is the recommended stealth mode. Check out Matt Wolfe's...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
which lists all the Google Chrome Profiles on your Windows 10 workstation in alphabetical order. Why? This program will be redundant if Google ever update their Chrome browser to list the multiple profiles in alphabetical order like it used to be... but...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
files which are simply the converted versions of music or video files, then this tool asks which folder has the files it will keep and which ones it will send to the Recycle Bin. TESTED ON: - Windows XP, Windows 7 SCREENSHOTS: LICENSE: These scripts are...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *