Google Apps

2K

Solutions

64

Articles & Videos

3K

Contributors

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,

I sometimes use google sheets as a simple database, and would like the option to edit in form view.

I expect a crude setup is possible using google scripts, but I have not yet delved into this as I'm new to google scripting.  I would like to get some tips on getting this up & running. There maybe a few steps involved in which case I'll post aside questions if needed.

Here is a template which I'll aim to get working so if successful this could be the answer:

short url: bit.do/googlesheetformedit
redirects to: https://docs.google.com/spreadsheets/d/1vyC3yaB1cKegdRHeXeNvgr8N06S7OzUw2EPnY3fEOVE

2 main stages:
1. generate the query output
2. create a trigger to edit source data when the column "value" is changed

There may already be a google app that does this.

Thanks
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: 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!

3
 
LVL 17

Expert Comment

by:Lucas Bishop
I've had a similar issue with a Chrome extension in the past.
1
 
LVL 6

Expert Comment

by:Nicholas
Maybe Google should install Windows Defender...
1
Sometime ago we had hired a company to develop an app for us, this company completed the task and uploaded the app into Google Play for us. Today this company is no longer inexistence and we are not able to locate the programmers / person in charge.

We are now having problem to remove this application from Google Play, Google Play will not allow us to remove this item as we do not have the necessary to do so. Is there another way? What can we do?

Cheers
DL
0
I am missing the understanding what google apps sync tool helps using outlook with gmail. since outlook without this tool syncs with gmail.
Please advice
0
Dear Google Calendar Web Client,

I really like that you provide notifications to remind me when I've got a meeting in 10 minutes. I really don't like when you seize control of my browser and switch what tab I'm on to give me this reminder, specially when I'm in the middle of typing something and suddenly I've got a half formed sentence on some other window somewhere and I need to spend the next 5 minutes getting back to it and finishing my thought...

Why can't you offer up a browser notification instead?! Or is there a way to have you do that now that I just don't know about?
3
 
LVL 6

Author Comment

by:Brian Matis
OMG! Yes! Thank you Craig! I remember some time long ago looking for something like that and it must not have existed yet... So I've just sort of lived with it being that way. Glad I decided to rant about this ;-)
0
 
LVL 6

Author Comment

by:Brian Matis
Oh, and if you put together an article with a tip about that, I'd totally endorse it to help you get points ;-)
0
When a email account in configured in outlook as POP if two devices want to pick up the mail (from gmail server) only one will get it since on the gmail server its flagged as downloaded once the other device will not download it again.

Is there a way to set that more then one device should get all email from the same account without changing to IMAP?

The reason not to use IMAP since one user drags in to her folders in the account in question email from other accounts and with IMAP everything gets pushed back up the the gmail server and full up the limit of space in this email account.

Will the following be a solution, enable IMAP on the gmail server, and on the outlook side on the device files get dragged in the the account in question set up as POP so it will not push up to the gmail server and changes made in outlook, and the other devices set as IMAP?
Or if on the server IMAP is enabled it does matter how its set in outlook.
an other concern once the device that is set as IMAP will download the email it will get flagged as download the device set as POP will not get the emails?
0
I am using gmail and outlook 2010 as a client.

I IMAP was enabled and I disabled it.

Outlook gave me a msg that IMAP is disabled on the server I should enable it.

I removed this email from the list and re created the account as POP and pointed it to the existing outlook file. outlook now could pick up mail, but still get the msg IMAP is disabled on the server I should enable it..

But in outlook when I point on the inbox of this address I get a msg Cannot display the folder. Microsoft Outlook cannot access the specified folder location. The information store could not be opened. also when I click on properties I get a msg cannot display folder properties the folder may have been deleted or the server where the folder is stored may have been deleted.
0
I'm migrating Outlook 2010 users to Outlook 2016 (Windows 7 to Windows 10).  We're also using Google Apps Sync. I'm having trouble getting the autocomplete to work.  I've tried importing as outlined here..

https://support.microsoft.com/en-us/help/2806550/how-to-import-.nk2-files-into-outlook-2013-or-outlook-2016

I've also tried renaming the autocomplete to the Outlook 2016 'stream...' file that's suggested here...  

https://blog.zensoftware.co.uk/2014/05/29/how-to-copy-the-auto-complete-information-to-a-new-outlook-profile/

Neither have worked.

Anyone have any other suggestions?

Thanks,

Steve
0
I saw a 360 degree camera the other day and thought they might come in handy for me. Maybe I wold use it while I am giving a virtual tour, for example.

What kinds of things are they good for? And bad for?

They seem impossible to edit...

Is it so the viewer can have a "Google Earth" kind of sensation?

Examples?

Thanks.
1
Sometimes I am emailed audio and video files.  To listen to them, I have to download them to my desktop then open them up in Windows Media Player.  In the past, the files used to just play through the gmail client.  What apps should I try to use that are being suggested to me?

Basically, I don't want to have to download the files to my desktop anymore because they're already in my email, you know?

They are .wav files if that makes a difference.

e.g.

Screenshot_4.png
0
On Demand Webinar: Networking for the Cloud Era
LVL 8
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Will/can a new custom Google Apps attribute appear in the Google UI?

Thank you in advance!
0
Hi

Two users

User1@whatever.com

User2@whatever.com

User1 can't email user2 in Outlook

All else working fine

Pop and imap is enabled - which is possible in gmail

Two PCs pop accounts

iPhones - imap

Why can't these users on same .com email each other

Both accounts are white listed in outlook
No odd tools / rules
0
Hello,

I am looking for some good examples for G Suite organizational structure examples for a school from kinder to high school. This is going to be a big project and I would like to plan and cover the structure and training.  

I appreciate your help and support.

nimdatx
1
I'm currently in the process of migrating a client from Exchange 2010 to Google Apps for Work. I'm using the google migration tool on the admin console. However they require and admin or a service account with a mailbox that has impersonation rights configured. For the life of me I don't seem to be able to get this to work on the exchange console. I have followed technet articles with powershell but it's not working. The. Account I'm using is the administrator account which has a mailbox on the exchange server, but I don't know how to set up impersonation rights for this account. Is powershell the only way to do this ?
0
I recently discovered a Google account that was registered under my telephone number but I deafly did not create. There was a security email attached to the Gmail account but I'm having a hard time getting additional information on that email does anybody know of a way to search additional info using an email address?
0
Hi,

 I'm looking for an example in how to access google calendar api v3 with a service account and to add/update/delete calendar events for the different users (asp.net)

 Can someone help me?

Thanks!
0
I created a powerpoint with graphs that has data inputted directly in powerpoint. I have to upload and share this powerpoint with another person through Google Drive. I have a MacBook and the the other person (let's call him B) has a Microsoft. B can download the file from Google Drive and edit the data and graphs. However when B uploads it back onto Google Drive and I download the file, I am no longer able to edit the data. The graphs in the powerpoint returns to me as a picture.

The file I download from them is in .pptx form. We both have Powerpoint 2016.

Please help.
0
Am trying to set up my icloud email account on an Android phone (Doro 8030). I have carefully followed all the instructions in setting it up. As follows:
 
User name (excluding the '@icloud.com part .  Email address and Password.   Incoming Server: imap:mail.me.com. Security Type SSL, Server Port: 993.  Outgoing Server: smtp.mail.me.com . Security Type SSL (I have also tried STARTTLS).  Server Port: 587.

 However when I finally press 'Confirm' I get the following Message: 'Could not connect to email server, please check your email settings. '
I cannot get any further than this.
0
Hi,

We need to setup the Cisco 3802i Access Points access point along with 802.1X authentication with Radius server, it will be good if we can authenticate the user with google apps account.

Regards,
Naresh
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!

i have a US samsung android phone bought from verizon with a local malaysian celcom SIM card.  I updated my google play to indicate that i am in Malaysia. my friend is having the same issue with another samsung phone model also US fomer verizon phone with a celcom SIM.  

But i'm getting error messages that certain malaysian apps like yonder are not available based on my country.  some of them don't even appear for me to click on. the sim card vendor tech support offers no advice.

is there somewhere else i need to change my country settings?

thx
0
How to define the SMTP OAuth2 for Gmail on an Android 5.1 phone?

On my Windows 10 Phone I have the definition for SMTP like this:

-> smtpa.xxxxxx.yy:465:1

on which the digit 1 means -> SSL/TLS -> regular password

On the Android 5.1 phone for Gmail I should be using something like that, but can't figure what should be the definition in full for OAuth2, for example

-> smtp.gmail.com:465:z

on which the digit z should be meaning -> SSL/TLS -> OAuth2

or, am I on some wrong direction with this?

Anyway, the Gmail account do not send any mails on this phone with several different alternatives on this on several trials ...

Please, help, if there is a solution for this.
0
Dear All, we are using Gmail for our company (500 users) and prepare to switch to our own Exchange mail server 2016. We would like to know if there is a tool that can export Gmail data of all users to PST files, so that we can export them to our new Exchange server.

One solution is install MS Outlook on users'PC, synchronize the data and export PST files, but most of users here use Gmail web interfaces. And follow this task manually for each user is a disaster for Helpdesk Team. Assume that we do not have Active Directory.

Many thanks, Zealots!
0
I am not able to start page numbering from the first page in my Google docs, it starts on the second page.  How can I correct this as I see no option to do so?

Also how do I centralise the page numbering in the footer rather than it appearing in the lower right of the footer?
0
I'm an iphone user. I have only had iphones. I currently have the iphone 6 plus.
I have AT & T as my service provider.

I was thinking of getting the Samsung galaxy S8.
I want to have both phones.
I still want to keep my iphone.

I never had an android phone so was I wondering the following.

Is it possible if I own both phones to use both phones with my current AT & T service.

What I mean is,  can I use my iPhone on Monday, Wednesday and Fridays.
Then on Tuesday and Thursdays take the sim card out of my iphone and put it in the galaxy s8 and then use that phone on these days?

Will that work?

Or

Is there some other way that I can do this like with some adapter or something?

Has anyone does this before?
0
I have used Python, Natural Language Processing and web scraping technology to do some deep mining of Google's vast warehouses of articles on the web.

Is what I described considered artificial intelligence?

Or, in order to satisfy the requirement of AI must that model also automatically adjust it's algorithms based on the results of the searches? In my case, the adjustments were manual.

Curious.

Thanks.
1

Google Apps

2K

Solutions

64

Articles & Videos

3K

Contributors

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.