Starting point:
function openDialog() {
var html = HtmlService.createHtmlOutputFromFile('export');
SpreadsheetApp.getUi()
.setWidth(640)
.setHeight(400)
.showModalDialog(html, 'Export');
}
Docs: https://developers.google.com/apps-script/guides/html/
More Related Contents:
- Moving google apps script to v8 file upload stopped working from sidebar
- How do I communicate a page(modal dialog) with its sibling (sidebar)?
- Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
- How to protect the Apps Script code in a Google spreadsheet?
- Is there a way to evaluate a formula that is stored in a cell?
- Automatic timestamp when a cell is filled out
- Apps Script: how to get hyperlink from a cell where there is no formula
- How to download single sheet as PDF to my local device directly (not export to Google Drive)?
- Script to Change Row Color when a cell changes text
- Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
- You do not have permission to call openById
- How to get onFormSubmit to trigger automatically?
- Copying a spreadsheet copies all linked files as well
- “SpreadsheetApp.getUi() cannot be called from this context”
- copy data from one sheet to another in google app script and append a row, one small issue
- Using built-in spreadsheet functions in a script
- Google App Scripts cannot be given Authorization or Permission
- How to get the correct range to set the value to a cell?
- Refresh data retrieved by a custom function in Google Sheet
- How to extract the link from a cell now that links are not reflected as HYPERLINK?
- Dynamically creating spreadsheet menu items
- Increment Cell value by one by clicking
- Is there any limit on number of concurrent hits or simultaneous executions on Google App Script Web App
- email notification if cell is changed
- Dynamic selection options in Google Apps Script for forms
- Determine current user in Apps Script
- How to ignore empty cell values for getRange().getValues()
- Stopping the error “Authorisation is required to perform that action” in Google Apps Script
- We’re sorry, a server error occurred while reading from storage. Error code PERMISSION_DENIED
- e.range.getA1Notation() unable to track changes caused by formula update