Is blank on multiple condtions - simple syntax query

Like (0) Share

Report

Posted on 14 Jun 2022 14:34:31 by vffdd

1,257 Super User 2024 Season 1

I know this is just a simple syntax but just can't get the right order !

Trying to disable a button if a text box is empty AND a collection is empty. No errors but it only works one or the other. So if I put something in the text box and not in collection or vv it switches to edit mode. Here's what I've tried

If(IsBlank(txt_landing_pushnotificationtext) && IsEmpty(coTest),DisplayMode.Disabled,Edit)

If(IsBlank(txt_landing_pushnotificationtext) AND IsEmpty(coTest),DisplayMode.Disabled,Edit)

If(IsBlank(txt_landing_pushnotificationtext) && IsBlank(coTest),DisplayMode.Disabled,Edit)
If(IsBlank(txt_landing_pushnotificationtext) AND IsBlank(coTest),DisplayMode.Disabled,Edit)

I know someone will look at this and see exactly what I'm doing wrong but it ain't me ! 🙂

TIA

Categories:

General Questions

I have the same question (0)

All responses (6)

Answers (1)

vffdd 1,257 Super User 2024 Season 1 on 17 Jun 2022 at 08:11:25

Like (0)

Report

Re: Is blank on multiple condtions - simple syntax query

Yep that works. Thank you 🙂

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on 15 Jun 2022 at 14:37:45

Like (1)

Report
Re: Is blank on multiple condtions - simple syntax query

@vffdd

If you are evaluating a collection, IsEmpty() is sufficient, perhaps this is the reason it didn't work. I switched the logic in the formula below?

With({blnk:!IsBlank(txt_landing_pushnotificationtext), emp:!IsEmpty(coTest) }, If(blnk&&emp, DisplayMode.Edit, //Edit enabled only if there is data in DisplayMode.Disabled) // the textinput and the collection ) )

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on 15 Jun 2022 at 11:29:00

Like (0)

Report

Re: Is blank on multiple condtions - simple syntax query

unfortunately doesn't work @Drrickryp as soon as I type in the text box (collection still emtpy) button becomes enabled same result as my options above

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on 15 Jun 2022 at 11:02:01

Like (0)

Report

Re: Is blank on multiple condtions - simple syntax query

@vffdd

They are temporary variables. Think of them as aliases for your formulas.

Was this reply helpful? Yes No
vffdd 1,257 Super User 2024 Season 1 on 15 Jun 2022 at 09:53:46

Like (0)

Report

Re: Is blank on multiple condtions - simple syntax query

thanks @Drrickryp ok that wasn't what I was expecting !🤣 Have never used with before.. what is the blnk and emp?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on 14 Jun 2022 at 14:41:16

Like (0)

Report
Re: Is blank on multiple condtions - simple syntax query

@vffdd

The following will have display mode disabled if txt_landing is blank and cotest is either blank or empty.

With({blnk:IsBlank(txt_landing_pushnotificationtext), emp:IsEmpty(coTest)||IsBlank(coTest) }, If(blnk&&emp, DisplayMode.Disabled, DisplayMode.Edit) ) )

Was this reply helpful? Yes No