Monday, 19 February 2018

GSuite Filling the G-Apps: Forms, Contact Numbers and Regular Expressions

GSuite Forms added their regular expression functionality a while ago but finding the correct combination for your scenario online can be cumbersome if you're not heavily into a language that makes use of regular expressions in it' entirety and Google doesn't seem to provide relevant samples probably because the combinations can be vast and "why don't you just Google it?".

Below are some details I found useful for enforcing correct number formatting when entering details in some Google Forms I've had to create:

BSB

^\d{3}-\d{3}?\$
This uses a strict (3-3) format i.e. ###-###

TFN

Australian Tax File Numbers are  9 digits in the format of (3-3-3)
^(\([0-9]{3}\)|[0-9]{3}-)[0-9]{3}-[0-9]{3}|(\([0-9]{3}\)|[0-9]{3} )[0-9]{3} [0-9]{3}|(\([0-9]{3}\)|[0-9]{3})[0-9]{3}[0-9]{3}\$

ABN

Australian Business Numbers can have a number of variations so this isn't a foolproof solution but should  generally work for an 11 digit combination with varying spacing combinations or none at all
^(\d *?){11}\$

Mobile

^(\([0-9]{3}\)|[0-9]{4}-)[0-9]{3}-[0-9]{3}|(\([0-9]{3}\)|[0-9]{4} )[0-9]{3} [0-9]{3}|(\([0-9]{3}\)|[0-9]{4})[0-9]{3}[0-9]{3}\$
Using (4-3-3) with either spaces or dashes i.e. #### ### ### or ####-###-###
^(?:\+?61|0)4 ?(?:(?:[01] ?[0-9]|2 ?[0-57-9]|3 ?[1-9]|4 ?[7-9]|5 ?[018]) ?[0-9]|3 ?0 ?[0-5])(?: ?[0-9]){5}\$
As above but including +61 and limiting to current carrier prefixes

Australian Landline or Mobile (Including Area Code)

^\(?(?:\+?61|0)(?:(?:2\)?[ -]?(?:3[ -]?[38]|[46-9][ -]?[0-9]|5[ -]?[0-35-9])|3\)?(?:4[ -]?[0-57-9]|[57-9][ -]?[0-9]|6[ -]?[1-67])|7\)?[ -]?(?:[2-4][ -]?[0-9]|5[ -]?[2-7]|7[ -]?6)|8\)?[ -]?(?:5[ -]?[1-4]|6[ -]?[0-8]|[7-9][ -]?[0-9]))(?:[ -]?[0-9]){6}|4\)?[ -]?(?:(?:[01][ -]?[0-9]|2[ -]?[0-57-9]|3[ -]?[1-9]|4[ -]?[7-9]|5[ -]?[018])[ -]?[0-9]|3[ -]?0[ -]?[0-5])(?:[ -]?[0-9]){5})\$
Please enter a mobile or landline (area code required) in any of the following formats:
• ## #### ####
• ## ####-####
• ##########
• (##)########
• (##) #### ####
• +61# #### ####
• +61 # #### ####
• +61#########
• #### ### ###
• ####-###-###

Thursday, 30 November 2017

GSuite ISSUE - map New Sites with a secondary domain

The ability to map a public domain to a secondary site is not currently functioning or available in GSuite Sites.

The functionality looks like it's there but when you try to add a new mapping in the Admin Console it comes up with an error which makes sense in that it's crossing domains:

You can select the added secondary domain which processes without an issue:

The issue is no sites can exist under this domain. You can assign users to the domain by changing their login credentials to the secondary domain (using the rename option) however all GSuite Sites (New) are created under the primary domain and there is currently no option available to facilitate this.

Thursday, 6 April 2017

Chrome Browser Auto Opening Documents

A couple of times I've had users ask how to stop files/documents automatically opening once they download them using the Chrome browser.

It can be rather frustrating for the end user, however it's quite easy to rectify.

You can follow these steps below:

1. Select the "Chrome Settings"/burger menu button in Chrome > "Settings"
2. Scroll to the very bottom of the screen or press "Ctrl" + "End" and select "Advanced Settings"
or click on the link below:
1. Finally in the "Downloads" section click on the "Clear auto-opening settings" button:

Wednesday, 15 March 2017

Windows Restart or Shut Down a Remote Computer

Please note both these procedures require an Administrator group level access, or equivalent, on the remote computer.

Using a Windows Interface

To restart or shutdown a remote computer and document the reason in the log files using the Windows interface you will need to do the following:
1. Open the Command Prompt window by pressing "Windows" + "R" and type "CMD" and hit "Enter"/"OK"
2. Type "shutdown /i" to display the Remote Shutdown dialog box (the Shutdown.exe file found in the Windows directory)
3. Click the "Add" button to enter the associated computer names you wish to shutdown/restart or click "Browse" to open the "Find Computers" dialog box
4. Under "What do you want these computers to do", click "Restart" or "Shut down" and options for warning any logged in users.
5. Select an appropriate reason for the restart or shutdown from the list and enter in any details to be logged in the "Shutdown Event Tracker" section

Using the Command Prompt

To restart or shut down a remote computer and document the reason using the command line
you will need to follow the process below (Win7):

1. Select the "Start" button
2. Click "All Programs"
3. Next select "Accessories"
4. Click "Command Prompt"
5. Type the following into the command line:
• shutdown /[r|s] /m \\ComputerName /c "Comment" /d [u|p] <xx>:<yy>
• /r        = Shutdown and restart the computer
• /s        = Shutdown the computer
• /m       = Specify the target computer
• /c        = Comment on the reason for the restart or shutdown.(512 characters max)
• /d        = [p|u:] xx:yy  Provide the reason for the restart or shutdown.
• p = Indicates that the restart or shutdown is planned
• u = Indicates that the reason is user defined
• If neither p nor u is specified the restart or shutdown is unplanned
• xx is the major reason number (positive integer less than 256)
• yy is the minor reason number (positive integer less than 65536)
• System Shutdown Reason Codes
6. and then press ENTER

Tuesday, 14 March 2017

Filling the G-Apps: Drive Moving Files - The Starring Method

In a any business you’ll end up with a job reference or numbering convention and a folder structure as the business grows. This can get more and more difficult to search through when moving documents around in Google Drive as there is currently no function to search after you select "Move to".
A simple solution to this process is to use the star function in Drive or searching via the naming convention.

Both methods work effectively but depending the situation one will be more efficient than the other.

The Starring Method

1. First select the item or items you want to move into the folder
2. Next search for the folder you want to move the items into, select the folder and star it as well,
3. Next select “Starred” in the sidebar and highlight the items you want to move and drag them into the folder
4. You can check their location in the details sidebar
5. Unstar all the items once you’ve finished

The Search Method

Please note this only works if you’re using a naming convention or a common thread in the items.
1. In the situation where you’re using job numbering across files and folders you can use the search bar and enter the job number or common details into the “Item Name” field and search
2. From the results you can move the items into the folder
3. If required you can use a combination of this search and the starred method from here to narrow down the results as well and selecting the “Starred’ checkbox

Friday, 3 March 2017

Filling the G-Apps: GSuite Onboards Google Keep

If you haven't noticed Google Keep is now integrated into the GSuite products:
You can get to Keep under the Tools section of each of GSuite's core products:

It will show up as a side panel like this:

If you have the GSuite Training Extension enabled you can find Google Keep training available here:

Thursday, 9 June 2016

Filling the G-Apps: Desktop Chrome App Launcher Not working

This was one of my many draft posts waiting to see daylight (this one's about two years old) and unfortunately it looks like the Desktop Extension might be depreciated at some point.

The version I'm talking about is the original App Launcher from Google that resides on your desktop Taskbar not in the Chrome browser:

Back to the issue:

If at some point you get an error that stops your Chrome App Launcher from launching and instead launches a standard window you should just need to correct the link so that the App Launcher works again. This can be done by completing the following steps:
1. Locate the shortcut that's not working, whether it's on your desktop, Quick Launch Toolbar or Start Menu.
2. Right click the shortcut and go to "Properties"
3. In the "Target" box go to the very end of the path and type " --show-app-list" i.e. it should look something like this:  "C:\Users\username\AppData\Local\Google\Chrome\Application\chrome.exe --show-app-list"