I have a form set up and the data goes to a report however I would like to add some custom scripts but don't know where to start.

1) I have a form field that needs to be forced into all caps on user input (or data submit).  I have tried a few options with the .toUpperCase() but can not get it to work.

2) Is is possible to have data on my report (specific row) to highlight a specific color based on a the date/time? For example, if the system date is within 1 hour of the field called "outbound_time", the data row will highlight in yellow.

I am sure there are a couple other ideas I could have but if I could figure at least point 1 above, that would be a excellent start.

Thanks