Prevent a column values from been cleared up when receive leads from Google Forms

[Web Support]

Hello,

I've created a Google Form where when user submitted his email and full name, my other Google Sheet will auto-update its rows showing those two values.

Now, inside that same Google Sheet, I've also created an extra column (name Giveaway code) with like 100 rows of values.

The problem now is whenever user submitted the Form, it will update the Sheet but it will clear up the value inside the Giveaway code column.

Is there any workaround where I can lock all the values inside the Giveaway code column?

Here's the example of the sheet https://docs.google.com/spreadsheets/d/1KkShktBnJoW9TmIzNsAuAJb6XslBrMwJGEJu7xeF1fk/edit?usp=sharing

[Riël Notermans]

Easiest would be to add a second sheet, where in A1 you put =ARRAYFORMULA(firstsheet!A:X) where X is last column. Then in column Y you can put your codes.

Op vr 5 apr. 2019 05:37 schreef Web Support <websu...@causeeffect.asia>:

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-script-community.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/a3c5a31b-b216-4565-b4c4-7d517f417dd1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mike]

If I follow your use case correctly, and if your codes can be calculated based on a form field (like random generated from date time), you should be able to add a sheet column after the last form column and just use an arrayformula to add the code into each row. I have done this without problems in other applications.