Question

I have a form template which contains several fields. Two of the fields are CurrentState (a select field) and DateResolved (a text field). The default value of CurrentState is BugUnderInvestigation. When the state is changed to BugResolved, the DateResolved field must be automatically populated with the current date and that static date value must become the field value. I was able to do just that by using the following code in the format for my search field. This SEARCH command searches for all bugs submitted. The format i wrote was: $percntCALC{$quot$IF($EXACT($formfield(CurrentState),BugResolved),$percntDATE$percnt,)$quot}$percnt. But the problem with this is that the date is not static. Everytime I open the topic, the date expands to the current date and not to the date when the CurrentState field was changed to BugResolved. How do I do this? Can I put an onchange event in the select field? How?

Environment

-- MartinJrAdane - 01 Aug 2006

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Any takers on this one? Anybody who might know how to solve my problem? I am new to twiki and so I am finding it hard to make a solution for this one at this point. I have tried looking through a lot of documentations and reports and web pages and fora regarding this but still haven't bumped into the right solution. Maybe you could help me.

regardz, MartinJrAdane

-- MartinJrAdane - 01 Aug 2006

This was asked and answered in ProbleminGettingFormField.

-- PeterThoeny - 09 Sep 2006