Installation is easy, follow the steps below and it will be fully installed.
-
Create a new Google Sheet or Document.
-
Go to extensions/apps script
-
Select and make a new project
-
On the left, and click the plus button above "library."
-
Paste the following ID in the box and press look up.
1LcDmG8gFKv8HQ3VwovO0ifyHS7TWjBMup6kfPhKBTOkJ1pBNE3eDgiKm
-
Select the version of your choice and add it.
-
Success! BetterGUI is fully installed.
[BetterGUI is still in progress]
[NOTE THAT BETTERGUI WORKS BOTH FOR GOOGLE SHEETS AND DOCS]
| Function | What it does |
|---|---|
| popUp(title, text) | Opens a more professional looking UI popup box |
| showDialogFromHtml(html, title) | Opens a dialog containing html |
| showSidebarFromHtml(html, title) | Opens a sidebar containing html |
Since BetterGUI offers UI content, there are a few things that you can do with it.
Lets start off with the simple.
You can launch the UI by writing the code below:
BetterGUI.popUp("Title goes here", "Text goes here");Upon running the function, you will get a message similar to this:
You can also use BetterGUI to display input, such as the following:
function getText() {
var input = SpreadsheetApp.getActiveSheet().getRange('A1').value; //Retrieves text from cell A1
var title = SpreadsheetApp.getActiveSheet().getRange('A2').value; //Makes the title the value of A2
BetterGUI.popUp(input, title);
}BetterUI has simplified the HTML process.
Here is an example of how to use:
function showDialog() {
var html = ''; //You can add html here
BetterGUI.showDialogFromHtml(html, 'title'); //Removes a whole lot of steps
}
//You can do the same with sidebars:
function showSidebar() {
var html = ''; //Yet again add html
BetterGUI.showSidebarFromHtml(html, 'title'); //Works the same way as dialog but with sidebar
}BetterGUI has been made open source under NO licensing (it's absolutely free to use and edit) so that others can fit their parts into it to make it a better program.
You can access the open source code here