Skip to main content
Nintex Community Menu Bar

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

  • September 14, 2015
  • 3 replies
  • 6 views

Forum|alt.badge.img+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

Forum|alt.badge.img+9
  • September 14, 2015

What was going wrong by using runtime functions?


Forum|alt.badge.img+4
  • Author
  • September 14, 2015

Hi,

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

Lexie


Forum|alt.badge.img+4
  • Author
  • September 15, 2015

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