Assign edit url to spreadsheet and email link

100%

Assign edit url to spreadsheet and email link

✓ Published0🌍 Public

Last edited Jul 28, 2016

Created on Jul 28, 2016

This example shows a Google Apps Script that assigns edit URLs to a spreadsheet and emails them to form respondents. The script retrieves form responses and their edit response URLs, then writes those URLs as hyperlinks into a specified column of the linked spreadsheet. It uses the FormApp and SpreadsheetApp services to access the form and its destination sheet, matching timestamps to align responses with rows. Finally, it sends an email via the MailApp service containing the edit link, using the respondent’s email address from the first item response.

AI-generated description

Similar vizzes

Loading thumbnail…

Google Form to Trello Board via Email

This example shows how to turn Google Form submissions into Trello cards by sending an email to the board’s private address. It uses the Google Apps Script `FormApp`, `MailApp`, and script triggers. The `onFormSubmit` function captures responses, assigns them to variables, builds a subject line and body, and sends the email via `MailApp.sendEmail`. A trigger runs the function on each form submission. The code relies on Trello’s email-to-board settings rather than the Trello API.

DDerekCaelin

58% match

Loading thumbnail…

Gist ea8710410afc9bb88a65f846e46d04da

This example demonstrates how to automate opening a Google Sheets tab in Chrome at user logon and session unlock, using a PowerShell script to register a Windows scheduled task. The task triggers on logon and session unlock events, launching Chrome with an app-mode URL pointing directly to the spreadsheet. The code constructs an XML task definition with the `Register-ScheduledTask` cmdlet, embedding the Chrome executable path and the spreadsheet URL as arguments. It highlights the use of PowerShell’s scheduled task API and XML trigger configuration, showing a practical workflow automation for persistent access to a specific data source without manual intervention.

HHerbCaudill

49% match

Loading thumbnail…

Retrieve Google Spreadsheets content

This example shows a web page that pulls content from a published Google Spreadsheet and renders it as a numbered list of image cards with text and credit lines. The spreadsheet’s first two rows provide the headline and deck, while each subsequent row supplies an image URL, title, and credit. The code uses jQuery’s `$.getJSON` to fetch data from the Google Spreadsheets feed API, parses the returned JSON, and dynamically appends HTML elements to a container. It relies on a single function, `buildList`, which takes the spreadsheet ID as an argument, and uses basic array storage and string interpolation to build the layout.

LLayne Smith

48% match

Loading thumbnail…

post-google-forms-nodejs

This example demonstrates how to submit form data directly to a Google Form using Node.js, bypassing the need for a browser interface. It shows a programmatic POST request that populates a form with fields such as size, email, delivery method, and address. The code uses the `superagent` library to send URL-encoded form data to the `/formResponse` endpoint of Google Forms. It explicitly maps each form field’s entry ID, like `entry.1721541334`, and includes both regular and "other" response options. The script logs the server response or any errors encountered during submission.

55un

47% match

Loading thumbnail…

Google Sheets Script for Fetching Data from Supabase

This example shows a Google Sheets script that pulls data from a Supabase database and writes it into the active sheet, first clearing existing content. It uses the Supabase REST API via `UrlFetchApp.fetch` and handles JSON responses with `JSON.parse`. The script writes a configurable set of headers to row one, then maps each data row into corresponding columns. It relies on `SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()` for sheet operations, and constants for the Supabase URL, anon key, and table name. The process is automated through a single `mainFunction` that chains clearing, header writing, and data fetching.

HHugoberry

45% match

Loading thumbnail…

Add a URL to a text layer

This example shows how to add hyperlinks to text layers in Sketch by assigning URLs directly to selected text or its active text range. When a user selects one or more text layers and runs the script, it prompts for a URL, then applies that link either to the entire layer or to the specific highlighted portion when text is being edited. The code uses the Sketch JavaScript API, specifically `sketch.getSelectedDocument()`, `layer.sketchObject.addAttribute_value()`, and `UI.getInputFromUser()`, along with `NSLinkAttributeName` and the `textStorage.addAttribute_value_range()` method for formatting range selection. After updating, it reloads the inspector to reflect the changes.

KKevinGutowski

45% match

Loading thumbnail…

Gist ee842d3f857add56f3a62dbd10cbcf1a

This interactive form builder dynamically appends cloned blocks of academic data fields to a page. The code uses the native DOM API, including `getElementById`, `cloneNode`, and `appendChild`, to duplicate a labeled input container. Each new block receives a unique ID and incremented class suffixes. The example demonstrates a client-side approach for adding repeatable form sections without external libraries.

MMistyBlunch

43% match

Loading thumbnail…

Example of using a csv file generated by responses to a Google Form.

A scatterplot visualizes survey responses from a Google Form, showing each respondent's height versus number of pets, with dot size encoding the number of coding languages and color indicating their preferred drink. The visualization uses d3.csv to load the remote Google Spreadsheet data, d3.scale.linear for axes, d3.svg.axis for tick marks, and d3.selectAll with .on("mouseover") to display HTML tooltips. A categorical color scale (d3.scale.category10) drives the legend, while SVG circles render with opacity and hover highlighting.

KKristinHenry

43% match