autopopulate a form field to a particular item on a picklist based on the previous submission

autopopulate a form field to a particular item on a picklist based on the previous submission

Hi all,

Hoping someone can guide me on something i'm trying to accomplish with a form and a big picklist.

Suppose i have a form that looks like this:

Username:
Day of the week:
Pick of the day:

The username is a dropdown picklist that has a large amount of entries, say 300ish.  Every user has a pick of the day for every day of the week.  It's only really necessary to do data entry for the information once a week.

So let's say that i have seven entries that i need to enter in for Zachary Taylor.  So i find Zach's name at the very end of the picklist (in alphabetical order), enter the information, hit submit.  For the second day, i have to open up the picklist again, go to the very end, enter the rest of the information, hit submit.

What i want to do is save time by having the form know to auto-populate the Username field to Zachary Taylor based on the fact that i had just entered a record for him.  My question is twofold:

a) should i script this on "On Add" or "On Success"?

b) what's the best way to approach this?  Can an "On Add" grab stuf from a previously saved record?  Or should i maybe grab the record by scripting a look for the "most recently added record" or something?  how complicated would that be to script?

Thanks very much for your help!

Regards,

Mendel