How to force user to complete a record

[terrypink]

Wondered if anyone could help me?  Right now, I have a layout based on a table where if a person presses the "Submit" button, they commit the record and also start a new record.

 

In addition, I created a script trigger that when the layout is "OnRecordLoad" that a new record is created and the AccountName of the user is set to this record's foreign key.

 

The problem is that now I have way too many empty rows in my data.  Whenever a user just loads the layout and exits out (even without entering any data), they end up leaving an empty row.

 

 

[Steven Swallow]

It sounds like you haven't got any validation in place.

 

First step would be to make any relevant fields 'required' values. You can do this in the options of the individual field under 'Validation'. You can then create a validation message...something along the lines of, "You must enter a blah de blah".

 

That should get you somewhere.