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

I have a Google Docs spreadsheet that I use to track my jobs by job number. Is it possible to have the "job number" field pre-populated with the next job number? Currently I have to open the spreadsheet to obtain the next number and then input it into the form—which defeats the purpose.

share|improve this question

Is there a reason you can't use the row number as the "job number"

Each Google Form submission is added on its own line, so each row of the spreadsheet should be a separate entry by the user.

If you really need to number your jobs outside of the scope of the row numbering, then you can also do this inside the Form without altering the Form itself.

  • Go to your Form responses (the spreadsheet that has recorded the input)
  • Insert a column on the left or right of the entire dataset and title the column "Job number"
  • Prepopulate the column with job number IDs and then use those to reference the job.

Note: when adding or inserting columns to your Form responses, you can only add columns, NOT reorder them. If you try to reorder the columns, you will break the logic of the Form (you will be presented with a warning message to proceed)

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.