Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

At the end of each row filled in, using a custom Google Form, I'm adding three more columns:

  • Date of creation
  • Unique ID
  • QR code (it is a list of computers)

Unique ID and QR code are unique. QR code is generated from the values of all the cells in the form.

How can I create a script trigger to generate the three cells: Date, Unique ID and QR code onsubmitform?

Here is the code for the cell, for how I simply copy the formulas to generate the QR codes:

Date: =Today()
Unique ID: =CONCATENATE("ROTA-",LEFT("0000",4-LEN(ROW(A2))),ROW(A2)-1)
QR code: =if(isblank(B2), "", image("https://chart.googleapis.com/chart?chs=200x200&cht=qr&chl=Type:"&B2&", "&"Make:"&C2&", "&"HDD:"&D2&", "&"RAM:"&E2&", "&"Drive:"&F2&", "&"Keyboard:"&G2&", "&"Monitor:"&H2&",

The last one is pretty long and each value needs to be adjusted to the next row values. Basically I need to do something like this but more difficult: reference question

share|improve this question
Can you clarify why you are using Today() rather than the date in the Timestamp? – pnuts Sep 25 '14 at 21:55

Instead of using a script, consider to add the responses to another sheet using formulas and there add the three columns.

It's worth to say that Today() column will be updated when the recalculation occurs.

I.E. Adding a column with the formula =Today() to the responses of a form add the following formula to A1 in a new sheet:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.