3

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

1

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:

=ArrayFormula(
{
filter(Sheet1!A:B,Sheet1!A:A<>""),
transpose(
split(
rept(
Today()&char(9),
countif(Sheet1!A:A,"<>")
),
char(9)
)
)
}
)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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