Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Calculation to auto-fill date based on checkbox

Featured Replies

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!

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?

  • Author

It's an on/off situation, although being a complete newbie, I had created the checkbox with a value of "Yes."

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

  • 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!

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

  • Author

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

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.