I would like to write a trigger/script that involves two (and possibly three) fields. The first is a checkbox set and the second is a date field (the third is a blank text field). I would like the date field to auto-fill (and be non modifiable) once one of the checkboxes was "checked".

Also I would like to add a modifier so that if one particular checkbox was "checked" not only would the date be auto-filled but also the cursor would be auto-tabbed to the third field.

I apologize if this is a naive request or an non executable idea. I am an absolute beginner and all of the scripts and script advice I have read on these forums goes WAY over my head.

Edited April 11, 200916 yr by Guest

You can use a straight auto-entry for the date field if you wanted. However to do this with script triggers, you may want to take a look at OnObjectModify or OnObjectExit, depending on when you want the action to take place.

As for not allowing the user to change the date field, depending on how secure you need it, you can just create a button from that date field itself. The button can run a script that checks to see if that checkbox field is empty. If it is empty then go to the date field, otherwise they can not. If you need something more secure then you have to start playing with privilege sets.