Adding "password" type to Google Apps Script inputBox

Question

Is it possible to assign the "password" type to the Google Apps Script inputBox so the text doesn't show?

The following is working just fine, but the input field is a simple textbox and displays the text rather than "••••••••":

Browser.inputBox('Please enter your password');

I have a Google Sheet with an associated script that automatically populates some cells with information retrieved from an external API. The API requires simple authentication so that's why I'm prompting the user for their username and password (this is for an internal tool so there are no issues with asking for the password, it's not being stored or anything).

You'll need to use HTML service, and an HTML dialog box. Apps Script documentation - custom dialogs <input type="password" name="thePassword"> Link to password attribute information — Alan Wells
– Alan Wells, Commented Mar 27, 2016 at 2:19

Community · Accepted Answer · 2017-05-23 12:01:48Z

6

Per Sandy Good's comment, I ended up using a custom dialog with an HTML service.

The following works great to show the input with type "password" and pass the value to my google script:

pw_input.html

<script>
  function updateInfo(form) {
    google.script.run.myOtherScript(form.password.value);
    google.script.host.close();
  }
</script>
<form>
  Password:
  <input type="password" name="password">
  <input type="button" value="OK" onclick="updateInfo(this.form)" />
</form>

main.gs

function myMainFunc() {

  onOpen();

  var html = HtmlService.createHtmlOutputFromFile('pw_input')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
  SpreadsheetApp.getUi()
      .showModalDialog(html, 'Please enter your password');
};

other_script.gs

function myOtherScript(promptResponse) {
  etc...
};

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Mar 28, 2016 at 16:59

David Crozier

1,6182 gold badges15 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Adding "password" type to Google Apps Script inputBox

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related