Copy specific field data in current document, store in clipboard, paste values
Posted on 2005-05-17
I've created a simple request system that stores all of our internal literature as a main/parent document. Users go into the database, pick a brochure, and request distribution to a specific address (sometimes another office, or a customer, or distributor, etc). Because the main document is the parent, and the request is the response, items need to be requested one by one. I also use the main document to track inventory and have code that uses the response request (using the qty field) to reduce the main document 'inventory' field when user saves and closes the response/request document. So, maybe my setup isn't ideal for the distribution piece, but it works nicely to track the inventory.
For the most part (50% of the time) users are only requesting a specific peice -- one brochure. The problem is a user might want to request 5 different pieces of literature. Right now, they will have to select the main document from the view, push the request button where a form appears, complete the 10 or so fields (address, qty, distribution type...etc) and then save. And, do this repeatedly to request the other 4 brochures. Not ideal!
I'm thinking if I can have a code that stores the address info (the action will look at the address fields only) and copy the current values of the current document. Maybe once the user 'saves' the document, a prompt will ask 'do you want to request another document for the same location) or something to that effect. At this point, when clicking yes, the code will capture the address info (it will be about 6 fields, add1, add2, city, state, etc...) and bring them to the main view, and another prompt will appear saying "select new brochure' and once they click okay, and they go into the document (open the document), and a new response form opens and populates the address portions, with another prompt saying something like 'you may now complete this form and save the request' (or something like that).
Or -- I am open to another idea that might make this a lot easier and smoother. Thanks in advance!