Ok I have a status list. Which is a list of Radio button of the status of a particular document. The list has

O - To Complete

O - Faxed

O - Approved

I have a 2 fields below the status box which are both dates. Whenever the user selects Faxed I want today's date put into the field. I've got it working with an "if" calculation:

If(Completion Stage = "Faxed", Today, "")

but then when the button moves from "Faxed" to "Approved" the date is deleted because my second result in the "if" statment is just "", I was hoping I could get the date to stay there. My second date field serves the same purpose but I want today's date to appear the day the person click on approved.

I want to keep the Radio buttons and not change to Checkboxes, because Radio button are needed for some of my other scripts to work (ie only one option status can be selected at one time).

I like the radio buttons and would also prefer not to have to put an actual button next to the radio button in order to fill the field. Is there another statment that works like the IF but doesn't delete my date once the Radio button has been changed?

Suggestions greatly appreciated.

Anthony.

Define your date fields to be auto entered calculation fields.

Case(Status = "Approved",Status( CurrentDate))

Where "Status" is the radio button field you are "watching".

Edited February 3, 200620 yr by Guest

Thanks worked like a treat.

Edited February 6, 200620 yr by Guest