All Questions
27 questions
0
votes
2
answers
66
views
Moving Value from Google Sheets Cell to Google Doc
I have a Google Sheet that has long blocks of text in each cell of column H (it is input from a long-form response box in a Google Form). I want to take each response and move it onto a new page of a ...
0
votes
0
answers
81
views
Google Appscript change date format and currency
did you know how to change the date format from DD/MM/YYYY to YYYY/MM/DD and currency format ?
because I already did change the date format to YYYY/MM/DD and currency to ₩1,000 in spreadsheet, but ...
1
vote
1
answer
1k
views
Open a link in Google Document with one click using google apps script
When You make a link in a google document it takes two steps to open the link. (First click on the link and then click once again to open it.)
Is it possible to make a script that opens the link right ...
user12736831
1
vote
1
answer
1k
views
Unable to open a document using DocumentApp.openById() in google app script
I am trying to create a copy of a template document and edit some text in it using the following code :
const destinationFolder = DriveApp.getFolderById(folderId) //folder where to save the document
...
- 13
0
votes
1
answer
525
views
How to instantly print marked columns in google sheets with script?
I have file in google sheets(img 1).
https://i.sstatic.net/1j8ny.png [1]
i wrote script which is converting marked columns to word (i need to mark only 1st 4 columns becuase its going to be on ...
0
votes
1
answer
141
views
How to add edit and delete response menu to Google Form for users through Google API /Form Scripts?
Is it possible to add menu to Google Form for users through Google API /Form Scripts to edit and/or delete their own responses. Such menu is available for owner of Google Form.
- 486
0
votes
1
answer
472
views
Creating folders in google drive from updating rows in google sheets
I am able to create folders from an existing list in google sheets. This list keeps growing and I would like for the folders to be created (probably on a time trigger). My problem is that it creates ...
- 5
2
votes
1
answer
730
views
Removing version history in Google Doc or Sheet without duplicating file
Is it possible to remove the version history in Google Doc or Google sheet without duplicating the file. App Script solutions are also welcome.
- 5,891
0
votes
1
answer
46
views
Convert a closed google Doc to a PDF and attach it in an email
I have a spreadsheet form that takes its information and places it into a document which then needs to be converted to a pdf and sent as an attachment.
I have the document 'Template' ready to go but ...
1
vote
1
answer
182
views
Interactive Google Spreadsheet to Google Doc edit not working
I have several projects and they respect the same structure they have a table of 8 rows and two columns and I wrote so far a script that takes all the docs and then puts them in a table with the ...
- 373
1
vote
1
answer
2k
views
Google script copy text formatted from Google Docs to Spreadsheet keep bold/underlined... format
I have a Google Doc with a text inside and I did a script so that if I select the text it will copy to a Google Spreadsheet in a cell.I arrived to copy the text but i don't know how to do to keep the ...
- 373
0
votes
1
answer
40
views
Google Spreadsheet impossible to read attribute from 0
Hello I have several 2018 projects Google Docs and I want to put all theirs URL in a Google Spreadsheet in column A like here so the document Spreadsheet is empty
This is the function I wrote and ...
- 373
0
votes
1
answer
233
views
app-script/Google Docs to Spreadsheet and vice-versa
Hello :) I wonder if there is a script/Google script that takes several Google Docs Documents with the same table inside,same structure(I mean table with first name,last name,age,classroom,final grade)...
- 373
0
votes
0
answers
57
views
Generate text file from Google Spreadsheet and return its link to a cell in the sppreadsheet
I have some strings as data that I am originally storing in a cell, say D2. I want to store that data onto a text file or Google docs file and then print the link to that file in D2. How do I achieve ...
- 11
1
vote
2
answers
278
views
Fill cells in one tab with specific values collected from other tabs in google sheets
I'm trying to fill the cells range in one tab with the specific values collected from other tabs in my google sheets. However, I can't manage to write a correct script for it.
Here's a more detailed ...
- 3,535