We need a script to auto-populate an order form based upon fields stored in another list. The requirements are as follows.
1. Profile List - contains fields
2. Order List – contains a few fields that needs to be populated by information from the Profile List.
a. Quick Fill Form– a drop-down box that displays the Titles of the items in the Profile List where the current user is the Author. When a title is selected the fields in the order form are auto-populated with the data from the profile list.
3. 2 Submit buttons
a. the first is a standard Save/Submit button
b. the second is a “Submit and Save as Profile” button
i. When “Submit and Save as Profile” is selected, a Title box appears so that the data entered in the form also creates a new item in the Profile List for later use when creating a form
We can implement the script on our existing list, so there is no need to design a form. We just need a script to perform the steps described with our existing lists.