Return to FileMaker.com
Calculating Blank fields
I have a table with about 15 fields and I want to make sure all fields are filled then the form is submitted. How can I calculate the blank fields.
Open Field options for each and select the "not empty" validation rule for them.
ValueCount ( List ( field1 ; field2 ; field3 ; ... ; Field15 ) ) //list each field from your layout
will = 15 only if there is data in all 15 fields listed inside the List function.
Retrieving data ...