I have a container field named "Ash." I would like to be able to load either an Excel template link or a blank Excel workbook link into the container using the "On Object Modify" script trigger. I would then like to have them do the data entry they need to do, and then use "Save As" in Excel to save the file in the right location. I then want to put a link to that new file in the container for storage purposes. I really don't want to have to make them create the file before doing this. Is there any way to set a script, or a series of scripts, to do this?
I also have a script that runs off the same box for "On Object Save," to record the user name and date of the entry in the associated fields.