google-docs

Is it possible to send HTTP request from inside Google docs?

by

Using Google Apps Script, you can make HTTP requests to external APIs from inside Google Docs/Sheets/etc. using the UrlFetchApp class: var url=”https://gdata.youtube.com/feeds/api/videos?” + ‘q=skateboarding+dog’ + ‘&start-index=21’ + ‘&max-results=10’ + ‘&v=2’; var response = UrlFetchApp.fetch(url); Logger.log(response); Note that: This service requires the https://www.googleapis.com/auth/script.external_request scope. In most cases Apps Script automatically detects and includes the scopes a … Read more

Collapsing Elements in a Google Doc With Google Apps Script – Is This Possible?

by

You cannot do anything special in Apps Script, just automate stuff that you can do manually. So, there’s no way to do real collapsing, since there’s no such feature in Google Docs. But you can use available functionality in unorthodox ways and make it work for you. For example, you could save the content somewhere … Read more

What are the Google Apps MIME Types in Google Docs and Google Drive?

by

Google Docs: application/vnd.google-apps.document application/vnd.google-apps.kix Google Presentations: application/vnd.google-apps.presentation Google Spreadsheets: application/vnd.google-apps.spreadsheet Google Drawing: application/vnd.google-apps.drawing See here for more information. Here is a long list of Google Docs and Google Drive MIME types (it is not exhaustive): application/vnd.google-apps.audio application/vnd.google-apps.document application/vnd.google-apps.drawing application/vnd.google-apps.file application/vnd.google-apps.folder application/vnd.google-apps.form application/vnd.google-apps.fusiontable application/vnd.google-apps.kix application/vnd.google-apps.photo application/vnd.google-apps.presentation application/vnd.google-apps.script application/vnd.google-apps.sites application/vnd.google-apps.spreadsheet application/vnd.google-apps.unknown application/vnd.google-apps.video

Convert a Markdown text file into a Google Document using Appscript?

by

One suggestion: use Pandoc to convert Markdown to docx, then import to Google Docs using the Google Drive API. You can also accomplish this using the Google Drive web interface: Convert markdown to ODT (or some other intermediate) using pandoc: pandoc MyFile.md -f markdown -t odt -s -o MyFile.odt Move the ODT file into your … Read more

How does Google Docs deal with editing collisions?

by

There are different possibilities for realizing concurrent changing of replicas, depending on the scenario’s topology and with different trade-offs. Using a central server The most common scenario is a central server that all clients have to communicate with. The server could keep track of how the document of each participant looks. Both A and B … Read more

On Google Spreadsheet how can you query ‘GoogleFinance’ for a past exchange rate?

by

In order to retrieve the historical rate, you have to use the following formula: =GoogleFinance(“eurusd”,”price”,today()-1,today()) where today()-1, today() is the desired time interval, which can be explicitly defined as the static pair of dates, or implicitly, as the dynamically calculated values, like in the example above. This expression returns a two-column array of the dates … Read more

Alerts when navigating away from a web page

by

By the browser. It’s the beforeunload event handler that returns the customized text of the dialog, which is only the middle of the three paragraphs – the other two paragraphs as well as the text of the buttons cannot be customized or otherwise changed. window.onbeforeunload = function(){ return ‘Testing…’ } // OR var unloadListener = … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)