topic Re: Property with expression and IF statement in Documentation

Property with expression and IF statement

ATS — Fri, 23 Jun 2023 07:24:57 GMT

I'm not skilled enough with the expression tool or code to understand how my expression should be set up and hope someone can teach me:

I have 2 "String" value properties that I want to merge, in a new property, but be blank or " " if not both values are defined.

String1 has a default value - Value "ABC" that should always be there.

String2 has Default value - Undefined and should be filled in as needed

So far I've set up the Expression like this:

CONCAT ( String1; String2 )

This works well if both values are defined, but leave a "---" as autotext if I don't fill in a value for String2.

Is there a way to add a IF function that says

"if String2 = undefined " " else CONCAT ( String1; String2 )"

That way the --- would be hidden for a blank space if the value is not filled in yet.

Thank you for any help.

Re: Property with expression and IF statement

Xandros — Fri, 23 Jun 2023 07:49:36 GMT

Hi,

CONCAT(String1; IF(ISUNDEFINED (String2);"";String2))

you can directly use the IF-Formula inside of the CONCAT. Hope, this works for you - otherwise it needs some adjusting in the condition-part of the IF

Re: Property with expression and IF statement

ATS — Fri, 23 Jun 2023 07:55:34 GMT

Thank you for the quick reply. The suggested line adds String1 before considering if String2 is undefined, but I managed to just do the CONCAT inside IF instead of IF inside CONCAT to fix that.

IF(ISUNDEFINED (String2);"";CONCAT (String1; String2))

You helped me with the right puzzle pieces and I got it working so thanks again! 🙂

Re: Property with expression and IF statement

kmitotk — Fri, 23 Jun 2023 08:02:33 GMT

CONCAT (String1, IF (ISUNDEFINED (String2),"", String2))

Re: Property with expression and IF statement

Xandros — Fri, 23 Jun 2023 08:02:44 GMT

You're welcome 🙂

@ATS wrote:

String1 has a default value - Value "ABC" that should always be there.

If String1 needs to always be there, i feel like your code needs to be adjusted slightliy:

IF(ISUNDEFINED (String2);String1;CONCAT (String1; String2))

Re: Property with expression and IF statement

ATS — Fri, 23 Jun 2023 08:05:29 GMT

I can see that I worded that badly. I meant that it should always be in the Value and the same any time its used, but for my CONCAT expression I want there to be " " if String2 is undefined and "String1String2" if both are defined. 🙂

Re: Property with expression and IF statement

Barry Kelly — Fri, 23 Jun 2023 08:17:52 GMT

I am not sure if you can check if a property is "undefined".

At least I couldn't get it to work.

But if you give it an empty default value you can do this.

Barry.

Re: Property with expression and IF statement

Barry Kelly — Fri, 23 Jun 2023 08:31:09 GMT

OK I completely missed ISUNDEFINED.

Still learning. 😀

Barry.

Re: Property with expression and IF statement

ATS — Fri, 23 Jun 2023 08:32:20 GMT

I guess thats the point of the community 😉