Assuming text is required, the following 124 results were found.
-
What? This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Install JComments on your upgraded website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4) Copy the below script to a text file Change the database names to match your setup Change the table name prefixes to match your setup Run the modified SQL...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to always try to use the minimal type and length of the value required. For example, a comment of 500 words should only be TEXT (~64Kb) rather than LONGTEXT (~4Gb). Data Type Column Type Range or Description Storage Numeric TinyInt Signed values from...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
all the objects in the same column have the same width: Select all the objects (such as database fields, column header text objects, and summaries or subtotals) in the column by holding down the Shift key while clicking each field, until all the fields...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
in a report row) but I've also used this on the submission of a stateless form, in deluge: v_nTitle = encodeUrl("Test"); v_nText = encodeUrl("Test Content"); openUrl( "#Page:Notify?p_NotifyTitle="+v_nTitle+"&p_NotifyContent="+v_nText+"", "popup window",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use the appointment example mentioned above for a customer in UTC+1 @ 4pm their...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
of the page. End Goes to the bottom of the page. Press Shift and scroll your mousewheel. Scrolls horizontally on the page. Text shortcuts Highlight content, then press Ctrl+C. Copies content to the clipboard. Place your cursor in a text field, then...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
more from Microsoft Office Help /* Count the number of unique number values in cells A2:A10, but do not count blank cells or text values (4) */ =SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1)) /* Count the number of unique text and number values in cells B2:B10...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Build up a SQL query, or more specifically, a COQL - CRM Object Query Language Try using distinct on a single-line text field Adapt the query for unique values in a lookup field I won't demonstrate how to set up a connector as there is plenty of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
- Type: Article
- Category: Static Items
- Language: *
-
not the whole code or a working program but should demonstrate how to include it in your own Autohotkey GUI: ; SET TOOLTIP TEXT SearchButton_TT:="Search" ; SHOW THE GUI Gui, Add, Button, x575 y40 w85 h85 +Default +gSearch +Hide, Search Gui, Add,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Projects (each include all versions per entry) --- Project Name --- Category Name (dropdown of categories) --- License (textarea / option require or not) --- Specify Joomla! Article (for General Description) --- Specify Joomla! Article (for...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This is an article resolving an issue where a template will shrink all the text when in PDF preview. Why? Ok doesn't need a song and dance about it, but I went home yesterday downtrodden by an issue which I'd been working on for most of the day where I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3){cursor:pointer;} Then I formatted the color of the text and set the general text font to be applied overall / included tweak to width so "Wednesday" will not wrap:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
app and Create a form, I'm calling mine Inventory Photo Add 3 fields to this form Zoho Inventory ID which is a single-line/text field Creator File which is a file upload field Public URL which is a URL field Publish it by going to Settings > Publish >...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
is that we want a file to be hosted within Zoho Creator for use by a JS widget that will download the CSV (in this case a Text *.txt) file for use by a dynamic auto-suggester dropdown; one of those fancy ones that includes photos and a bit of fuzzy...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
As documented in an earlier article, put the URL of the image, then change it's format to show the image and not the URL text. In this example, we are using images uploaded in the Zoho Analytics image library but you would need images either uploaded in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
on the situation. This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
using Microsoft.SqlServer.Dts.Runtime.Wrapper; using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through properties using System.Threading; // for threading...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
and branding. Apply to additional components / extensions. Content is King Initial Content All pages initial content (eg. text to go on contact form, welcome text, etc) Any mention of company name or web address to be bolded Images to be used (if not...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *