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

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
Exploring SQL Server 2016: Fundamentals
LVL 13
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

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
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
Bootstrap 4: Exploring New Features
LVL 13
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

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

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
I have a spreadsheet (https://docs.google.com/spreadsheets/d/1QsuGjcRhZRL6Y4M8l8Y8qhrb_nZn47JrGmZTQumGYaI/edit?usp=sharing) that allows me to configure tournament results and determine the winner based upon match wins, or point percentage.

My issue currently is that if I redo the schedule, I have the match win formula set to the static cell where that person plays.
I want it to be some sort of lookup to find the person's name in the schedule at the bottom.

Example:
John & Nick are paired up for Match 1 (shown in the bottom schedule layout).
I need a lookup that will determine all of John's individual wins - thus the formula would need to find which matches he is participating in.  If the result is a Win, it increments his win column.  If it's a loss, it increments the loss column.
Currently only cell G11 shows a valid formula, but it's pointing specifically to the cells where I know John is playing.
I need a formula that will first determine in the schedule at the top, what matches show "1" (John) and then determine the outcome of the match in the schedule at the bottom.

Hopefully this makes sense - but let me know if I need to explain further.
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.