Google Apps Script: How can I call a form from a script embebed in a spreadsheet?

Question

I want to build a script which can allow user to call a form from a function that I added to my spreadsheet menu using addMenu("Menu_name", menuEntries) method.

How can I implement this "go to live form" from inside my function?

Community · Accepted Answer · 2017-05-23 12:12:43Z

1

Simply create a small UI with a link to the form (like any other URL). And add this function in your menu.

See this post for the code to create the UI: Google Apps Script to open a URL

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Nov 30, 2013 at 19:23

Serge insas

46.9k7 gold badges113 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

craftApprentice Over a year ago

It's not possible directly open the form? (whithout having to click in the link)

Serge insas Over a year ago

I'm afraid not, GAS can't redirect a user without user action, even in this google-service to google-service configuration... that's part of their policy I guess

Collectives™ on Stack Overflow

Google Apps Script: How can I call a form from a script embebed in a spreadsheet?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related