Google slides for non gmail accounts … can they copy the presentation and edit?

So essentially, I have spent most of the summer creating a digital notebook for my students. I am using google slides for this presentation and want to send the presentation to my students, have them create their own copy and then be able to edit their copy and do their work in the slides. Then, at the end of the week, send me a link to their work and I can look at it, edit it and grade it. Is this possible if the student does not have a gmail account?? Thank you!!!!

Go to Source
Author: Rachel

How to contact Google G Suite without having an account?

I obtained a mail from gsuite-noreply@google.com about inactive classic sites. I do not know about which site they are talking.

On their support page, one needs to connect using a G Suite account in order to contact them, but I think I do not have such an account.

Does somebody if they can be contacted without G Suite account?

[Tell me if this question is inappropriate.]

Go to Source
Author: Karlo

Export Multiple Google Calendars to Google Sheets

I have several Google Calendars I’m subscribed to, one for each of my sales and logistics team members. I want to grab the events from each calendar for both today and tomorrow and put them into my main Logistics spreadsheet. I’m stuck on the “get all the events” part; I’m pretty sure I can get the right info to the cells I want them to once I’ve figured this out.

Here’s what I have so far, which is my newbie attempt to go through each calendar and grab the events. I’m getting the error that the parameters for CalendarApp.Calendar.getEventsForDay are incorrect.

Exception: The parameters (number) don’t match the method signature for CalendarApp.Calendar.getEventsForDay.
at calendarGrabTodayTomorrow(Code:85:28)

  var calendars = CalendarApp.getAllCalendars();
  var date = new Date();
  var dateTom = (date.getDate()+1);
    for (var i=0; i < calendars.length; i++) {
    var curCal = calendars[i];
    var eventsTod = curCal.getEventsForDay(date);
    var eventsTom = curCal.getEventsForDay(dateTom);
  Logger.log(eventsTod);
    Logger.log(eventsTom);}
}

Any help on this is greatly appreciated!

Go to Source
Author: Jeff Gibson

How to filter out empty cells in Google Sheets With Query & Importrange

I am trying to use this formula but it’s not working. Do you hava an idea why?

QUERY(IMPORTRANGE(“IMPORTEDDATASHEET”;”06_20!M:AJ”);”SELECT SUM(Col17) WHERE Col1 = ‘Company Name’ AND Col23 <> ‘ ‘ label SUM(Col17) ””)
I want to filter by a specific company name in Col1 and filter out all empty cells in Col23 and then sum up col 17.

I also tried IS NOT NULL and != ‘ ‘ instead of <> ‘ ‘, it didn’t work either.

Go to Source
Author: N.K.

Is it possible to intentionally cause Google and AWS to block my IP address?

It may sound a little weird. I am validating one of my possible research ideas where I want to see if I can intentionally and effectively make websites such as Google and AWS to block my IP. By “block”, I mean it won’t let me directly access the service, but not necessarily blacklist my IP. For example, the website will ask me to solve a ReCaptcha before I can access its service, instead of telling me service is unavailable.

I know if I send a large number of requests in a short time (i.e., using DoS) it is very likely that I can make it work, but I wonder if there is any other “efficient” way to make it happen. From what I have found here: https://support.google.com/websearch/thread/2596872?hl=en, it mentioned Google may block the following:

  • Sending searches from a robot, computer program, automated service, or search scraper
  • Using software that sends searches to Google to see how a website or webpage ranks on Google
  • Using an app, program or script to perform a large number of searches in a short time

Is it possible that I mimic such a request and cause myself to be blocked in just one or a few requests?

Go to Source
Author: dovod74538

Progress bar with Bar Chart in Google Sheets

I have a 2 tasks that I would like to keep track of my progress in google sheets with a percentage bar chart.

Google charts is not allowing me to separate the data into two series. They have the same color. I’d like to color them differently. How can I accomplish that? Further, I’d like for 100% to show up for the last tick mark. I added 1 for the max value, but that only increased the scale and did not place a tick mark.

How do I color the series differently (both data points are called ‘Bar 1’)?

How do I add ‘100%’ as a tick mark?

The data range is S1:U2. There is nothing in the S column.

Here’s a snapshot of my chart and the data in google sheets.
enter image description here

Go to Source
Author: K. Shores

Safe to sell used Android-phone without doing factory reset

I’ve got an Android One-unit with Android 10. However it refuses to boot and I’ve decided to get rid of it and I think I get get some money by selling a broken phone online. However since it refuses to boot I can not perform a factory reset or similair procedures. Is is safe to sell it or can personal data get in the wrong hands?

Some information:

  • I have not changed the encryption settings, so I think it’s encrypted by default
  • I got two factor authentication turned on on my Google account and removed the device from my “trusted devices”
  • I have screen-lock turned on with pattern needed to unlock it.

Go to Source
Author: Cleared

Frontend/Backend Integration: Wait for a Google Cloud function to run and then return result

I am trying to create a tool that receives a user input on the front end, uses that input to run a Google Cloud function and then returns a link to the output, hosted on Google cloud as well.

How can you give updates that a process is being performed, and update the page when it is finished?

Go to Source
Author: Lance Johnson