Need help with automatic date when listbox is selected

[R1Yamaha]

Hello. I was wondering if anyone could help me with this. I have tried but to no avail.

I have created a form in a notes db. I have checkbox created with only one selection called (complete). What i would like to do is have a date field that is right below that check box automatically fill in the date for the user. I have several of these check boxes. This is what is looks like:

1. training {}complete Date -------
2. computer {}complete Date -------

I need to populate that field when complete is selected..Does anyone know how to do this?

 

[pmonett]

Use the option "Refresh fields on keyword change" in the Properties box of your checkbox field.
Your Date fields need to compute the date you want for this to be useful.

Pascal.

 

[R1Yamaha]

Thanks Pascal...Do you know the exact formula for the date to be used only on a select. And how do I tie them together. I have changed the refresh fields on keyword change. I guess the trouble I am having is to put a on select as the value for that field. What formula should I use for the date...I am new to designing so this is my trouble.

 

[pmonett]

I cannot know the formula to be used since I do not have any information on either the field names, or the specifications you are trying to respond to.
As for tying them together, you have if you have made the date field computed. What should the formula look like ? Well something along the line of

@if([i]checkboxfieldname[/i] = "";"";[i]dateyouneed[/i])

should be a start for you.

Pascal.

 

[Troodos]

In the actual date fields, make them computed. Add a formula something like this:

@if(checkBoxField1 = ""; @return(""); @Now)

With the auto refresh enabled as recommended above on the tick box this will automatically fill in the date WHEN TICKED. If I did not miss anything above that was what you wanted...

To avoid any 'unticking' you should/could create a 'hide when' for the actual tick box in the properties. Could be less useful and correct if it can be overridden many times ...

TrooDOS
Yamaha FJR driver