Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.