1 Reply Latest reply on Aug 1, 2012 8:59 AM by philmodjunk

    Calculating Blank fields



      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. 

        • 1. Re: Calculating Blank fields

          Option 1:

          Open Field options for each and select the "not empty" validation rule for them.

          Option 2:

          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.