mehronx Posted October 16, 2002 Posted October 16, 2002 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?
falkaholic Posted October 16, 2002 Posted October 16, 2002 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.
Vaughan Posted October 17, 2002 Posted October 17, 2002 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).
stefangs Posted October 17, 2002 Posted October 17, 2002 what's wrong with simply validating the required fields to 'not empty'. seems to be the most straightforward solution.
mehronx Posted October 17, 2002 Author Posted October 17, 2002 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.
Vaughan Posted October 17, 2002 Posted October 17, 2002 "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.
Recommended Posts
This topic is 8077 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 accountSign in
Already have an account? Sign in here.
Sign In Now