Skip to main content
Inspiring
December 23, 2019
질문

Not equal to NULL and not equal to zero

  • December 23, 2019
  • 2 답변들
  • 2303 조회

I've seen a lot of posts on how to compare a value to v_null in order to make sure a field is not left blank. I'm trying to solve the opposite -- I need some fields to actually be blank and can't figure it out. 

 

Help! (please!)

이 주제는 답변이 닫혔습니다.

2 답변

Participant
October 22, 2022

I'm trying to accomplish the same thing and what occurs to me after reading this is to attach an action so that if the user even clicks on an unacceptable blank it assigns that blank's variable as Done. Then, you can add to the advanced action that if "unwanted blank" = Done it marks it wrong. If ≠ Done marks it right. I'll see if that works for me.

Lilybiri
Legend
December 23, 2019

The variable v_null appeared in one of my blog posts 9 years ago, see that it has been taken over by many. That post has been updated recently:

http://blog.lilybiri.com/where-is-null-in-cp2017

Can you explain exactly what you want to do? Normally the logical expression with 'equal to v_null' should work.

Inspiring
December 23, 2019

Thank you so much for replying.

Our project is teaching users how to fill out specific forms. In many cases it is imperitive that the user understand that the standard is to leave a field blank vs entering a zero. 

 

Equal to null works... but so does entering zero.

 

I've tried 'contains' as well, no joy.

Lilybiri
Legend
December 23, 2019

As I tried to explain in the blogs, the workaround is due to the fact that blank, zero, all strings are considered to be not numeric and equal to 0.  A variable has no type, it can be a string or numeric.  Can you post a screenshot of the advanced action (use the Preview screen) you are using ? Tell which event is triggering the action and how you tested.