No selection and not empty

Chong-ho (Alex) Yu, Ph.D., MCSE, CNE, CCNA


I created several compulsory fields in FileMaker pros. To submit data into these fields, users will select a value from a pull-down menu, such as


		<SELECT NAME='project' SIZE=1 > <OPTION VALUE="">
		- No Selection - [FMP-VALUELIST: project, LIST=project] 

In validation I selected the "Not empty," but even if users did not select anything and press the Submit button, FileMaker pro still accept the submission. Why?

Project Type:

Due Date:



When you set up a pull-down menu by CDML, the default option is "-No selection-." When the form is submitted, the text "-No selection-" will be input into the field. To remediate this, the validation should be performed by calculation:

The calculation can be specified like what is shown on the right. You may say it is easier to erase the option "-No selection-" from the drop-down menu. However, if this option is removed, whatever appears on top of the menu will enter into the field upon submission, even if no choice is chosen by the user.



FMP Tips Contents

Other computer tips

Search Engine

Credit/Copyright ©

Simplified Navigation

Table of Contents

Contact Me