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

Possible to calculate If Field format is not MM/DD/YYYY then...

Featured Replies

I have a script and it has a user input field, I'd like to be able to say "if FIELD is not in the format MM/DD/YYYY then..." Is there a way to do that? Thanks.

I believe your question is based on a false assumption. A field does not have a date format (though it can be formatted to display in a certain way). What exactly is your purpose here?

  • Author

I have a script that shows a custom dialog, and then asks for a date. The custom dialog uses a temporary field, so when you entered the date, the next steps do calculations on it between dates. My problem if someone is supposed to put 09/30/2012 in there but instead puts Sep 30, 12, it doesn't work right. Some of the script steps after are something like If ( temp field = Get(CurrentDate) then exit script, etc.

If you are not sure your users know how to input dates, your best bet is to use a field with a drop-down calendar.

Note that even if you know the expected format is M/D/Y, you can't tell if an entry of "12/1/2012" is correct (December 1) or not (user meant to enter January 12).

  • Author

Ya I always use the drop-down, but I don't think you can do it with the Custom Dialog in the script can you? My Customer Dialog part has an input field that is where they need to enter the date.

Use three field m/d/y and then assemble it on submit.

But with FileMaker 12 you have the option of presenting any layout as a dialog, using the advanced new window options. And therefore you can place any controls you want on the layout.

I don't think you can do it with the Custom Dialog in the script can you? My Customer Dialog part has an input field that is where they need to enter the date.

There is something you can do with a standard custom dialog:

ValidDateDialog.fp7.zip

  • Author

that worked like a charm. Thank you!

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.