Create a Google Apps Script for Google Slides

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

I need to add some interactive functionality to a Google Slides presentation using Apps Script.

Here's the ideal setup:

1) the Google Slides document will be displayed on an iPhone, as well as Android phone. We will edit it on a desktop. We will wirelessly broadcast it to a screen most likely using a Chromecast device. Because it is a Google Slides document, we need to ensure that any changes we make will update the document on the user's device when they open the file.

2) There would be one Google Slides file, not multiple files.

3) On the first page, the user has several dropdowns, then a submit button. As an example, "what type of fruit do you like?" with the responses being "apples" and "oranges". Another would say "what country are you in?" The responses would say "US" and "Canada".

3a) is it possible that this form would be on a web page, such as in Chrome or Firefox, that then calls the Slides document to be opened?

4) A third dropdown would be contingent on the responses to the other. For example, if you choose "apples", the next dropdown would say "what type of apples?" and show types of apples. If you say "oranges", the second dropdown would say "what type of oranges?" and show types of oranges. If you switch the first response from apples to oranges, the contingent dropdown would change accordingly.

5) There would need to be validation to ensure they answered all three questions. If anything is left blank, give an error message, and display in the dropdowns what has already been selected so they don't need to select it again

6) The presentation would advance to the title page and beyond, with various slides appearing or being hidden, depending on the responses. If you chose apples, then all slides about oranges would be hidden when you run the presentation.

6) The slides would be named, so the script would call the names and not just Slide1, Slide2, etc. We want to be able to re-order them, plus add new slides and name them as we see fit, assuming our naming would fit the proper naming format required by the script.

I don't need you to create any actual content about apples or oranges - just an example document with what I described, with a slide containing the questions, several dummy slides about apples, several dummy slides about oranges, then a final slide that says 'Thank You; and would be shown regardless of your response. I will take it from there. In case you're wondering, the final product we create will have nothing to do with apples or oranges. I am trying to give an example that is very basic and easy to understand.

7) The logic of the script would be something like what I am showing below. This is just an example of the the logic, not the actual syntax (I recognize it wouldn't necessarily be in PHP). I would expect you to put it in the correct syntax for Google Apps Script:

if ([login to view URL] == true) {

if ($_POST[desired_fruit] == "")

$error_display = "You must enter the desired fruit";

if ($_POST[fruit_type] == "")

$error_display = "You must enter the fruit type";

if ($_POST[location] == "")

$error_display = "You must enter the location";

if ($error_display == "") {

if (desired_fruit == “apple”) {

[login to view URL] = false;

[login to view URL] = false;

[login to view URL] = false;

[login to view URL] = false;

if (location_id == “US”) {

[login to view URL] = false;

[login to view URL] = false;

if (fruit_type == “macintosh”) {

[login to view URL] = true;

[login to view URL] = false;

[login to view URL] = false;

}

if (fruit_type == “green”) {

[login to view URL] = false;

[login to view URL] = true;

[login to view URL] = false;

}

...

} else {

...

}

...

}

}

and so forth.

JavaScript

Project ID: #18720272

About the project

3 proposals Remote project Active 5 years ago

3 freelancers are bidding on average $154 for this job

letshappy

hello, i will develop an google apps script for google sliders as you need i read the task carefully ...........................

$208 USD in 4 days
(29 Reviews)
5.5
irfanalam123

Proficient knowledge of Google Apps Script, Google Slides API, Google Forms API and others required API to complete this task within 2 days. We can even accomplish this without using Forms but using other even better m More

$100 USD in 2 days
(1 Review)
0.7