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.

Preventing blank records

Featured Replies

I'd like to prevent users from creating empty records. What is the best approach. Could I write a script that checks the entry as the user exits the record?

One way:

Make a new layout and a global field for each field in the database.

In the new layout, have a button for the user to click that checks to see the fields arn't all empty, and if they arn't, make a new record with the globals as the fields.

There should be other ways, but that is just one.

If you use FMP6, you don't even need a layout. Use the new custom dialog box for new record imput, or at least the main fields (up to 3).

what's wrong with simply validating the required fields to 'not empty'. seems to be the most straightforward solution.

  • Author

validating could work, but there isn't really one required field. Sometimes there may be no business name and sometimes there may be no first and last name. I could probably make a combined hidden field with first name, last name, and business name and validate that as not empty.

"Not Empty" validation on all fields becomes a nightmare for users when they accidentally make a new record, or want to make a new record but don't have all the info yet.

Best to decide which data *really* needs to be there and only validate for that. One or two fields at most.

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.