1
Yes there is a way and many people already accomplished this (including me) by publishing the now called G Suite Add-ons. For details please read https://developers.google.com/gsuite/add-ons
I already mentioned two of my add-ons here on Web Applications, Record Viewer and Spreadsheet Freezer.
Record Viewer
In Google Sheets: How do I merge a range of a row ...
1
Please try adding the following:
eventCal.createEvent(volunteer, startTime, endTime, {description: des});
https://developers.google.com/apps-script/reference/calendar/calendar#createEvent(String,Date,Date,Object)
1
To preserve the order the selections are made without resorting to another app or creating your own web form (as stated at Rubén's correct answer), another (easier maybe?) alternative would be to:
Add a "Title and description" above the question
Change the type of your question from "Checkboxes" to "Paragraph"
1
Google Apps Script doesn't have any objects/methods to handle Google Forms view (respondent view) and the order of selection isn't an attribute that is included on the response submission.
If that is a must, then you should look for another app or build your own web form.
1
(Similar questions have been asked before but I believe you will get confused trying to modify the code.)
What you want to achieve is possible by writing some code (a script) in the spreadsheet linked to the form.
Step 1
The first thing to do is to create your form. For the script to work you have to remember just one thing. The first question MUST be the ...
1
Google Apps Script on edit triggers (simple and installable), as well as other similar triggers, only are fired by user actions made by using the Google Sheets user interface, but the on form submit installable triggers are fired when a form response is submitted.
References
https://developers.google.com/apps-script/guides/sheets
https://developers.google....
1
If I understood the question you want that clicking on a edit response link on your spreadsheet the target be opened on the sidebar. This isn't possible.
Several possible workarounds imply to read the link from a selected cell and use that link to set the iframe src attibute. To read the active cell value you could use
var value = SpreadsheetApp....
1
Method 1: Using Find and Replace
Select C column or the range where you want to find and replace.
Then CTRL+H for Windows or CMD+H on MacOs
In Find: -
In Replace: Nothing
Then click on Replace all.
Method 2: Using a formula
You can also use =ARRAYFORMULA(REGEXREPLACE(C:c,"-",)) on cell D1 for example to obtain a column with phone numbers without -...
1
It is currently not possible to customize the Script dashboard, neither can you sort the result by any specific column.
1
The problem is that your script is comparing a Sheet object to a literal on the following code line
if (sheet == '1') {
Replace it by
if (sheet.getName() == '1') {
1
Figured it out:
function onEdit() {
var s = SpreadsheetApp.getActiveSheet(); // Get spreadsheet name
var r = s.getActiveCell(); // store active cell name in current spreadsheet
var cell1 = 2 // This is the row I want to put values
var headerIndex = 1;
var isHeader = r.getRow() === headerIndex;
if(r.getColumn() != cell1 &&...
1
If the Tools --> Script Editor and the Add-ons menu options are missing when you open the file, it probably isn't actually a Google Sheets file.
Make sure to navigate to File --> Save As Google Sheets.
Then the Script Editor option in the Tools menu and the Add-ons menu will be available.
Only top voted, non community-wiki answers of a minimum length are eligible
