Advertisement
Guest User

Create and Run Polls in Google Slides using Google Forms & Google Sheets

a guest
May 30th, 2022
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function createTrigger() {
  2.   var form = FormApp.openById('FORM-ID'); // Enter your Google Forms ID here
  3.   ScriptApp.newTrigger('updateSlidesChart')
  4.       .forForm(form)
  5.       .onFormSubmit()
  6.       .create();
  7. }
  8.  
  9. function updateSlidesChart(){
  10.   var slidesId = "SLIDE-ID"; // Enter your Google Slides ID here
  11.  
  12.   SlidesApp.openById(slidesId).getSlides()
  13.   .forEach(function(slide) {
  14.     slide.getSheetsCharts().forEach(function(chart) {
  15.       chart.refresh();
  16.     });
  17.   });
  18. }
  19.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement