Check for non-empty field

Kristjan Geir Mathiesen over 9 years ago

Hey.

I have a field that I want to be be shown if my custom field "jira_project_c" has a value (i.e., is not empty). So I am going to use the "Dependent" attribute/feature of the field. Now I just can´t hammer together the formula :/

What I really need is the opposite of equal($jira_project_c,"") but there does not seem to be a "NotEqual" function...

Tried: ifElse(equal(strlen($jira_project_c),0),0,1) but Formula Builder complains "The formula must be of type boolean"

Help please!

Thanks as always,

KGM

Parents

0 Megan Sheehan over 9 years ago

Hi Kristjian,
With dependent fields, you want the formula to evaluate to true or false. I think you were on the right track, but are making it too complicated. I would try something like:
greaterThan(strlen($jira_project_c),0)

Business Analyst

Technology Advisors, Inc.

Reply

0 Megan Sheehan over 9 years ago

Hi Kristjian,
With dependent fields, you want the formula to evaluate to true or false. I think you were on the right track, but are making it too complicated. I would try something like:
greaterThan(strlen($jira_project_c),0)

Business Analyst

Technology Advisors, Inc.

Children

0 Kristjan Geir Mathiesen over 9 years ago in reply to Megan Sheehan

Aren´t you the most wonderful thing! It worked. Thanks a million. Over thinking - yeah I am. Lot´s to learn on these first few weeks for this not-so-big brain...
I really appreciate your help,
KGM