if( not empty then add specific text in card

Like (0) Share

Report

Posted on 22 Sep 2022 14:15:22 by Sjon

All,

Maybe this is a simple solution but i am getting frustrated in this formula.

I have this code working, but it needs to be the other way around.

If(
 IsEmpty([DataCardValue13.Text]),
 "Send to CL for re approval",
 Or(
 IsEmpty([DataCardValue14.Text]),
 "Send to CL for re approval 2",
 Or(
 IsEmpty([DataCardValue15.Text]),
 "Send to CL for re approval 3",
 "Pending"
 )
 )
)

So instead of being blank or empty i want to have it with but the Isnotempty or Isnotblank does not exist.

If(
 IsNotEmpty([DataCardValue13.Text]),
 "Send to CL for re approval",
 Or(
 IsNotEmpty([DataCardValue14.Text]),
 "Send to CL for re approval 2",
 Or(
 IsNotEmpty([DataCardValue15.Text]),
 "Send to CL for re approval 3",
 "Pending"
 )
 )
)

Any work arounds for this or simple solution.

So when a specific text field is not empty give me a specific text in another text field.

Categories:

Using Apps Using Formulas

All responses (5)

Answers (1)

RandyHayes 76,287 Super User 2024 Season 1 on 22 Sep 2022 at 15:35:56

Like (2)

Report

Re: if( not empty then add specific text in card

@Sjon

IsEmpty only applies to records/tables not to Text. IN your original formula you were converting your text into a table (the square brackets) in order to then try to use the IsEmpty on it.

All you need is IsBlank - that is blank or "".

And of course...that function returns a true or false, so prepending it with a ! (NOT) operator will flip the trues and falses.

Glad it helps you!
Sjon 29 on 22 Sep 2022 at 15:09:31

Like (2)

Report

Re: if( not empty then add specific text in card

And that simple ! made it work.

Thank you, i was looking for the old fashion Isnotempty or isnotblank
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on 22 Sep 2022 at 14:26:28

Like (1)

Report
Re: if( not empty then add specific text in card

@Sjon

I am not entirely clear on your logic as you have stated it, but if you are looking for the inverse (not) of the conditions, then just add a NOT operator.

Ex:

If(!IsBlank(DataCardValue13.Text), "Send to CL for re approval", !IsBlank(DataCardValue14.Text), "Send to CL for re approval 2", !IsBlank(DataCardValue15.Text), "Send to CL for re approval 3", "Pending" )
Sjon 29 on 22 Sep 2022 at 14:23:50

Like (0)

Report

Re: if( not empty then add specific text in card

I will change it to is blank.
But then i still get the wrong outcome, i want to execute when it is not empty or is not blank.
RandyHayes 76,287 Super User 2024 Season 1 on 22 Sep 2022 at 14:20:56

Like (0)

Report
Re: if( not empty then add specific text in card

@Sjon

Please consider changing your Formula to the following:

If(IsBlank(DataCardValue13.Text), "Send to CL for re approval", IsBlank(DataCardValue14.Text), "Send to CL for re approval 2", IsBlank(DataCardValue15.Text), "Send to CL for re approval 3", "Pending" )

I hope this is helpful for you.