December 11, 200223 yr I have a number field and also a collection of text fields. What is the proper function to use so that I can populate another field with the number in the number field + the number of text fields that have been filled in. ( i.e. there are 4 colors ordered on job two plus two of the special color fileds hve been filled in...so they order 6 colors)
December 11, 200223 yr numberfield + (IsEmpty(text1) = 0) + (IsEmpty(text2) = 0) + (IsEmpty(text3) = 0) + (IsEmpty(text4) = 0) The (IsEmpty(text1) = 0) expression will evaluate to either 0 or 1 depending on whether the field is empty.
Create an account or sign in to comment