Isnotblank and

[Dave_Willett]

Hi Guys
I have an expression in an Action: ISNOTBLANK([QuoteItems]) but I need a 2nd criteria adding

ISNOTBLANK([QuoteItems]) and [TagField]=“No”

Can someone help with the syntax please.

Thanks

[Sarvesh_Mudkavi]

Try,
And(isnotblank([Quote items]),isnotblank([TagField]))

[Dave_Willett]

Hi Sarvesh, thanks for that.
Only problem is [TagField] will allways hold a text value. “Yes” “No” “Pending” etc so Blank won’t help in this situation.

Cheers

[Steve]

help.appsheet.com

Expressions: The Essentials

Learn how expressions can be used in AppSheet and get started with your own.

help.appsheet.com

AND()

Are all true?

[Suvrutt_Gurjar]

Hi,
@Dave_Willett,

Sarvesh_Mudkavi:

And(isnotblank([Quote items]),isnotblank([TagField]))

Please try following
AND(ISNOTBLANK([Quote items]), [TagField] =“No”)

[Dave_Willett]

Thats the one Suvrutt.

Many Thanks