Jump to content

Calculation to auto-fill date based on checkbox


This topic is 4336 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

...and that's why you're the expert! :D 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.

Link to comment
Share on other sites

This topic is 4336 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.