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

Google's keyboard replacement is excellent because it contains both a clipboard tool as well as a tool for inserting gifs.

However, it poses a challenge that I have been unable to resolve so far.

If I am forwarding an e-mail and go to "insert text", There appears to be no way to move the existing text to the next line.

This is because of the blue button on the keyboard that starts out as a 'new-line' or 'return' key, but changes to a 'send' key instead.

Thanks for Nobus for correcting my terminology here.

Assistance in further clarifying the potential solution to this problem is greatly appreciated.
0
Ensure you’re charging the right price for your IT
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

This version of the expression extracts the email address from a string of characters contained within cell E2 and replaces those characters with the result.

I also need versions of the expression that will extract the first name and one to extract the last name.

The email address can possibly be defined as any string of characters that are separated by an @ symbol with no spaces and surrounded entirely by either a (parenthesis) or <chevrons>.

This should work in a google sheet such as this one here https://docs.google.com/spreadsheets/d/1rQ5QC6Ipr5kkBDuNnIMY05Z09Q4q7lqZ52vd0bfCvtY/edit#gid=1895941459

=Regexextract(E2,"[A-z0-9._%+-]+@[A-z0-9.-]+\.[A-z]{2,4}")

Open in new window

0
Hi,

I was told that Google Drive has an option to create Survey/Poll and even send to individuals so they can take it.  Some question for those expert who have worked with this tools:

  • The data that users fill out in a databases?
  • Are there reports for this database?
  • Can I export the survey/pool?
  • When creating a survey/poll, can I insert formulas if needed?
  • Any remarks on the tool?
0
is there of getting a website or app to look at the logistics of going from A to three different places in the best logical or efficient order?

like sightseeing by car but optimising the route without double backing on oneself?  does google map have a way of calculating all that for you showing each route back to back?
0
Hello all,

I have two spreadsheet problems that I need to solve. Please.

1. How do I filter out a specific cell value in order to calculate an average value for the cells with numbers?
2. The ARRAYFORMULA / AVERAGE function includes blank cells into its calculation. As a result, blank cells result in an incorrect final average. See F44 as an extreme example. The final value should be close to 8, not 3.8.


The cell column can look like this:

8 (Great!)
8 (Great!)
4
5
4
4
5
4
7
4
8 (Great!)
8 (Great!)
8 (Great!)
8 (Great!)
8 (Great!)
7
DNA
DNA

Using the formula, =ROUNDUP(ARRAYFORMULA(AVERAGE(LEFT(A2:A19,1)+0)),1), I can calculate the average of all the values. However, this formula fails on any cells that include a "DNA".

Notes:

- Ideally, I would like to either filter within the Importantrange or the average function.
- I know how to use, "=filter(A2:A19, A2:A19<>"DNA")", but how can I incorporate the average and filter, or the importrange and the filter functions?
- Also, the way I am currently calculating averages, also factors in blank cells, which skews the final average. :(

---

I am including a sample worksheet, see tab "Filter out data".
In the sample worksheet, for simplicity, I am using "=ArrayFormula('Sample Data'!A2:E19)" instead of an "Importrange" function.

https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=2077598250


Thank you
0
I'm having one of those moments where I cannot figure out what should be very simple. Help please. :)

From a survey, I have asked multiple people to rank something from 0% to 100%.

The results are something like this:

        A          B
01   60%     3  
02   70%     2
03   80%     9
04   90%     2
05  100%    1  

Column A is the percentage value. I need to determine the average % based on the number of votes in column B.

I am trying to calculate the average distribution value. Just 'eyeballing', I expect the value should be about 78%.

How do I calculate this value in a spreadsheet?

I created a scratch spreedsheet to assist.
https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit?usp=sharing

Thank you so much. :)
0
Hello experts,
I set up the following AutoHotkey to send clipboard on google drive and upload files.
+F9::
FilePath1:=Clipboard
FilePath2:=StrReplace(FilePath1, """")
If (Not FileExist(FilePath2))
{
	Msgbox,0x10,Error, Your clipboard which report the following value %FilePath2% doesn't exist	
	Return
}
Else
Msgbox,0x40,Success, Your clipboard which report the following value %FilePath2% exist	
WinGetActiveTitle,Title
If (InStr(Title,"Google Drive"))
{
	PostMessage,0x112,0xF030,,,%Title%
	Sleep, 100
	Send, mc 	
	Sleep, 100
	Send, {Down 2}
	Sleep, 100
	Send, {Enter}
	Sleep, 1500
	WinGetActiveTitle,Title
	If (InStr(Title,"Open"))
	{	
		Send, %FilePath2%
		Sleep, 100
		Send, {Enter}
		Return
	}
	Else
	MsgBox,0x10,Error,Unable to send path as active window doesn't contains name expected
	Return
}
Else
  MsgBox,0x10,Error,Google Drive is not the active window
Return

Open in new window


I made a test with the following cases and it works:
1-Error when clipboard doesn't contain a file which exist
2-Success when the clipboard contain a file which exist
3-Error when google drive is not the active windows

Prior to adding to my AutoHotkey file I would like to have some advice to see if the AutoHotkey should be revised in term of structure, conditions and loops.
I am aware that Send keys is not the best way however this is how I can work on google drive.

Thank you for your help.
0
I am looking to share a phone with a local audience as depicted in the following scenario.

Phone Scenario:
Let's say that I was going to present the following sample slide presentation to a larger audience from my phone, meaning that I was going to pass my phone around the room and allow others to navigate through the following slides as shown here https://shorturl.at/yNOT4.

I don't want the viewers to lose that spot and be forced to hand my phone back to me before it makes it around the room.

How can I accomplish this, ensuring that the slide content is not interrupted by messages or by navigating away from the intended content?

Assistance is greatly appreciated.
0
I have been directed to deploy a group of chrome books (30 or more) by a certain date.  My knowledge is limited =)  My thought is to get a Google admin console (gsuite) to manage the chromebook devices only, not users.  Another unit in the company already manages google user accounts.  

If I do get a Google admin console, and just enroll chromebooks with it (not create user accounts), can I also:

1. push security and functionality updates to the devices?
2. manage a central repository of approved "google play" apps, or push apps onto the chromebooks from a console?
3. prevent any user that is logged in from changing settings, adding unapproved apps, or removing apps that I have installed?  

Thank you!!
0
How to resolve the following error generated when creating an embedded Google Map using the Javascript API

      Failed to execute ‘postMessage’ on ‘DOMWindow’: The target origin provided (‘http://www.themagnolia.com’) does not match the recipient window’s origin (‘http://themagnolia.com’).

I'm not clear where this conflict originates or where to make the correction.
0
Microsoft Azure 2017
LVL 13
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Hi,

We use Google For Business for our work email.

We are trying to gain access to one of our old staff's email account, as he used his email address to register a piece of software that we use, and we now need to change it to our main service email, as we can't change our billing.

When we try reset the password, it sends a code to his phone, however he no longer uses the same phone number so he is unable to help us.

As Admin of the Google account, I thought I would be able to get around this, and access this inbox?

Any ideas would be much appreciated, thanks.
0
Dear Experts

We are having google G-suite Basic, would like to take backup of few users mail box (inbox, sent ) as a policy we have to keep emails of every user for one the period of one year please suggest the best practice on backup and archival for g-suite basic, if we have to procure any software please do suggest, thanks in advance.
0
Hi Experts,

I am trying to connect to Google Calendar API, but I am getting Not found error. What could it be, I already added the client ID as permission into the Calendar that I want to use.

PHP Fatal error:  Uncaught Google_Service_Exception: {
 "error": {
  "errors": [
   {
    "domain": "global",
    "reason": "notFound",
    "message": "Not Found"
   }
  ],
  "code": 404,
  "message": "Not Found"
 }
}
 in C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\src\Google\Http\REST.php:118
Stack trace:
#0 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\src\Google\Http\REST.php(94): Google_Http_REST::decodeHttpResponse(Object(GuzzleHttp\Psr7\Response), Object(GuzzleHttp\Psr7\Request), 'Google_Service_...')
#1 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\src\Google\Task\Runner.php(176): Google_Http_REST::doExecute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google_Service_...')
#2 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\src\Google\Http\REST.php(58): Google_Task_Runner->run()
#3 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\src\Google\Client.php(788): Google_Http_REST::execute(Object(GuzzleHttp\Client), Object(GuzzleHttp\Psr7\Request), 'Google_Service_...', Array)
#4  in C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\src\Google\Http\REST.php on line 118

Open in new window

0
Hi Experts

I built an application a while back that successfully used Google Maps API. Now I needed to connect to another Calendar from another Google account, I already downloaded the servive_key.json, and set permission to to generated client_id, but I get the following error:
Fatal error: Uncaught exception 'GuzzleHttp\Ring\Exception\RingException' with message 'cURL error 60: SSL certificate problem: unable to get local issuer certificate' in C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\vendor\guzzlehttp\ringphp\src\Client\CurlFactory.php:127 Stack trace: #0 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\vendor\guzzlehttp\ringphp\src\Client\CurlFactory.php(91): GuzzleHttp\Ring\Client\CurlFactory::createErrorResponse(Array, Array, Array) #1 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\vendor\guzzlehttp\ringphp\src\Client\CurlHandler.php(96): GuzzleHttp\Ring\Client\CurlFactory::createResponse(Array, Array, Array, Array, Resource id #123) #2 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\vendor\guzzlehttp\ringphp\src\Client\CurlHandler.php(68): GuzzleHttp\Ring\Client\CurlHandler->_invokeAsArray(Array) #3 C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\vendor\guzzlehttp\ringphp\src\Client\Middleware.php(54): GuzzleHttp\Ring\Client\CurlHandler->__invoke(Array) #4 C in C:\inetpub\wwwroot\CRM_COR\utilities\google_calendar\vendor\guzzlehttp\guzzle\src\Exception\RequestException.php on line 51

Open in new window


I used the previous API Connection without a SSL successfully.

Thank you.
0
Hi guys,

I have a client that needs to LOCK - Password Protect a Folder on Google Drive, local & online versions...

They have a couple computers & staff has access to their google drive folders online & local versions.  

They want to be able to have an ADMIN folder where they would put files that only can be accessed by the higher staff.  

Can this be accomplished??  I am not sure I am looking at this the right way, but the result of locking 1 folder is what I need, that would need a password to enter that folder, can this be done?

I know they can password protect let say a Word or Excel file as they go, but they want to be able to just drop a file in the protected folder & then it be Locked... can this be done??

Oh yea & it needs to be easy for client to be able to implement if they have additional folders later on... lol... Of course I can setup initial folder, but down the road they may want to add folders...

Please let me know... Thanks... :-)
0
Hi Experts,

A while back my client gave me permission to her Google Calendar so I can connect it to a application. I did so by going through the steps and downloading a .json file. I will admit that this was my first and only connection to the Google API.

Recently she has removed the permission, and the API call no longer work. She would like me to go in to her office and connect it from there. So I don't spent a lot of time, could anyone please tell me the steps for setting up the Google API under her account, then downloading the .json file?

Thanks
0
One more question regarding my spreadsheet.

I need a way to compare a list of email addresses against a list of names.
Using: =IF(ISNA(MATCH(R2,sort(FILTER({$K$2:$K$93}, LEN({$K$2:$K$93}))),0)), "Not Found", "Found")

And comparing a column K, which contains: Alayna Sergio
... against column R, which contains: Alayna Sergio <alayna.sergio@group.com>

Results in "not found". That is because it is looking for a precise match. Is there a way to search for just the name?

Here is the sample spreadsheet:
https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=0

See the Grid to List tab.

Thank you. :)
0
Hello all,

I am looking for a little more help to solve a small flaw in an idea I had for a round-robin auto name selector.

Based on a specific condition, where "ASC" exists in column C, an assigned reviewer will automatically populate column J, from a pool of names in column L.

This works very well, except for one problem. The names will dynamically change, if new entries become available in column C. I am trying to find a way to lock down the name in column J, once the condition is met.

I was thinking that the solution could be to only add a name (from L reviewers list), if the cell in column K is empty. Once the cells in column K are populated, the name will not change. The possible caveat to this is that I also want the names to be evenly distributed.

Any ideas on how this can be accomplished? Please see sample sheet.


Thanks to the tremendous help from EE, I have some really nice formulas for automation in the following spreadsheet. Feel free to take anything from this sheet. :)
https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=964764875

Thank you.
0
Greetings all,

I have another spreadsheet challenge.

I have two columns: Team Number (numbers 1 - 20), Team Name. I need to concatenate the two columns to create a file name, according to a specific file naming convention.
Using this formula: =If($A2<10,concat(concat(concat("EventDay06-0",A2),"-"),T($B2)),concat(concat(concat("EventDay06-",A2),"-"),T($B2)))

The problem that I need to solve is for names with illegal characters. The easy way is to disallow special character, but I prefer to find a technical solution, if possible,

For example:
Team names, "More > One" converts to "EventDay06-08-More > One" but I need to automatically change this name to "EventDay06-08-More-One", etc.

Basically, I need to replace illegal characters with a substitute.

See sample sheet:
https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=964764875

How can I make automatic character substitutions?


Thank you

Thank you
0
Rowby Goren Makes an Impact on Screen and Online
LVL 13
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

I'm looking to control shades via Google Home smartphone software?

I found this on Amazon for under $100 and it says it's compatible with Google Home.

However, I really don't have any idea if this is the best place to start.

https://www.amazon.com/Internal-Re-Chargeable-Automatic-Motorized-Compatible/dp/B07RWTYDXG/ref=sr_1_6?keywords=google+home+automatic+shade&qid=1558928368&s=gateway&sr=8-6

What's really necessary for this?

Does Google also offer a way to control TV's also through a phone app?
0
I have a Google Sheet where I have five columns and 20 rows of names, and I am looking for a way to collect all the names, sort them, and list them in a single column, then compare the list against another list to find the missing names.

I searched for an example of how to accomplish this and found nothing similar. :(
To be specific, I need to find a way to do this using a formula and without add-ons macros. Is it possible?

To make this easier, I am including a working sheet:
Here is the example sheet.
0
When we try to see street view of Google maps we are getting "server error, try later." That's been the result 3 days in a row. We have Windows 10 and tried with FF and Chrome. Thanks.
0
Full disclosure: not a developer, never worked with any of this before. This seemed like a very straightforward process that isn't working for some reason.

Trying to use Chrome App Builder : https://chrome.google.com/webstore/detail/chrome-app-builder/ighkikkfkalojiibipjigpccggljgdff?hl=en
To create an app that points to a website that will run in kiosk mode. This should be a relatively simple undertaking. You name the app, plug in the url in the homepage section, (our is https://ffc-ic.ffc8.org/campus/OLRLoginKiosk/ffc) configure any settings for navigation, then select to save as kiosk.

While testing the app by opening the more tools-->extensions-->turn on developer mode-->load unpacked, however, I get errors. Having no idea where to even start on this (isn't it just supposed to be redirecting to a website?) I'm asking for assistance to determine where the errors could possibly be coming from.

Warning: Unknown Model in arequire
function arequire(modelName, opt_X) {
  var X = opt_X || GLOBAL.X;
  var model = FOAM.lookup(modelName, X);
  if ( ! model ) {
    if ( ! X.ModelDAO ) {
      console.warn('Unknown Model in arequire: ', modelName);
      return aconstant(undefined);
    }

Open in new window


Warning: Tried to load
arequire(obj.model_)(function(model) {
            if ( ! model ) {
              console.warn("Tried to load ", obj.model_, " on demand, but no luck.");
              future.set(obj);
              return;

Open in new window

0
Dear Experts
We are using g-suite/google aps for the email services. We have following requirement that is to restrict the user accounts such that they should be able to send the emails to all the users within the same domain and should be able to send to external domains users of 4 domains and restrict for all other domains.
Please suggest is possible if yes then what should be done.
If above is not possible with google aps/g-suite then we have to setup email server on-premises and if we go for the on-premises zimbra email server can we achieve this please suggest, thanks in advance.
0
I want to assign a unique, ascending number to each person as they check-in.
I'm envisioning a simple check-box in Column A, that when clicked, will auto-increment the highest number in column D
Example:

(A)                 (B)                  (C)                  (D)
checkbox    First Name    Last Name   Number
[ ]                  Tom                Smith            
[x]                  Jane               Doe                 1

Doesn't have to be a check-box, but any way to autoincrement that numeric column...
Found a script that I manipulated hoping to get it working, but it simply places the row number in the corresponding column - I want it to be the next value incremented from what's already in column D
In the script, the columns A & D are flipped from my example above.

function myFunction() {
  var AUTOINC_COLUMN = 0;
  var HEADER_ROW_COUNT = 1;
  var CHECKED_IN_COLUMN = 3;
 
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var worksheet   = spreadsheet.getSheetByName("Assignments");
  var rows        = worksheet.getDataRange().getNumRows();
  var vals        = worksheet.getSheetValues(1, 1, rows+1, 4);
 
  for (var row = HEADER_ROW_COUNT; row < vals.length; row++) {
    try {
      var chk = vals[row][CHECKED_IN_COLUMN];
      Logger.log(chk);
      if ((chk)) {
        // Here the columns & rows are 1-indexed
        worksheet.getRange(row+1, AUTOINC_COLUMN+1).setValue(row);
      }
    } catch(ex) {
      // Keep …
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.