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 Experts


Could you point which Google tool is needed to obtain the result accordingly with the image bellow?

I understand that there must be a payment for the image to look like this, however I did not identify the characteristic "Add" icons (f.e.)

To reach the advertisement, the type of service and the name of the street was informed as shown in the image.

img001
Thanks in advance!
0
Hello all,

I am importing data from another sheet, but I need to filter so that only the last 60 days of data appear.

First, I have this formula:
=ARRAYFORMULA(QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/[sheet URL]","Form Responses 1!A:K"),"select Col1, Col10, Col11 where Col1 > date '2019-12-21'"))

How do I change this formula to display only the last 60 days, rather than using a hard coded date?
I tried and failed to replace the hard coded date with variations of date() and - 60.

 

Thank you
0
I have some questions related to Google Chrome.1.Why is Chrome managed by my organization. I am the only person who uses it for personal use. How can I change that?
2.Google Drive, is it supposed to be located in my user's folder? I had seen a tutorial showing that it is located in user's folder. The only place I see it is in the Bookmarks Bar in Chrome on the far left hand side in the square icon that is called Apps. Also, it is located in the send to context menu as well. How can it be added to the user's folder if that where it belongs and I don't mean as a shortcut either. FINAL question-when I right click on a file to be sent to Google drive then select Google Drive from the send to context menu "NOTHING happens, it does not get sent to the Google Drive. On the other hand I am able to upload it directly from Google Drive but that's not what I am attempting to accomplish.
Please help me figure out solutions to these questions.
Thank you,
Basem Khawaja


Chrome Managed by my Organization
0
I want to change the street photo of our congregation.

I found this link: https://support.google.com/maps/answer/2622947?co=GENIE.Platform%3DDesktop&hl=en

I went to Google Maps with the address. Under the "Add a photo" section, I cannot find any place on the map page to do that.

In one sense I think that is good, as we don't want just anyone changing our photo. But we would like to do it.

Any suggestions?

Thanks
0
This past week i published my first app to the Google Play Store.  The app is now live and available for use.  

Now i would like to make two updates.  First, I'd like to change the contact email address associated with the app and second I want to remove one of the photos attached to the description.  Do i need to package up and resubmit again or is there a way to edit the live app profile?
0
Hello all,

I am using IMPORTRANGE to bring in an array of values from another sheet. The problem is that some of the cells include text that I need to filter out.

=IMPORTRANGE("https://docs.google.com/spreadsheets/[removed]","Form Responses 1!D2:H20")
brings in some cells like: '8 (Great!)', but I need to remove the non numeric part.

I could make a separate column and use the formula: =VALUE(REGEXREPLACE(TO_TEXT(A3), "\D+", "")), but this will take up a lot more cells.

Is there a better way to display only the numeric values imported via IMPORTRANGE?


Thank you :)
0
Hello, i create a custom formula within Google Script. Then i call the script from my Worksheet.

How to debug the function as breakpoint, logger object is not functioning

Thanks
0
I found a product to do SMS Group Texting from a google spreadsheet. This looked like a perfect solution for me, but I cannot get this product to work

It did correct the number format when I pasted my list of numbers the number into the sheet.
https://gsuite.google.com/marketplace/app/text_gblaster_sms_texting/360232482012

This comes up on the side of the sheet also and looks potentially useful, but the links seem to point to a sheet that is blank and I don't see a Facebook page where I can ask questions or get any assistance. https://www.screencast.com/t/XhsTBvs1C7.

Assistance is greatly appreciated.
0
Hi.
I like to download historical stock data to Google spread but I can not find a way to do it.
I can only download previous day CLOSE price. The high, low price is today's price.
Can you help me ?
GOOGLE-HISTORY.png
0
Hi Google Forms Experts,

I’ve just started using Google Forms today, and I’d like to create a registration form which asks for:
a)      the name of the primary registrant,
b)      the number of registrants in a drop-down (let’s limit it to 10 max), and
c)      the names for each additional (i.e. non-primary) registrant.

So far I’ve come up with these (less-than-ideal) methods:

Method 1: Cram all additional names into a Paragraph question.
I store all those additional registrant names in a single question (a Paragraph), and ask the user to type one person’s name per line.
Advantages: It’s simple to create, and means the user can put everything into only 1 section (page).
Disadvantages: This is not as structured as I’d like, makes it hard for me to validate names and impossible for me to make sure the number of names entered tallies with the number specified, and of course it puts all those names into a single cell in the linked spreadsheet.  And if I want to force first name and surname into different fields, this Paragraph method ain’t gonna work.  

Method 2: Conditional logic with different sections.
Section 1 asks for the primary registrant name and number of registrants.  I then add one section for each additional name, and call the sections “2nd registrant name”, “3rd registrant name”, etc.  On the “Number or registrants” question, I select “Go to section based on answer”, and have the:
-      “1” person option go to “Submit form”,
-      “2” person option go to the “10th …
0
Good Evening Experts,

I am having an issue building out a spreadsheet to solve a tiered mileage equation. I have tried using IF statements, SUMPRODUCT and vlookup statements but not having much luck. I tried "JE McGimpsey's" variable rate equation, but didn't have success.Spreadsheet Example
The pricing structure is tired so that the first mile is billed at a higher rate, than the next ten miles are at a different rate, continuing so-on and so-on. I have included a mockup of what I am trying to accomplish with a few manually solved routes. I need to figure out a way to automate the calculations for A,B,C,D,E,F

Thanks for any help or insights you might have.
0
My goal is to create a Google document that is automatically populated based on user selections from a <Google form, spreadsheet, any Google G Suite product>.

Here's the use case:
I have a Business Requirements Document template, but users don't need every single section each time they use the template. What I'd like to offer them is a form/method for them to check the items they need and have a document populated with those sections vs. opening a template and deleting the sections they don't need. I've attached an example of my Business Requirements Document, and would like to keep the template formats in tact, too.
TEMPLATE----Measurement-Plan.docx
0
It is super easy to schedule a calendar event and invite multiple people from my google contacts using calendar.google.com.

However, notifications of the event only occur by email and not by SMS.

Since I also use labels to group contacts, thereby making google contacts and absolute necessity, this is a problem.

I would be encouraged to hear if anyone has a solution to using Google calendar that would allow Google calendar event notifications to be delivered both via email and via SMS?

Assistance is greatly appreciated.
0
Hi,

Our company has very important spreadsheets created in Google Sheets that they would like to protect.

My employer wants the ability to password protect these Google Sheet spreadsheets.

Each individual sheet has sensitive information.

Google accounts should be secure but in case anyone got into it, they would like to know of a way to protect these spreadsheets for added security.

How would we do this?

Thanks,
Robbie
0
Google's contact labels and details are changing on the desktop but not on my android phone.

I thought I had everything going to Google but apparently something isn't set up quite right.  

Assistance is greatly appreciated.
0
Hi,

Does anyone know if it is possible to mass delete events in your calendar without having to run and scripts or code?

Problem: I have several recurring events in a specific work calendar that don't happen on a weekly basis, which is normal for the business, and I would like to be able to use my mouse to highlight all of them and then press delete... however instead I have to right click on each one and press delete which is really time consuming.
0
I have two gmail accounts designated to my personal account. These two accounts (pack1928.popcorn1@gmail.com) & (pack1928.popcorn2@gmail.com) were created and used years ago (maybe 5 years ago). I want to disassociate with these accounts. I do not remember the current password. I have tried to follow the google instructions about logging into the accounts to do this trough the settings, but when I try to recover the account with a new password I get the messages:
"Unfortunately Google couldn't verify that pack1928.popcorn1@gmail.com belongs to you."
and
"Unfortunately Google couldn't verify that pack1928.popcorn2@gmail.com belongs to you."
How do I get rid of these accounts once and for all?
0
do u know sample code google auto complete address that I can fill the address into different text box like address, city, state, and zip?
0
I've adjusted plenty of settings but I still receive the following message when attempting add a calendar event and authenticating to Google calendar.

Enable cookies
Make sure your cookies are enabled. To enable cookies, follow these browser-specific instructions.

Clear cache and cookies
If you have cookies enabled but are still having trouble, clear your browser's cache and cookies.

Adjust your privacy settings
If clearing your cache and cookies doesn't resolve the problem, try adjusting your browser's privacy settings. If your settings are on high, manually add www.google.com to your list of allowed sites. Learn more

Brave browser cookies
0
What is wrong with this search string on amazon.com?

The below syntax returns standard hdmi cables as opposed to mini-hdmi

1. The search string mini-hdmi to usb-c does not work.
2. The search string "mini-hdmi"+to+"usb-c" does not work.
0
I'm planning to use the export to Google CSV file to get contacts out of google for manipulating and then re-importing them.

The trouble I see currently is that the photos won't be likely to re-populate.

Does anyone have a tested solution for this?

Assistance is greatly appreciated.
0
I would like to make use of old label sheets in Google Documents.
A good example might be a sheet of old Avery Diskette Labels #6490.
These labels are a good size and I would like to be able to use them.
However, I don't want to tie this work to a single computer and would, therefore, prefer to do this in a Google Document.
The letter-sized pages come with labels organized in three (3) columns, with five (5) labels per column, for a total of fifteen (15) labels per page.

The side borders before the labels begin are about 1/16 of an inch.
The top and bottom borders before the labels begin are about 1/2 of an inch.
The separation between the first row and the second row and between the second row and the third row is 1/6 of an inch just like the side borders.

I have begun this google document where I am trying to come up with a template for these labels.
https://docs.google.com/document/d/1yyONSaEf8E965bATZY8uykywJ42LOzIOse9eVGJS8zE/edit?usp=sharing

Assistance is greatly appreciated.
0
Fill Google Spreadsheet with data from Google Contacts

My Google Contacts database is potentially one of the most valuable information resources that I have and I would like to be able to sort and filter it more efficiently.  The built-in options at contacts.google.com just don't do enough and exporting and importing is very old-school.

I need to be able to sort and filter them using a Google Spreadsheet instead of being relegated to the minimal options provided within the context of the Google Contacts page itself.  

One option might be to use the Google scripting area under the Tools menu item within the spreadsheet. Assistance is greatly appreciated.

I would greatly appreciate any assistance in resolving this challenge and I have begun a sheet below to give us a point of reference as I try to find a solution to implement here.

https://docs.google.com/spreadsheets/d/14OH97o7dSVa5eC4WXjwHKdzmsJEinQLrVldaqOF-MwE/edit#gid=1636004216
0
Can a forward be placed on a Gmail account which has been moved the the Vault? (Leaver)

We have many cases raised for a shared mailbox type setup for a leaver's mailbox so that historical email and forwarding can be put in place for another staff member.
0
Gboard for Android and Windows desktop

I absolutely love Gboard. It works so seamlessly for voice-to-text, and for allowing you to re-use text clippings. The problem is that it only seems to be available for Android and iOS. I don't think there is a way to use it in Windows? This is disappointing, to say the least. Any assistance in finding some way to cross-platform this ability would be greatly appreciated.
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.