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.

Share tech news, updates, or what's on your mind.

Sign up to Post

I would ideally like to be able to Sort and Edit my Google contacts, online, from the same page.

Is there anything that makes this possible?
0
Ensure Business Longevity with As-A-Service
Ensure Business Longevity with As-A-Service

Using the as-a-service approach for your business model allows you to grow your revenue stream with new practice areas, without forcing you to part ways with existing clients just because they don’t fit the mold of your new service offerings.

In a Google spreadsheet, I have an area where people are doing manual data entry.
  • People are entering game results from a paper scoresheet
  • Each row in the data entry area shows the results for a single "question", entered into Columns B through K
  • For each cell, the valid values are a blank cell, 0, -5, 10, 15, and X (upper case only)
  • For each row, I need to get a count of how many cells have an invalid entry

I have a formula now which is returning the correct answer, but it's a brute force approach. Is there a more elegant way to do this?

=if(not(or(B2="",B2=0,B2=-5,B2=10,B2=15,exact(B2,"X"))),1,0)+if(not(or(C2="",C2=0,C2=-5,C2=10,C2=15,exact(C2,"X"))),1,0)+if(not(or(D2="",D2=0,D2=-5,D2=10,D2=15,exact(D2,"X"))),1,0)+if(not(or(E2="",E2=0,E2=-5,E2=10,E2=15,exact(E2,"X"))),1,0)+if(not(or(F2="",F2=0,F2=-5,F2=10,F2=15,exact(F2,"X"))),1,0)+if(not(or(G2="",G2=0,G2=-5,G2=10,G2=15,exact(G2,"X"))),1,0)+if(not(or(H2="",H2=0,H2=-5,H2=10,H2=15,exact(H2,"X"))),1,0)+if(not(or(I2="",I2=0,I2=-5,I2=10,I2=15,exact(I2,"X"))),1,0)+if(not(or(J2="",J2=0,J2=-5,J2=10,J2=15,exact(J2,"X"))),1,0)+if(not(or(K2="",K2=0,K2=-5,K2=10,K2=15,exact(K2,"X"))),1,0)

Open in new window

0
Does anyone know if there are any Gmail extensions that auto delete specific emails from specific senders after they have been read and sat for say 3-5 days in my inbox.....automatically. Like a rule sort of but runs to check the inbox for say a daily alert.
Here is an example I get a daily balance from my Wells Fargo accounts that say what my balance is or if there has been any activity.
is there a feature or extension that will look at emails from Wells Fargo that are either opened and sat in inbox for 3 or more days and delete them automatically.
Or If I watch the TV show Frontline on PBS and it tells me that a show is airing that night.
These kinds of emails are great. I just forget to delete many like them and they build up.
Also I noticed that some businesses or marketing emails from companies constantly send messages I do not need. EVEN AFTER SETTING THEM TO UNSUBSCRIBE OR PREFERENCES IN THE PROFILES THAT THEY BUILD...!
Is there a way to manage all that excess junk crap etc that just builds up.

I want to get to a place where all my emails I handled every day had a place for completed archived deleted or work still in progress. The big thing is to clean up else my Tiny Mind will get overloaded with junk and I will develop a brain fog I cannot navigate. Any good tools or extensions for gmail that do that. Primarily the auto delete part?
0
Google Apps question..

Hello there,

An end user contacted me regarding not being able to access  a shared calendar we use for conf room reservation. She has access to other but not a specific one.

I'm new to G suite, i have admin rights but i can't find where those calendars are created so i can check for permissions. Can any one point me in the right direction..

Thanks.
0
I am running a Mac Pro 14.4.4 with Chrome Version 73.0.3683.86 (Official Build) (64-bit)

I manage Google Apps for our Domain and I seem to be signed in TWICE, one with a personal account and one with a Work account.

What I mean by this is that the icon next to the Hamburger menu is "Paused" and has my personal Gmail Account signed in but when I login to my Google Apps (e.g. Mail.DOMAIN.com) it shows my work account.

Does anyone know how to resolve this? Ultimately I'd like to be signed in ONLY to my Work email for this computer and enable synching of bookmarks.

Thanks!
0
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

Lourensvd
DAG-Trevor-e-mail-accounts-on-PC.docx
0
I have some code that uses javascript and plots multiple markers in a map.

Here is the code:

<!DOCTYPE html>
<html> 
<head> 
  <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" 
          type="text/javascript"></script>
</head> 
<body>
  <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.setContent(locations[i][0]);
          infowindow.open(map, marker);
        }
      })(marker, i));
    }
  </script>
</body>
</html>

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?
0
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?
0
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 .
Regards,
Aaron
0
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?
0
Exploring ASP.NET Core: Fundamentals
LVL 13
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

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.
Trace-2019-02-11-14-05-59-p7884.txt
0
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
0
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.
=ifError(vlookup(B4,Sign-Log!$B4:$C50,2,False))

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
0
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?

Thanks
0
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?

Thanks
0
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.
0
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.

eg

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

http://api.jquery.com/load/

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) {
	$("#myMap").load(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>
<html>
<head>

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

<style>
	#mapView { position: absolute; top: 0; right: 0; bottom: 0; left: 0; }
</style>	

</head>

<body>

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

<script>
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

0
Become a CompTIA Certified Healthcare IT Tech
LVL 13
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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 …
1
I need to figure out how to see all the Google Calendars that have been created in my organization.  Is that a possibility?
0
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
http://www.google.com>.
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');

  DocumentApp.getUi().showSidebar(ui);


}

Open in new window


Please let me know if you got any idea or thought to deal with that.
Screen-Shot-2018-12-10-at-1.25.14-PM.png
0
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.

img001
img002
Thanks in advance!
0
Hi

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
<?php
error_reporting(E_ALL); 
$submit = filter_input(INPUT_POST, "submit");
if($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.
-->
<html>
  <head>
    <meta charset="UTF-8">
    <title>Send a Message</title>
    <script src='https://www.google.com/recaptcha/api.js'></script>
      <script>
    function onSubmit() {
      document.getElementById("MyForm").submit();
    }
  </script>
  </head>
  <body>
    <?php
    if ($html){
    echo $html;
      }
    else
      {
      
      
    ?>
    <div class="FormWrap">

          
  <fieldset>

          
    <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

0
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
0

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.