How to attach a link to a shape or text box on Apps Script?

Question

I know how to add a shape to a slide, but I know in Google Slides you are able to link another slide to display once you click on that text box. Is it possible to in App Script create a shape and then attach a link to it?

I have looked at the API documentation and was confused as to if it was possible.

This is a Sheets/Slides Add-On.

What I need to do is when a button is pressed on my Add On menu that I created, is to create a Slide in Google Slides, and use the information from a Sheets. I want to create a TextBox, and have when you click it link to another slide in the Slide Show. I just want it all automated.

If it is possible, how do I apply it to a shape I created?

var elementId = 'MyTextBox_001';
  var pt350 = {
    magnitude: 350,
    unit: 'PT'
  };
  var requests = [{
    createShape: {
      objectId: elementId,
      // tried linkUrl: "link";
      shapeType: 'TEXT_BOX',
      elementProperties: {
        pageObjectId: "slide_001_001",

        size: {
          height: pt350,
          width: pt350
        },
        transform: {
          scaleX: 1,
          scaleY: 1,
          translateX: 350,
          translateY: 100,
          unit: 'PT'
        }
      }
    }
  },

// Insert text into the box, using the supplied element ID.
{
   insertText: {
     objectId: elementId,
     // tried linkUrl: "link";
     insertionIndex: 0,
     text: SpreadsheetApp.getActiveSheet().getRange(3,2).getValue()
    }
 }];

// have tried elementId.setLinkUrl(linkHere);

The code isn't complete and the question hasn't enough details. You are using a project bounded to a spreadsheet, right? Which the shape to add the link? What did you tried so far? — Rubén, Oct 06 '19 at 01:57
! ! ! ! ! ! ! See - Star - Comment in Issue tracker! ! ! ! ! ! ! "Page elements on Slides should be selectable to run scripts like the shapes and images in spreadsheet" https://issuetracker.google.com/issues/186214943 "Presentation mode in slides should fill window not device" https://issuetracker.google.com/issues/186204484 — aNewb, Apr 24 '21 at 23:46

score 2 · Accepted Answer · answered Oct 07 '19 at 14:35

You can create a slide, add a shape and add a link to it using the following code:

  var presentationId =  "<YOUR_PRESENTATION_ID>";
  var newSlideId = Utilities.getUuid();
  var newElementId = Utilities.getUuid();
  var pt350 = {
    magnitude: 350,
    unit: 'PT'
  };
  var requests = [
    {
      createSlide: {
        objectId: newSlideId
      }
    },
    {
      createShape: {
        objectId: newElementId,
        shapeType: 'TEXT_BOX',
        elementProperties: {
          pageObjectId: newSlideId,
          size: {
            height: pt350,
            width: pt350
          },
          transform: {
            scaleX: 1,
            scaleY: 1,
            translateX: 350,
            translateY: 100,
            unit: 'PT'
          }
        }
      }
    },
    {
      insertText: {
        objectId: newElementId,
        insertionIndex: 0,
        text: SpreadsheetApp.getActiveSheet().getRange(3,2).getValue()
      }
    },
    {
      updateShapeProperties: {
        objectId: newElementId,
        shapeProperties: {
          link: {
            pageObjectId: "<YOUR_PAGE_ID>"
          }
        },
        fields: "link"
      }
    }];

Note that you will need your presentation's id and the destination page's id. If you prefer, you can use a slide index as a destination (more information here).

In case you need more help creating a slides add-on, you can visit this example.

If you have any other question regarding this topic, please don't hesitate to reach back.

Regards

you beautiful soul. You're kind of amazing ngl. – Corie LeClair Oct 08 '19 at 11:35 — Corie LeClair, Oct 08 '19 at 11:35

score 1 · Answer 2 · answered Oct 06 '19 at 00:23

1

Yes, it's possible. Checkout Extending Google Slides and shape.setLinkUrl(url)

answered Oct 06 '19 at 00:23

Rubén

34,714
9
70
166

I clicked on the link(s) and it put me in the right direction, but I can't figure out how to apply it to the shape I created. Should I create a new question? – Corie LeClair Oct 06 '19 at 01:36
Pythonnnnnn: Check my answer, it may provide you the insight you need. – carlesgg97 Oct 07 '19 at 14:36
1

@carlesgg97 it did! Also Ruben, thank you! You put me on the right track to understand it. I appreciate both of you! – Corie LeClair Oct 08 '19 at 15:50

How to attach a link to a shape or text box on Apps Script?

2 Answers2