Questions tagged [google-apps]
For questions about specific features of Google web applications for Google Apps accounts. G Suite (aka Google Suite) is the new name for Google Apps. It is a suite of products for business clients of Google. Do not use this tag for general Google applications.
0
votes
0answers
6 views
How can I prevent users from “resolving” comments in Google apps?
I would like to give users the chance to comment on a Google doc but not to resolve comments I or other editors made on it. But if I invite a user in "comment" mode it seems they can resolve comments ...
0
votes
0answers
10 views
How do I give write only access to a Google TeamDrive subfolder
I setup a TeamDrive with sub-folders (handins and handouts). I want people to be able to write to the handins folder but not view, and view and edit in the handouts folder.
0
votes
0answers
17 views
unique numbers based on respondent's answers
I am managing a group of participants (example: doctors, nurses,etc) in filling the form, each participant chooses an option according to his goup (doctor, nurse, etc) i want different sets of unique ...
0
votes
0answers
14 views
Is it possible for a Google App Script to convert a file in the cloud?
Is it possible for a Google App Script to take a file from Google Drive, such as a PDF, video, image or .rar file, perform a conversion to it, to convert it to another format, then upload the ...
1
vote
0answers
49 views
How to choose the appearance of the Gmail app? [migrated]
In Android, Gmail released an update, and it asked me for Default, Comfortable or Compact appearance.
I chose the Default, ofc I don't like it, I miss the old red bar already..
Now I want to try the ...
0
votes
0answers
74 views
Upload from URL (on Google Sheet) to directly in Google Drive
I have a google sheet on which links are generating (by calculation) for downloading / uploading in G-Drive.
I want when links are generated, I can upload file (from generated link) to directly in my ...
0
votes
1answer
43 views
Translate UrlFetchApp Response HTML To Google Sheet
I'm new to working with APIs/CURL and trying to figure out how to get a response (not response code) into a sheet. Here's my code:
function myFunction() {
var url = "https://platform.quip.com/1/...
0
votes
1answer
18 views
Unable to share YouTube videos to groups of users
We have a Google G Suite Basic account (company). I would like to share some videos to a group of users (a subset of domain accounts). Although I can share with individual users, there seems to be no ...
0
votes
0answers
48 views
Recovering my Google account with out a recovery email or phone number [duplicate]
Someone hacked my password and changed it. I have been using the same password for years and I need help getting my account back. You said you would email me back but I have not received any response ...
1
vote
1answer
61 views
Is it possible to set an account wide auto responder in Google Apps for Business (G Suite) Gmail?
Is it possible to set a company wide auto responder in Google apps for business Gmail?
For instance if the office is closed for a set date range I would like to set an auto responder for all emails, ...
0
votes
0answers
24 views
How to manually nest block quotes in Gmail in single consolidated reply to multiple different-subject emails, as if emails were part of same thread?
Someone emailed me multiple times using different subjects. In chronological order, let's refer to them as Email1, Email2, and Email3. If I reply to Email3, Gmail will automatically put Email3's body ...
0
votes
0answers
15 views
In Google Docs, how do I make every paragraph have its own #heading tag in its URL without using a Style?
I have some documents in which every paragraph has its own #heading URL tag, even if it is Normal Text (no Style applied), and it helps a lot to externally refer to a specific part of the document, ...
-1
votes
1answer
35 views
Google Script Editor apply to all sheets except 1st, 2nd and 3rd sheet [duplicate]
Currently this code is only applied to the sheet called "Name" I wanted applied to all except for 3 sheets (Template,Summary and Count):
function EqualValue() {
var ss = SpreadsheetApp....
0
votes
0answers
30 views
My Chrome account isn't my primary email
I've been using Chrome synced with my personal email for some time. All of my Chrome settings, bookmarks, history, etc. are on there. In practice I use my school email a lot more often (I use my ...
0
votes
1answer
118 views
Vlookup using Regex Extract - Google Sheets
I trying to do insert an image into a cell in google sheets.
I'm using vlookup and regex extract to lookup columns to retrieve the image URL for the IMAGE function in google sheets.
However one of ...
0
votes
0answers
88 views
Removing Styles In Google Docs?
I'm working on a corporate document template and had all of my styles in perfect order until I noticed there was an extra style. I used that style to see where it came from and it added another style. ...
0
votes
2answers
58 views
Migrate from personal Google to GSuite
I’ve been using Gmail for almost 15 years, including many Google products linked to that same account.
I’ve now created a GSuite account, and I want to migrate as much as possible to that new ...
3
votes
1answer
176 views
Can you specify an accout to use with Google's “.new” doc creation URL?
I am usually logged in to multiple Google accounts, and I have been using links like these to create sheets (docs, etc.) in the respective accounts:
https://docs.google.com/spreadsheets**/u/0**/...
1
vote
1answer
280 views
Redirect link to another Google drive video
Is there a way to redirect a link to another video in Google Drive when both are made shareable?
I ask this because I have shared someone a link to an older video and I want them to access the new ...
0
votes
1answer
177 views
Adding extra but non-aliased emails within GSuite
Have setup GSuite to handle emails for a certain domain name and have also added aliases via: Google Admin -> Users -> {User} -> User Information -> Email Aliases
However, what if I want to add an ...
0
votes
0answers
35 views
How to migrate and convert an individual Google Suite email account to Office 365 Shared Mailbox?
I'm planning to migrate my company GSuite email account to Office 365. The Office 365 will have the same domain.
My Office 365 subscription is the Business Premium, so we will have shared mailbox for ...
1
vote
0answers
467 views
Google sheets, data validation - how to auto-update the options from a “list in a range”
I have a dropdown in all the cells in a column. Around 150 rows. The four options inside the dropdown come from another tab (sheet), A1 to A4.
This works fine. The options are listed from that tab, ...
0
votes
0answers
7 views
G Suite Calendar Default Working Hours
As a G Suite Administrator, is it possible for me use the G Suite Administration app to set default "working hours" for all users' calendars?
0
votes
0answers
29 views
Script to duplicate rows but continue formulas
I feel like my script is close to the goal, yet so far.
I'd like to take the current row that the user is clicked on, and then insert multiple new rows below the current row, but also continue the ...
0
votes
1answer
2k views
How do I get Gmail to wrap my paragraph text in the default HTML mode?
I've been noticing of late that when I write paragraphs that end up needing word-wrapping as Gmail will make these lines extremely long and cause horizontal scroll bars and hence make having to read ...
0
votes
0answers
64 views
Google App to add a specific forwarding address to a user's Gmail
I wish to create a Google App that will, upon approval by the user, automatically add a specific forwarding address to their Gmail.
When trying to hit the https://www.googleapis.com/gmail/v1/users/...
0
votes
1answer
72 views
Automatically switch to another Google account during work hours?
I have two Google accounts:
personal@gmail.com
business@company.com
Is it possible to automatically change between during working hours?
Example:
Monday to Friday
08:00 - 17:00 -> business@...
0
votes
2answers
225 views
Some saved places are not shown on map
I have saved Dune of Pilat to my custom list:
If I zoom out I see my other bookmark from the same list, but there is no Dune of Pilat mark on map.
Why some bookmarks are visible and some not from ...
0
votes
1answer
24 views
Grab route from other site
Is it possible somehow grab route from others maps and use in my personal map?
For example how to grab map from this ultimatedrives site?
1
vote
1answer
238 views
Default all Google Apps to English
I am currently travelling in Europe and every time I visit Google.com, or any Google Apps, like Sheets or Docs, it defaults to the region locale...
Currently, Google Sheets is showing me all menus in ...
0
votes
0answers
147 views
Google App Script - Append Table to Google Doc
I am having an issue appending a table from a google sheet into a google doc via app script.
if(rtemp == "tblhead")
{
//http://www.googleappsscript.org/home/create-table-in-google-...
0
votes
0answers
174 views
Multi-part data validation and calling formatting in google sheets
I have a couple of questions:
Is it possible to make a conditional formatting or data validation rule such that multiple data types can be input into a cell and the cell will automatically separate ...
0
votes
0answers
186 views
Changing non-primary verified google apps domain in legacy account
We have a 2007 google apps account, where we have multiple verified additional domains on this account, Verified and not Aliases.
One of these web sites is going to be renamed, is there any way i can ...
0
votes
1answer
678 views
Using Google Apps Script add-on without publishing
I've just written my first Apps Script add-on for showing some links in a sidebar of a Docs document.
It looks like the way I created it made it bound to a specific document (the one from which I ...
0
votes
0answers
27 views
How do you filter AdSense ads via Doubleclick for Publishers? (DFP)
I have an AdSense account and a Google DFP account. On my AdSense account I have a screen for filtering out categories of ads that looks like this:
Since DFP ad units have "AdSense inventory settings"...
0
votes
1answer
42 views
Locating third-party Google Docs web apps
I got an e-mail from Google today, warning me to "Remove risky access to your data". According to the security checkup, there are two third-party apps which "have extensive access to [my] personal ...
0
votes
0answers
270 views
G Suite with domain alias causes emails to be considered spam
A legacy G Suite associated to a dead domain has had a new working domain added as an alias. Although Google sets the From as the new domain, how can I stop Google setting the Envelope-from as the old ...
0
votes
1answer
253 views
Google Sheets - Fetch random value from array for each new line created with form
I have a Google Form that fills up a new line with values in Sheet1!, column A and column B.
I am trying to create an =ARRAYFORMULA function in column C, which will populate the C cell in each new ...
-1
votes
2answers
24 views
Can I move only a few accounts to google apps paid plan?
Is it possible to move a few free google accounts using a custom email (eg non gmail) to a paid google app plan whilst leaving all other accounts and emails as they are.
Here’s my scenario
I’ve ...
2
votes
1answer
194 views
Is the new Gmail interface available for all domain accounts?
My domain is on Google since ~2006, the name changed a few times (Google Apps initially, now I think this is G Suite) and I benefit from the free grandfathering program.
I wanted to try the new 2018 ...
2
votes
1answer
1k views
Users can't access Gmail Accounts in G-Suite [closed]
I am the Admin for the G-Suite Account. I am seeing the following in my admin (see below), but new users are getting "We are sorry, but you do not have access to Email. Please contact your domain ...
1
vote
1answer
467 views
Reference entire row data or row-by-value from other sheets
I've a Google Spreadsheet where my first sheet is a Products table.
The columns are SKU, Title, Price, Category, Type
I've some tasks in front of me where I need to create some bundles of different ...
0
votes
1answer
16 views
Google spreadsheet data not showing properly in graphic
I'm using =CONCATENATE('90diaspessoas'!B16," ", TO_TEXT('90diaspessoas'!A16)) to join two cells data into one, then display the data on a graphic.
The following picture shows the result that I'm ...
-1
votes
1answer
34 views
Join two cells data - COCATENATE not working properly
I'm using the following formula to get the data of two cells:
=CONCATENATE(C2,"Dia",E2)
But it's not working properly. Take a look at the screenshots:
It should be returning the Traffic + Date, but ...
-3
votes
1answer
119 views
send mail from google sheet with given range content in simple html format to single email id— kindly help me
.
I have developed the sheet with some condition the email should be lite then only it will deliver to me in short period based on the technical details will take desition on my trade. I have ...
2
votes
1answer
171 views
Use non-linear color scale for conditional formatting in Google Sheets
In Google Sheets, when you use conditional formatting on a column with numeric values, is there a way to place a colored scale that is non-linear, but exponential, for example? I know you could ...
1
vote
1answer
496 views
How can I set up a “public” or a “team” folder in Google Drive (G suite)?
I'd like to have 2 types of folders:
A Public Folder, everyone in the company can see in their "Shared with me" section and edit
Few Team-specific folders, everyone in the team can see and edit (a
...
0
votes
0answers
76 views
Unable to collect email address
The script is unable to extract emails get body /get plain body. Can any one guide?
function getEmails() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var labels = GmailApp.getUserLabels(), ...
4
votes
1answer
263 views
Odd Google Apps Script behavior
I have a Google Apps Script project that I have used for the past few months (successfully) and everything has worked just fine. A few weeks ago, I started getting the "Unable to load files" error ...
1
vote
1answer
2k views
Google drive keyboard shortcuts not working with non-US keyboard
Some important keyboard shortcuts in Google Drive and Google Docs seem not to work on a non-US keyboard, at least on Macs.
For example, I have a French keyboard and in Google Drive, hitting "/" opens ...
