Posts

Filling the G-Apps: Vertical Text in Google Spreadsheet

Vertical text in Google Drive is not something that exists yet however you can do within it's standard formatting however you can produce the same effect using a calculation where " LABEL " is the text you want displayed vertically: =ARRAYFORMULA(CONCATENATE((MID( " LABEL ", ROW(INDIRECT("YY1:YY"&LEN( " LABEL " ))), 1)&CHAR(10))))

Basic Web Browser Tips

Web browsers have all been redesigned in the last couple of years to allow you to view multiple websites within one browser window. Below is a small list of the most commonly used shortcuts that you might not already know about: ● Ctrl+Tab: Switch between your open tabs ● Ctrl+Shift+Tab: Reverse switch between your open tabs ● Ctrl+Click: Opens a link in a new tab ● Shift+Click: Opens a link in a new window ● Ctrl+T - Opens a new browsing tab ● Ctrl+Shift+T - Closed a browser tab by accident? No problems, this will bring it back

Filling the G-Apps: Domains

In Google Apps for Business Gmail you have 2 options for applying domains but they have their own restrictions. Add-on Domain Will give you the ability to add any email address from an applied domain to a user but we need to manually add each email address to each user. It also means that Google Apps can be accessed using these domains as well i.e. https://mail.google.com/a/companydomain.com. The only drawback is that you need to manually add the domain as you add each User or Group. Alias Domain Automatically adds the email address to every user & group in the organisation but you can't use the domain for any address other than the user name i.e. useralias@companydomain.com rather than user@companydomain.com or request@companydomain.com.

Giving Access the the Windows Fonts Folder on a Network

To give network users access to be able to add fonts the Fonts folder you'll need to complete the following processes: UAC (User Accounts Control) security will need to be reduced or disabled: Go to Control Panel and select  "User Accounts" Change "User Account Control Settings" Select “Never Notify” Give the user access to the font directory and modify the registry key permissions: Directory: Open the command prompt using Administrator Privileges (right click cmd, “run as administrator”) Type and enter "attrib –r –s c:\windows\fonts" (this will allow you to complete the next step) Open Windows File Explorer, right click on the fonts folder and choose "Properties" Click the "Security" tab Click "Advanced" Click the "Owner" tab Click the "Edit" button Change the "Current Owner" to yourself Check the "Replace owner on subcontainers and objects" box Click "OK...

Filling the G-Apps: Google Drive Sync

Google Drive Sync whilst being a useful tool is not yet developed to an enterprise level. NB: Whilst the above statement is also true of Google Drive the following points are only about Google Drive Sync: ● There are currently no management tools available ● It is not supported when installed on a server ● Scope and granular functionality don't exist beyond what a basic user can see ● The local synchronisation service whilst it seems fairly reliable and it doesn't quite interfear with resources as much as something like Dropbox. It's not extremely fast, it's not a snail's pace but if you have 30+ users all working on non Google Docs documents they might not all be synchronised in a reasonable time ● Unidirectional synchronisation settings. While any files you place under the root folder will synchronise from a local computer up you can't tell it what not to synchronise at the secondary folder level or any subsequent folders ● There is no connec...

Filling the G-Apps: Chrome/Gmail Crash

A more common issue with Chrome & Google Apps these days is an DNS caching issue. If you're using the simple but useful "Stay Signed in" checkbox and there's an issue with your connection or your IP address is changed you could come across the Chrome/Google Apps equivalent of the "Blue Screen of Death", nowhere as bad and simple to fix. You'll be faced with a white screen with the appropriate Google Apps icon & the text "The app is currently unreachable". To resolve the issue you just need to clear your DNS by completing the following steps: Open your command line I.e. Dos prompt (On Windows PC , press Windows +  R > type "cmd" > click Ok)  On Command Promt type "ipconfig /release" Then type  "ipconfig /flushdns" Then type "ipconfig /renew" Similar details for the Tasks Chrome Extension can be found here . Another solution that works when it's just a locked sessio...

Filling the G-Apps: Attaching an Gmail Email

Sending an email as an attachment isn't something that's not native to Google Apps but there are a couple of methods that can get the job done depending on what you're trying to achieve. A) To attach an unrelated message as an email file you can do the following: Open the email you would like to attach Open the menu on the right and select "Show Original" - (It will open a new window with the message in plain text) In your browser, select "Save As" and use the .eml extension. NB: This will create a message that all mail clients (Outlook, Live Mail, Thunderbird...) can open, and it will include all original headers. Then upload that .eml file as an attachment to the message you're sending. B)  Attach as a Google Drive HTML file: Open the email you would like to turn into an attachment. Click the drop-down  next to ‘Reply’ in the top-right corner of your message. Select ‘Print’. On the left-hand side of the print screen, click ...