March 24, 201114 yr Hi, I did a search on this forum for my problem but the only solution that seemed to come close to addressing it doesn't seem to be possible to implement in my version of FileMaker (9). Quite simply, I have a check box and I want a calculation that will cause another field to display the date (mm/dd/yyyy) when that particular check box was checked. I want the field with the date to be modifiable as well. Thank you for the help!
March 24, 201114 yr What exactly do you mean by "particular check box"? Does the value list have multiple values, and you want the date field to respond to the choice of one of them - or is this an on/off situation?
March 24, 201114 yr Author It's an on/off situation, although being a complete newbie, I had created the checkbox with a value of "Yes."
March 24, 201114 yr For an on/off, the date field alone should be quite sufficient - if it has a date, then the status is on; if it's empty, the status is off. You can use a button to toggle the date field between empty and current date, and conditionally formatted text to display the status as a checkmark (or anything else).
March 24, 201114 yr Author Thank you for such a quick response! I'm not sure I understand correctly, but I think the solution you propose would be entering the date first to then cause a check in a check box (or button) to turn on? If so, what I actually need is to be able to check the check box to "yes" and have that action cause the date that the check box was checked to appear next to it in another field. If I misunderstood, sorry, please let me know and elaborate on your answer. Thank you for your patience!
March 24, 201114 yr No, I am proposing to get rid of the checkbox field entirely. There is no need to have one field for "printed" and another for "printed on March 24, 2011".
March 24, 201114 yr Author ...and that's why you're the expert! Thanks, I understand what you mean when you put it that way...in my case..no need for one field that says "received" and another for "received on March 24, 2011." I'll play around with it. Thanks again.
Create an account or sign in to comment