Save a field value into the list as \N/A\" if it gets left blank"

  • 14 September 2015
  • 3 replies
  • 0 views

Badge +4

Hi,

I have a form which is collecting a bunch of new employee information. 

If "Part Time" is selected as Employment Status, an extra control appears so the number of hours per week can be entered.

If Part Time is NOT selected the Part Time hours control does not appear. If this is the case, I want N/A to be saved as the result in the list. I'd rather not have this as a default since I think it may confuse users.

I have tried a couple of runtime functions including If and Is Null or empty ( and a combination of both) but must be doing something wrong.

I am trying to say if "Part Time Hours" is empty when the Form is saved, show N/A as the result in the list.

Thanks for any help,

Lexie


3 replies

Badge +9

What was going wrong by using runtime functions?

Badge +4

Hi,

I wasn't getting a result. Just a blank. How would suggest the formula should look?

Lexie

Badge +4

The answer was simple. There is a field under Advanced in the Control Settings called Null Display Text.

Reply