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

How can I either:

1. Find and read these 2 unread emails

or

2. Mark all of the over 80,000 emails in the Gmail Inbox as read to reset this unread email count?
0
Angular Fundamentals
LVL 12
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

I'm attempting to create a procedure which will return the distance between two points based on the Google Maps DistanceMatrix API.  My initial code (VBA) looks like:
Public Function GoogleDistance(FromAddress As String, ToAddress As String) As String

    Dim strMyKey as string 
    Dim sXMLURL As String
    Dim objXMLHTTP As MSXML2.ServerXMLHTTP
    
    On Error GoTo ProcError
    
    strMyKey = "aaaa" '<= this is not the actual key
    sXMLURL = "https://maps.googleapis.com/maps/api/distancematrix/xml?" _
            & "origin=" & Replace(Replace(FromAddress, "  ", " "), " ", "+") & "&" _
            & "destination=" & Replace(Replace(ToAddress, "  ", " "), " ", "+") & "&" _
            & "key=" & strKey
'            & "sensor=False" & "&"
Debug.Print sXMLURL

    Set objXMLHTTP = New MSXML2.ServerXMLHTTP
    
    With objXMLHTTP
        .Open "Get", sXMLURL, False
        .setRequestHeader "content-Type", "application/x-www-form-URLEncoded"
        .send
    End With
    
Debug.Print objXMLHTTP.responseText

ProcExit:
    Exit Function
    
ProcError:
    Debug.Print Err.Number, Err.Description
    MsgBox Err.Number & vbCrLf & Err.Description
    Resume ProcExit

End Function

Open in new window

At this point, I'd be happy if this would return anything other than:
<?xml version="1.0" encoding="UTF-8"?>
<DistanceMatrixResponse>
  <status>INVALID_REQUEST</status>
</DistanceMatrixResponse>

Open in new window

I'm sure it is something simple in the formatting of the request string, maybe a comma, a space or something else.  The data I'm testing it with generates the following string:
https://maps.googleapis.com/maps/api/distancematrix/xml?origin=Grafton,+VA&destination=Yorktown,+VA&key=aaaa

Open in new window

0
I need help with Google Drive. When I try to listen to a voice recording or recorded calls from my phone they are stored in various extensions. The problem is when I play a video or an audio recording I am not able to do that I get 2 options. Download to my PC which I have not done so or connect with more apps. At this point I would either have a video player for Google or an audio player for Google. But I would have to choose that every single time. Is there a way to make those Google players for audio and video default for what is stored in Google Drive or can I use my VLC player on my pc to do so?

Lastly, I had added 2 extensions from the connect with more apps one is countdown timer and the other is an all in one audio player. But I can not see them anywhere on my Google Drive. Where are they located so that I can use them?

Thank you,
Basem Khawaja, R.Ph.
0
luxuryretreats.com and eag.com mail servers are hosted by "google apps". both companies are reporting that they're not receiving any emails coming from our domain rosenaviation.com. but we're receiving emails from them.

i did a test email and got these back
Delivery to these recipients or groups is complete, but no delivery notification was sent by the destination server:

i did a test and sent an email to any domain including gmail.com and all recipients received emails coming from rosenaviation.com
0
Is there a simple way to save/move an iTunes movie to Google Play to watch it on a Chromecast? Right now, the iTunes movie does not give me the option to stream to Chromecast.

Any recommendations welcome.
0
Hi, I'm migrating about 50 users from G Suite to Office 365 Business email. Moving accounts and inboxes also as a one batch go.
Users are already set up in Office, with their default @company.onmicrosoft.com email. Gmail currently uses their own domain as @company.co.uk.
Haven't registered the company.co.uk domain with Office 365 Business yet.
I'm wondering if, as soon as I register the domain and start migrating the users, will they lose access to their @company.co.uk gmail, as Outlook will take over the domain or will they have access on both Gmail and Outlook? I'm only worried, since it's an own domain email.

Summed up: john@company.co.uk is using gmail. I want that email to be in outlook, but afraid, that as Office acquires the company.co.uk domain, and able to use it's email addresses Gmail will lose access. Hope that makes sense.

Thank you.
0
Need a "poor man's" green screen

At the moment, I am stuck. I am all configured for a live webinar using WebinarJam. Now, I find they do not support green screen replacement.

I am looking fo a technical solution, like using GoToWebinar. But, in the short run, is there another possible solution, like finding a professional looking cloth drape to use instead of a green screen?

Thanks.
0
Need to "re-broadcast" the repaired video stream

I am in a major pickle. I finally got a live stream video solution to work (using OBS)  that removes the green screen. But I use WebinarJam for my webinars, and they do not support green screen. They only take the video direct from my Logitech C922.

What can I do?

I feel like I need a setting on OBS to "re-broadcast" the modified video stream. This means that WebinarJam would display the stream, as is, which is the way I want it to look.

Am I making any sense?

What is the purpose of using OBS to modify the live video stream if it can not be used?

WebinarJam also allows YouTube live and Facebook live, which may mean I can use OBS as an input into either of those.

Please let me know your thoughts on the options available to me.

Thanks.
0
Need Green Screen replacement from YouTube or Facebook

I use a service called WebinarJam, but they do not support Green Screen replacement. BUT, they provide three possible input source for the video...

Video Stream Options
As you can see, YourTube live and Facebook live are options.

Does this mean I can use either of these to insert my background image, then use the fixed stream with WebinarJam?

Their support says "WebinarJam does not support Green Screen replacement." But if I give then the video stream from YT or FB, they have no choice.

Am I right or wrong?

Thanks
0
I've been testing Ginger in free mode for a while and they keep bugging me to upgrade (~$59 per year), but I am wonder about alternatives. Rather, I am wonder what you folks consider as the best on-line grammar checker, and why?

I have used Grammarly in the past but I recall that it often missed obvious errors and sometimes made erroneous suggestions. But that was about three years ago. I also know that there are a few other grammar checkers available.

Two Two that I have used are:
- Ginger https://www.gingersoftware.com
- https://www.grammarly.com

Criteria for answering
- Please don't suggest that there is no substitute for understanding English grammar. I know this. But these tools are still great for finding errors when one makes the occasional mistake.
- Please don't suggest the free tools in Microsoft Office. I don't have access to Office.
- I am primarily editing in Google mail and the Google Apps.
- I am only concerned about English grammar checking.

I'll look forward to your comments and suggestions. :)
0
Big Business Goals? Which KPIs Will Help You
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Hello to all,

I'm having trouble connecting a Google Spreadsheet to a local MySql database in one of our offices.
Error displayed by Google is: A connection could not be established with the database, check user password and connection string.

This is the code i'm trying:

   var connectionstring = "jdbc:mysql://public_ip:9002/db_name";
   var conn = Jdbc.getConnection(connectionstring, "user", "password");
   var stmt = conn.createStatement();

Other scenario considerations:
1. The Firewalls incoming 9002 port is being forwarded correctly into the 3306 on the local db server.
2. user and password work fine since Remote Workbench connections are possible.
3. I've even tied up a remote MS Excel sheet to the db and it works with the same url and login information
4. No IP incomming connections are being blocked explicitly, you can call the port from whatever ip you want and you will be redirected to the internal server

Does somebody have any guidance on what to try?
i've been fighting for over a week!

Thanks to all
Eric.
0
Is there a free useful solution for a multi people thread... kind of like a forum that is closed for a certain group.

I want to be able to talk about multi subjects and that if someone new comes in he can easily browse through the subjects and see the comments.

again like a thread or forum.
0
I have a custom domain that I bought from domains.google . I have a python web app in google's  cloud platform app engine. The site is visible via xxxxx... appspot.com.

I tried to setup my custom domain and map it to the web app. I can't seem to get it to work. Below are my current settings. It worked for a few hours then stopped, I assume the  ip addresses changed and broke it.  The following pics are from the custom domain piece of the project and from google's domain management area. Thanks!





0
What options exist for porting a Google Voice phone number over to other services?

A couple of users who I support are interested in doing this and want to find out what other services they can port (transfer) their existing Google voice phone numbers too.
0
Hi - I'm looking for some advice on what options are available to migrate data from Google Drive and Google Photos to Microsoft's OneDrive Personal. Is there a direct migration path? or do I need to download photo's & documents locally then upload to one drive? Are there any recommended utilities that will automate the migration process? I look forward to hearing from you.

Regards
0
I have installed Google voice on my Sprint PCS iPhone X.

Now how can I make my Google Voice number replace my Sprint PCS iPhone X caller ID number so that everytime that I call someone my Google Voice (and not my regular Sprint PCS phone number) will display on all outgoing calls?

Where do I go to enable this setting?

I received the email below on June 1, 2018 and I'm not sure how this affects my Sprint PCS Google voice service:

We are contacting you to let you know that per previous communication, due to upcoming upgrades to Sprint’s network, Sprint will no longer be supporting the Google Voice with Sprint integration. Effective today your Google Voice integration with your Sprint phone number (xxx) xxx-xxxx has been disabled by Sprint.

Effective today:
All outgoing calls (including international calls) and texts will be made through Sprint at Sprint’s calling and texting rates, if applicable.
All new messages, calls, and voicemails sent from your Sprint phone will not be stored in Google Voice. You will still be able to see your messages, voicemail, and call history from before June 1, 2018 in Google Voice on your Sprint device. You can also export this data from your Google Voice account at takeout.google.com.
You won’t be able to use Google Voice-enabled capabilities such as call forwarding, voicemail transcription, spam detection, and other Google Voice features. These capabilities can be enabled from your Sprint device. Click here for more information …
0
Reversing the order of the videos on my YouTube page

I need to change the order that the videos on my YouTube page appear in.

Is this possible?

I see I have no playlists.

If I created one, would that even matter? Or can I make a new playlist the default playlist?
1
Is it possible to generate a list of Google Apps / G-Suite users with their account creation dates and last logins?  I can't seem to find the account creation date property anywhere that I could include in any kind of user list/report.
0
When completing a Google form, users have to select "Submit" twice for a total of THREE clicks. Once for "Review and Submit" at the end of the three questions on the form and again on the following screen that says "Submit response?
Your username ([email address]) and responses will be recorded when you submit this form."  Why do users have submit the form with two clicks? Why doesn't one button suffice? This is presented as the final submit button for users.This is presented at the end of the Google form's 3 questions.
I think it's because I have embedded the form in an email vs having the user open the Google form to complete.
Google-form-ARE-YOU-SURE-first-submi.jpg
0
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

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

I have installed fail2ban on an Amazon Linux 2 instance running Apache 2.4.  I can't start it up because I am using postfix and the default mta is sendmail.  I don't have sendmail installed and I don't want it.

I use google apps for my smtp server.

How can I change over to postfix or use google apps for my fail2ban mail option?

Thanks,
0
Question about scheduling an alarm or alert of some kind that would help me keep focused and on task. This may sound simplistic but I have some focus issues and looking toward ways to keep on track. Searching for an audible solution but there may be other solutions I am not familiar with. I was thinking a beep or .wav or mp3 clip that would remind me to check in on my task list for the day. Back in my day I remember the radio DJ's used to send a message out ....."Turn so you won't burn!".... every half hour of the day. Bottom and top of every hour. So you knew the time and you knew 30 minutes have passed.

I have brand new to me (Samsung Galaxy S6) A spare phone I bought in a deal from AT&T. I know how to create an event and noticed that loaded up my calendar view so it is almost worthless from the number of blocked out time slots. Is there a simple way to do this on this phone or an APP that might be perfect for what I need. I also take a medication to help me focus and other time based events like everyone else does who tries to plan or schedule anything.

Any thoughts or advice appreciated.
0
Chrome takes between 6-12 seconds to load if it even loads, sometimes it errors out.  The internet works fine for other computers, and even other browsers on the same computer.
The PC is running windows 10, latest update, and also the newest update with Chrome.

I have tried to uninstall, reboot and reinstall chrome, and same issue.
I have ran CCleaner and cleaned up the PC, same problem perists.
I have stopped the cryptosvc service, and that was stopped, it seemed to work fine, but I need this service started because my AV program relies on this service.

I have come across these two sites that looks like this issue is a bug.  What puzzles me is that other computers are running on the newest version of the OS and Chrome, and don't have this issue.  Even with my own PC, it works fine, so far, I just have one computer with this issue.

https://bugs.chromium.org/p/chromium/issues/detail?id=838707
https://productforums.google.com/forum/#!msg/chrome/s5S1uPI0kMc/PVBgVbx6DAAJ

When starting chrome, in the status bar, it just says "establishing secure connection"

Any idea's how to resolve this issue?
0
I want to share a Google Sheet with many people (who may not even have a Google account) but I don't want the values they enter to be seen by others. Those cell values are their own personal information.....
The sheet / template and its formulas can be public.
I an familiar with templates in Excel.... just not in Google Sheets
0
I have a Galaxy Note5 that I use as an auxiliary device.  In other words it does not have a SIM card in it.  It only connects to the internet via Wi-Fi.

I would like to have Google Voice to be the default dialer for this device.  I tried to research this issue a few times but I can't seen to figure it out.

The Note5 is running Android version 7.0
0
Hi,

I briefly had a look at a setup with Hisband wife using google drive and I’m a little confused as I havnt used it beofre.

All folders have a correction mark beside them so they look synced and in order in the PC

I created a test.doc and it says synchronized but seems to have deleted the temp doc $est.doc of the same time 4 Mins ago

Is this normal ?

I wasn’t able to go to the go to the cloud to verify it was there as we didn’t log into the husbands google drive itself
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.