Go Premium for a chance to win a PS4. Enter to Win

x

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

hi,

This post is a question and solution in one. I will post my solution as the first comment, but welcome any other input in case it helps me or any others with the same kind of problem.

Creating complex filters in google sheets can be messy because:
1. there is no commenting facility within the formulae so complex expressions will quickly get messy
2. currently logical expressions AND OR etc cannot be processed directly within ARRAYFORMULA, so this logic must be expressed using a numeric approach.

Example
Scenario: property rental business needs to assess unoccupied periods coming up in the next 14 days
Solution: query list of bookings to see what gaps are, or are coming up in the next 14 days

Not very pretty solution, filter bookings where:
(IF( (IF((round(now())<=BOOKINGS!B:B),1,0) + IF(((round(now())+14)>BOOKINGS!B:B),1,0) )=2, 1,0) + IF( (IF((round(now())>BOOKINGS!B:B),1,0) + IF((round(now())<BOOKINGS!C:C),1,0) )=2, 1,0) )>0      

This expression is explained in detail via the link posted in the first comment.

Note:
BOOKINGS!B:B = Checkout date
BOOKINGS!C:C = Next check-in date

Any better suggestions (using google sheets only)?
0
[Webinar] Cloud Security
LVL 11
[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Hello experts,
I have the following situation,

I have a pc windows10 and I have a Macbook pro

I have installed Google drive on the pc and installed wamp and synced 2 folders in the www folder of wamp located in C:

As I'm taking my laptop from a room to another I installed Google drive on this laptop but the folder i chose to sync from pc couldn't be downloaded into my laptop

I'm not sure how to setup this properly as mamp path is different and wamp path is also a different location and my google drive is only showing files not folders...

any idea?
0
When I print a Gmail Inbox email, it's teeny-tiny, like 65% to scale, barely readable when it prints. I set it to 100% Scale, but nothing happened when I changed that (it starts at 62), here:
Inbox prints small
But when I print from regular Gmail, it's normal, here:
Gmail prints ok
The difference seems to be Inbox / Gmail, so ???
0
We are looking to move all of our users (about 150) off our parent companies instance of G Suite to a new instance/tenancy with a different domain.  Basically as if we are separating from the parent company type of situation.

We want to migrate mail, calendars, contacts, groups and all Drive docs with revision history and permissions in tact. I have 2 main concerns:

1 - We have spoken to several migration companies and some tell us they need to do a password reset for all users and user a temp pw to migrate, others say that isn't necessary.

2 - No one can give us a definitive answer as to whether or not the Drive docs can be moved with retention of revision histories and permissions either.

Looking for some solid answers and suggestions.
0
I know On a PC you have the G-sync agent that syncs everything.

Is there such a program for Mac? (outlook 2016)
0
I work for a organization with a large website. I have been asked to provide the following stats from 2016 about the website:

  • total number of web pages on our website
  • total number of page linked to a newsletter

Regarding bullet number two: A friend suggested that I use Campaigns to track pages being linked to newsletters, which I assume would mean creating a different campaign for every newsletter link. I can do that going forward in 2018, but that doesn't help me find the stats for 2016.


Can I retrieve the 2016 stats for both bullets from GA and how would I do so? If it can not be retrieved from GA, please offer suggestions on how I may find this information.
0
I am using google maps api including MarkerWithLabel.
For some reason when changing the map zoom (using the map controls) markers seem to lose their exact location.
Code below. Please if someone can help to keep the markers in place when zooming in-out. Thank you!

var map = new google.maps.Map(document.getElementById("map"), {
  center: new google.maps.LatLng(52.554201,13.425703),
  zoom: 16,
  streetViewControl : false,
  overviewMapControl: false,
  mapTypeControl: false,
  zoomControl : true,
    zoomControlOptions: {
      position: google.maps.ControlPosition.RIGHT_BOTTOM
    },            
  panControl : false,
  scrollwheel: false,
  fullscreenControl: true,
  mapTypeId: google.maps.MapTypeId.ROADMAP
});

google.maps.event.addDomListener(window, "load", function () {

function createMarker(options, html) {
    var marker = new google.maps.Marker(options);
    return marker;
  };

var marker = createMarker({
    position: new google.maps.LatLng(56.554201,19.425703),
    map: map,
    cursor: 'hand',
    icon: "images/location.png",
  });

var marker2 = new MarkerWithLabel({
        position: new google.maps.LatLng(53.549140,14.428730),
        icon:'images/pointers.png',
        map: map,
        labelContent: "Agni <span>Shop</span>",
        labelAnchor: new google.maps.Point(44,86),
        labelClass: "labels",
        labelStyle: {opacity: 1}
     });

});

window.onresize = function() {
  var currCenter = new google.maps.LatLng(52.555564,13.426775);
  

Open in new window

0
My Outlook sync tool went "out-of-sync" and created 7-8 copies of each appointment in each Outlook calendar and G Suite calendar.  I can kill Outlook and recreate again.  
How can I get rid of the duplicates in G Suite calendar?  Thanks.
0
Hi,

I'm trying to grab a link from a webpage using google sheets IMPORTXML function.

Inspection using Chrome shows the following:
href.JPG
The XML path shows as:
//*[@id="site-content"]/div/div/div/div[1]/div/div/div[1]/div[1]/a

As per previous question...
https://www.experts-exchange.com/questions/29059324/How-to-scrape-links-from-webpages-using-IMPORTXML.html

...I have tried the following with no luck:
//*[@id="site-content"]/div/div/div/div[1]/div/div/div[1]/div[1]/a/@href

How can I grab the
href="/users/show/143153844"
?

Thanks
0
Scenario: A school has different year groups and on the main home page of the school's web site, the school has one calendar with people can download into the google calendar.

The problem as a parent, is that it shows the activities and dates of events for all year groups, 80% of which are not relevant to me as my child is not in those other year groups.  I want to make a suggestion to the school to run individual calendars so that I can sync only the year group that I need.

I want to contemplate how easy this will be for them to do or possibly expect a response that this will be too much admin for them to manage.  In case that is the answer they come back with, can anyone here come up with a smart solution to this which will allow those parents to only download the year group that their child is in whilst also keeping the admin to a minimum for the school to manage the diary.  I don't know if Google Calendar has a feature to management groups like this?
0
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Is it possible with Google Apps ,

to have the following:

When someone emails an external email just before sending the email a popup will show a notice that this email is going outside the organization .

And also it will add to the subject line the word EXT or External.
0
We have to store documents in google cloud storage directly from our application. We will use “Service Account Key” to upload/view documents on google cloud storage.

We will create separate independent bucket for each user to store their documents on google cloud.

We would like to create separate “Service Account Key” for each and every Bucket on google cloud storage, each service account key expected to have access only for one bucket on the google cloud storage.

The buckets are expected to accessible with the service account key assigned to it and not accessible with other bucket service account key.

Does it possible to assign separate “Service Account Key” for each bucket in Google cloud storage, if yes, how can we do that?
0
I have an OnePlus 5 running the latest Android 7, stock (not rooted). How on earth do I set Sunday as the first day of the week such that Google Calendar, Inbox and Keep all use Sunday as the start of the week.

Thanks in advance.
0
Hi,
I am using a small code in Excel but know need to use it in Google Sheets,but im not able to convert the code to google sheets
Please help.

Code as below:

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim temp As Range, max As Range, min As Range

    Set temp = Range("A2")
    Set max = Range("B2")
    Set min = Range("C2")

    If Not Intersect(temp, Target) Is Nothing Then
        max = WorksheetFunction.max(Target, max)
        min = WorksheetFunction.min(Target, min)
    End If
    End Sub



Thanks and Regards
0
Galaxy S7.
How can I have my ringer automatically turn on in the morning (I usually shut it off during the night)?
0
Cannot seem to find the answer to this anywhere.. Does Google Authenticator require a RADIUS server linked to Active Directory? If not how does it authenticate against the domain\user?

Thanks in advance,
0
Hi
I m developing  mini qemu like VM for Android device .
Any suggestion how to go through.Any starting point of atleast 1000 line code only
0
hi,
how to copy photos from moto 4g plus phone to windows laptop without using APPs which are not dependable. I like to view all the wats up etc photos, files received back up ones i needed and delete ones not needed after connecting to laptop similar to how i used to do earlier with samsung phone. please advise
0
Hello all, hoping someone can point me to the right program.

Our company is wanting to get a staff attendance sign in / out register. It really doesn't need to be over complicated or offer any other services, simply, staff turns up to work, punches in, staff leaves punches out.

We currently use an excel file for this, to begin with it was ideal, but as our company grows we need a little bit more.
I have searched for past 2 weeks straight trying to find the right program, all the ones i have found so far are way more advanced than what we need and price is way out of budget, or they are for 1 staff member only, that clocks in and out,
need to be able to add names, staff click on there name, signs themselves in or out.
0
What does it mean to be "Always On"?
LVL 5
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

I have about 30 000 files which are a mix of jpg, png, mov, mp4 and potentially others.  Total size is around 70GB.  I've collected these into a single folder structure and left an upload to google photos running, and then used the desktop uploaded and left that for a week to upload any that were missed.

Now, I'm not sure which have uploaded successfully and which haven't.  The 'log' created during the upload is not helpful when working out which files haven't uploaded.  I've done a download of the photos from google photos through their backup system.  However, I can't just windiff between the two folders as they have different subfolder structures.  I've tried doing an xcopy of files to a single folder but some of the files have the same name (although different dates) and I may miss out on file-extensions that I'm not aware are in the listing.

Does anyone have any ideas or scripts I could run to make the problem easier to solve, or to come up with the final list of files that haven't uploaded?
0
I have an application that creates an xml file with marker information.  It pulls the text for the info window, but I can't get it to show the picture links as pictures or links. When i add anything to the code to define the links, it breaks the whole map.

Here is my code snippet:
ownloadUrl("phpsqlajax_genxmlx.php", function(data) {
        console.log(data);
        var xml = data.responseXML;
        var markers = xml.documentElement.getElementsByTagName("marker");
        for (var i = 0; i < markers.length; i++) {
          var name = markers[i].getAttribute("name");
          var fulladdress = markers[i].getAttribute("fulladdress");
          var beds = markers[i].getAttribute("beds");
          var type = markers[i].getAttribute("type");
          var drg = markers[i].getAttribute("drg");
          var providernumber = markers[i].getAttribute("providernumber")
          var telephone = markers[i].getAttribute("telephone")
          var owner = markers[i].getAttribute("owner")
          var ImpactofReadmissions = markers[i].getAttribute("ImpactofReadmissions")
          var ReadmissionsAdjustmentFactor = markers[i].getAttribute("ReadmissionsAdjustmentFactor")
          var PneumoniaCases = markers[i].getAttribute("PneumoniaCases")
          var COPDCases = markers[i].getAttribute("COPDCases")
          var ExcessReadmissionRatioforPneumonia = markers[i].getAttribute("ExcessReadmissionRatioforPneumonia")
          var employees = 

Open in new window

0
I’m trying to create a google column chart with Google apps script using a data table in google sheets and I keep getting the following error “Data column(s) for axis #0 cannot be of type string”. All the examples have found only use dataTable Array within the script but mine is using data in a separate google sheet.

Here’s the Google Apps Script  I have used:

function doGet(){
   var ss = SpreadsheetApp.openById('1phbmEm0NE4zrwQn6NnfSU0HNPiFofQryZ4OqrUOB5cA');
   var sheet = ss.getSheets()[0];
   var data = sheet.getDataRange().getValues();
 
 
  var dataTable = Charts.newDataTable();
   
   for( var j in data[0] ) {
      dataTable.addColumn(Charts.ColumnType.STRING, data[0][j]);
   
  }
 
 for (var i = 0; i < data.length; i++) {
    if (i > 1) {
        var d = new Date(data[i][0]);
        //data[i][0] = d.toJSON().split('T')[0];  
       // data[i][0] = Number(d.toJSON().split('T')[0]  );
    }
  }
  for( var i = 1; i < data.length; ++i ) {
     dataTable.addRow(data[i].map(String));
 
  }
 
  for (var i = 0; i < data.length; i++) {
    if (i > 1) {
        var d = Number(d);
    }
  }
 
 
   var dateFilter = Charts.newCategoryFilter().setFilterColumnIndex(0).build();
 
 
    var columnChart = Charts.newColumnChart()
    .setDataViewDefinition(Charts.newDataViewDefinition().setColumns([0,1,2,3]))
    .setTitle('Goals Started vs. Goals Completed')
    .setXAxisTitle('Date')
    .setYAxisTitle('Goals')
    …
0
A while back my old Phone got some water in its speaker and stopped workikng. I have stories and notes that i had on my quick memo, that i would love if i could retrive.
0
That's right, I have a client who wants to deliberately delay emails to their Gmail.

They would like their emails to be delivered every 4 hours instead of it coming down as they get them.

Any suggestions on how to do this?  Or does anyone know if there is a service that does this?

We're currently looking into doing it with Azure Queues but thought I'd put it out there to see if anyone knows of any other way.  Or if there is a way of doing this native to Gmail.

Thank you in advance.
0
Hi,
I have Exchange 2016 running on two machines in a DAG.
Sending and receiving mail is fine for everyone except.
If anyone tries to send to a gmail address they get this bounced back (I do have a valid PTR record set up)
------
mx.google.com
Remote Server returned '550-5.7.1 [146.20.151.xxx] The IP address sending this message does not have a 550-5.7.1 PTR record setup. As a policy, Gmail does not accept messages from 550-5.7.1 IPs with missing PTR records. Please visit 550-5.7.1 https://support.google.com/mail/answer/81126#authentication for more 550 5.7.1 information. n66si97323qka.349 - gsmtp'
---
Then I go onto the local machine and try to connect to the gmail address using telnet localhost 25
The message I get back there is:
550 5.7.54; Unable to relay recipient in non-accepted domain

The server isn't set up as an open relay.
Searches across google say I have to set up a special connector of some sort, but that seems very odd. Why would gmail require a special connector.

Any suggestions? My users are going nuts because the can't send to gmail.
Thanks,
Nacht
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.