We help IT Professionals succeed at work.

Google Apps

Google Apps is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Apps for Work adds business-specific features such as custom email addresses at your domain and storage for documents and email.

To whom it may concern

I have a client that uses Google Apps for their e-mails and reads their e-mails in outlook client.  Version of Outlook 2019 that the user uses.  
Details of Laptop:
Windows 10 1803 Build 17134.677
Intel Core i-5-2450M CPU @ 2.5GHz
4GB Ram
Office 2019 Home & Business
Outlook version - 2019 MSO 6.0.11328.20220 32-bit

So basically I have setup the user's primary e-mail account (trevor@drivesouthafrica.co.za) with Google Apps Sync for Microsoft Outlook (GASMSO) and syncs the account perfectly with outlook.  Now the user has 2 more google app sync accounts that has been delegated to him namely (infodrivesa@discoverafricagroup.com and pay@discoverafricagroup.com)  These account also need to be added to Microsoft Outlook and the user need to be able to send and receive from these 2 accounts.  How do I go about to add it to the same profile?  When I try to add the acccount, GASMO adds it as a seperate profile, so you have to switch profile to get to the e-mails.  The user has a desktop machine that has the outlook setup already in place and working, so it is possible, but just do not know how to setup multiple GASMSO accounts to the same profile.

Any assistance will be greatly appreciated.

Kind Regards

Now that I've backed up all my Google+ "stuff", with Google+ closing, how do I access the data I've downloaded? Most important are e-mails(I have a standard Gmail account, although I pay for extra storage).

Of top interest to me are Gmail, Youtube, and Google Drive. Takeout also backed up Google Play Store, where a I have a couple of purchases. Is Play Store going away too?

What Google+ support pages relating to this do you think are a priority to read? Since it is closing tomorrow, I'm giving this question highest priority.
I have some code that uses javascript and plots multiple markers in a map.

Here is the code:

<!DOCTYPE html>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> 
  <title>Google Maps Multiple Markers</title> 
  <script src="http://maps.google.com/maps/api/js?sensor=false" 
  <div id="map" style="width: 500px; height: 400px;"></div>

  <script type="text/javascript">
    var locations = [
      ['Bondi Beach', -33.890542, 151.274856, 4],
      ['Coogee Beach', -33.923036, 151.259052, 5],
      ['Cronulla Beach', -34.028249, 151.157507, 3],
      ['Manly Beach', -33.80010128657071, 151.28747820854187, 2],
      ['Maroubra Beach', -33.950198, 151.259302, 1]

    var map = new google.maps.Map(document.getElementById('map'), {
      zoom: 10,
      center: new google.maps.LatLng(-33.92, 151.25),
      mapTypeId: google.maps.MapTypeId.ROADMAP

    var infowindow = new google.maps.InfoWindow();

    var marker, i;

    for (i = 0; i < locations.length; i++) {  
      marker = new google.maps.Marker({
        position: new google.maps.LatLng(locations[i][1], locations[i][2]),
        map: map

      google.maps.event.addListener(marker, 'click', (function(marker, i) {
        return function() {
          infowindow.open(map, marker);
      })(marker, i));

Open in new window

This work first but I want to add a timer that plots another marker with my current location that replaces the center location here:

var map = new google.maps.Map(document.getElementById('map'), {
  zoom: 10,
  center: new google.maps.LatLng(-33.92, 151.25),
  mapTypeId: google.maps.MapTypeId.ROADMAP

Open in new window

How can I do this or plot a pointer in of me current location in this map?
The problem:
I need to go to corporate websites to collect location information for all offices, branches or facilities. We want to be able to search a website of a large international bank, national restaurant chain, network of hospitals or multi-national conglomerate of manufacturing facilities and collect relevant information like Address Location Phone etc. For the purposes of plotting the branches offices restaurants or facilities on a map utilizing geo-coding and logistics. For instance, some of the banks, retail stores and or restaurants under their find a store locator or store locations area on many websites. Example https://www.lowes.com/

Data webpage I need address locations from to be scrapped
 As you can see from the store locator on the above website. It launches a small window of local store close to me. However, I am hoping to get a list of all stores either by state or across America. I am aware of the Google Sheets that uses there Import HTML or Import XML code function to do this.  I think Excel has a similar function as well. At the moment I cannot find examples or steps for what I am hoping to do. Wondered if any of you out there knew what tool I could use and how I might go about it?
hi team ,

i would like to know , if there is a way in google sheets . i can use form based entry and the data gets stored in google sheets table . And to retrieve specific info , can i use query in menu type format .
Eg : Name , Age i enter in form based ( menu based) and query ( menu based) i will look for specific category .
Is there a way to set the gmail auto filter rule to select a particular type of starring rather than just the general yellow star?
Hello, we have hosted Exchange from Intermedia and we want to migrate Google Apps for Business. Is there a good migration software that makes this painless?
A customer is trying to install the Google G Suite Migration on a Windows 10 Home computer with Outlook 2016.  The installation aborts with the errors shown in the attached log file.  The error file points to a problem with language but all settings in Outlook and the computer show English or English-US.

We have tried running as Administrator but cannot get past the errors shown in the logfile.

Our customer tried the install and is turning to us for assistance in resolving the install problem.  We may have to contact the customer if your reply requires additional information.

Any assistance or suggestion will be appreciated.
I wish to enable Device Management, in our G-Suite, only for enrolled Chromebooks. They are in a single OU.

I do not wish Basic Mobile Management activated for personal devices that have a G-Suite account on them.

Is this possible?

Many thanks
Good Day!      
Google Sheets for me is like Excel is an Old Dog to a New Trick!

I have two simple google Sheets for a sign inventory and posting log of rental property signs. No matter what I try I get errors or NA's!

I want the Residential sheet "Posted" column to update by the "Action" column in the Sign-Log sheet.
VLookup is the Sign # column, but because inventory tags use leading zero's it is a Text field. The Sign-Log is sorted by Date or Action, so the Sign #s are not consecutive.
Any help much appreciated.

Tried this in Cell C4 of Residential Sheet in various versions getting Error or N/A's each time.

Open in new window

In  Residential sheet "C2" cell I run this in the posted "C" column for "Posted" signs, which works once I get the lookup working.
 =COUNTIFS($C$4:$C50,"Posted",$C4:$C50,"<> "

Open in new window


In each case I'd like the Range to be dynamic as I add or delete signs. I don't know how to assign variable ranges in Sheets as I would in Excel.

Residential Sheet
Clip of Google Sheet of Residential inventory sheet (partial)
Sign-Log Sheet
Clip of google Sheet of Sign Log sheet
Deleting videos from YouTube?

Is there a way to delete videos from YouTube?

And is there a way to delete a YouTube channel?

If so, how?

Searching for publisher files using *.pub from the root of about 10 google drive folders on my hard drive does not appear to be working.

Do I need to change the default indexing settings somewhere or do something special since they are google drive folders?

I am on a Windows 10 Microsoft Surface 4 Pro.

Thank you for any assistance that you can provide on this.
G-Suite- (their forums suck by the way.  Heck, the whole product sucks, but what do you do) I'm having some problems with G-Suite.

The owner calls me and says, hey, you know how I get a copy of ALL emails sent to and from the org, well, our sales manager gets ALL emails sent to and from the sales people too.  

We fired one guy and disabled his g-suite account.  His email was one of the emails going to the sales mgr.  When we disabled his account, she stopped getting copies of everything sent to and from his account.  Of course this would happen of we disabled his account.

However, when we re-enabled it, and mail began to flow in, she didn't get those like she once did.

That's when I got the call that the owner gets a copy of all sent/received email within the org and that the sales mgr gets a copy of all sent/received mail from the sales team.

So, I'm trying to find that.  I'm trying to find in the g-suite admin tool WHERE I would configure that.  I'm thinking transport rules, but there is nothing there when I look.

Anyone have any idea where to look?  Individual user accounts?

It still seems to be exceptionally challenging to

1. Get the images on my phone to sync correctly with Google Photos.
2. Place them in the correct online Albums.
3. Be able to retrieve them from the albums they are in.

The biggest challenge seems to be number three (3). When I go to add a photo that I know is in an album at photos.google.com, I can't even see the album to select from.

Any assistance that you can provide in shedding some light on these issues is greatly appreciated.
Is there a way to make it so these two icons are not right next to each other?  I've mistakenly clicked something as spam a few times, instead of archive, and I'd like to not do that anymore.


I need to insert an accent in Google Docs. I used the internet but did not find any reliable source to help.
I'm running in to some difficulty loading an HTML file into a DIV using JQuery 3.x's load() method:


Although I am successfully able to load and display the HTML file, .. I am getting JavaScript errors, which I'd like to eliminate/suppress.

I have this very simple JS function to trigger the loading of the HTML file:

function loadGoogleMapView(pageurl) {

Open in new window

.. and then I am calling the method by passing the HTML filename to it:

<a href="#" onclick="loadGoogleMapView('map-view.html');">View Map</a>

Open in new window

The contents of the HTML file that I'm trying to load is as follows (note that I have deliberately stripped out my Google Maps API key).

<!DOCTYPE html>

<meta charset="utf-8" />
<meta name="viewport" content="initial-scale=1.0, user-scalable=no" />

	#mapView { position: absolute; top: 0; right: 0; bottom: 0; left: 0; }



<div id="mapView"></div>

function initMap() {
	var broadway = {
		info: '<strong>Chipotle on Broadway</strong><br>\
					5224 N Broadway St<br> Chicago, IL 60640<br>\
					<a href="https://goo.gl/maps/jKNEDz4SyyH2">Get Directions</a>',
		lat: 41.976816,
		long: -87.659916
	var belmont = {
		info: '<strong>Chipotle on Belmont</strong><br>\
					1025 W Belmont Ave<br> Chicago, IL 60657<br>\
					<a href="https://goo.gl/maps/PHfsWTvgKa92">Get Directions</a>',
		lat: 41.939670,
		long: -87.655167

Open in new window

I need to migrate a client from Dropbox to Google Drive and am looking for a utility to do a cloud to cloud sync. I've looked at a dozen or so apps that do what I'm looking for, but choosing one seems like a crapshoot. They all seem to have some type of limitation, either low data caps, bandwidth throttling, lack of technical support. I'm hoping someone can recommend an app or service you've actually used or have confidence in. It doesn't have to be free.

This is to move approximately 700 GB of data and would be a one-time sync. Dependability, speed, trustworthiness, and support are the key things I'm looking for. Any suggestions are appreciated.
There is a top row above the complete list of Android apps on my Nexus 6 Android phone.

it seems to show the apps that are most often used using 4 icons along the top.

I would prefer to not have this show up?

is it possible to hide that row all together?

As an alternative to hiding the row all together, I would also like to know if there is a way to require a specific PIN code in order to pull up the list of apps to begin with?

I know you can do this on a per app basis, but I may need to be able to do it with the screen itself.
I am trying to figure out how to make this either in something like Excel or in Python or other. The point is to monitor students working on activities to help students who are stuck on questions/problems. I do not know if I could do this manually or if I would be better off creating something. I first thought have an instructor walk around with a timed start of a test and have them manually put in the question a student was on if a student is on a question too long it gets flagged and the instructor can come back and help. These are for students who might not be able or feel comfortable about asking for help. Then I thought maybe this is bigger than I think. Maybe I need a much bigger system than an Excel or python developed application.
First I would need a form of some kind for the questions.
Then I would need a way to start the test with a start time.
Then Partition each question so as a student completes each Question and moves to the next the timer would need to reset for each question while keeping up with the overall time spent taking the test.
On A side note, how cool would it be to be able to monitor the start and stop time for each question so that teachers could see which problems the student struggled with most? I know there are rather expensive software products out there that school systems have purchased for millions. My thoughts are something more simple. I suspect that there is a simpler solution. Maybe developed in another product or maybe there are …
I need to figure out how to see all the Google Calendars that have been created in my organization.  Is that a possibility?
Can you please give me a solution or other way to deal with to make a google doc link work on the alert message or through sidebar in HTML link, I get Malformed HTML conten Error and if I replace my a regular link which such as www.google.com it works fine.

Here the error message looks like entering image description here

That full details :

ç: hi byehttps://docs.google.com/open?id=185g8pZGceMlIqmhEsYV8tkfxKsiRd_P3t3mhjzLiX0Y target=_blank > test
My code is the following :
COPYfunction test0001()

  var doc = DocumentApp.getActiveDocument(); 
  var docurl = doc.getUrl(); 

  //var x = Gconvertlinko() ;
  var ui = HtmlService.createHtmlOutput('hi '+ 'bye' + "<a href="+ docurl+"  target=_blank > test </a>"+ "<br/> <input type="+' text'+" name="+ 'lname'+ "  value="+ "http://www.google.com" +">")
  /*.setContent( DocumentApp.getActiveDocument.getUrl() + "<br/>"+ DocumentApp.getActiveDocument.getUrl() ) */
      .setTitle('Google Convertor');



Open in new window

Please let me know if you got any idea or thought to deal with that.
Hi Experts

Could you point what's needed to run a script when using "Firebase" cloud app?

I need to insert a large set of lines  on a firebase table and need a way to run a script to do the task.

Thanks in advance!

I'm not a big fan of Googles reCAPTCHA  having clicked on 100's images of traffic lights, bicycles  and fire hydrants to be asked please try again

However can someone explain how  to validate it prior to submitting a form?

I'm assuming this is done within a JavaScript onSubmit function ??

I'm also assuming Is there no PHP  validation as reCAPTCHA  is a JavaScript library so if   isn't enabled reCAPTCHA   wont work

The code bellow is just to get going
$submit = filter_input(INPUT_POST, "submit");
  // validate form 
  $html = "<div>Hello Thank you for your message</div>";

<!DOCTYPE html>
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
    <meta charset="UTF-8">
    <title>Send a Message</title>
    <script src='https://www.google.com/recaptcha/api.js'></script>
    function onSubmit() {
    if ($html){
    echo $html;
    <div class="FormWrap">


    <legend>Email Form</legend> 

      <form id="MyForm" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

      <p><label for="Fname">Enter full name</label><input type="text" 

Open in new window

Hello, I am trying to configure SSO between Azure AD and Gsuite.  here is what i have done;

added a custom domain in azure ad
added a user with the custom domain upn sufix
added the enterprise application Gsuite and configured the sso settings
settings summarysettings summary
I have configured gsuite for third party sso and uploaded a certificate from azure

The Problem I am having is when I sign into a test account (gmail)I am redirected to the microsoft login from gsuite, I type in my username and passowrd and I am authenticated, I am then presented with this message :

 Request Id: 5106ce80-8b8b-4986-bcaf-482a67693b00
Correlation Id: 8f275842-ee87-4df5-8bad-095c79eabfaf
Timestamp: 2018-11-08T21:39:53Z
Message: AADSTS65005: Misconfigured application. This could be due to one of the following: The client has not listed any permissions for 'AAD Graph' in the requested permissions in the client's application registration. Or, The admin has not consented in the tenant. Or, Check the application identifier in the request to ensure it matches the configured client application identifier. Please contact your admin to fix the configuration or consent on behalf of the tenant. Client app ID: 01303a13-8322-4e06-bee5-80d612907131.
Advanced diagnostics: Disable
If you plan on getting support for an issue, turn this on and try to reproduce the error. This will collect additional information that will help troubleshoot the issue.

Any help is appreciated

Google Apps

Google Apps is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Apps for Work adds business-specific features such as custom email addresses at your domain and storage for documents and email.