AnsweredAssumed Answered

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

Question asked by lexiefall on Sep 13, 2015
Latest reply on Sep 14, 2015 by lexiefall



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,