Re: Show If with multiple expressions

RESPONSE_Mainte · 10-05-2020 11:25 AM

Hi
New to Appsheet so apologies if this is really simple to everyone else.

I have a form that I show the next field to a user based on the selection of the previous field, so often Enum options etc

I have a field (FIELD A for this example) that actually needs multiple expressions I think as it has to be displayed from a couple of other fields (that probably makes no sense)

Here is my show_if statement:

AND([contractortype]=“Maintenance T”, [quotetype]=“Manual Quote”)

great! that works, Field A is displayed when ‘Maintenance T’ and ‘Manual Quote’ options are selected

but I also need to add

ISNOTBLANK ([tradeuser])

I don’t know how to write that expression, I can make either expression work alone but not when together

Is there a simple way to make both expressions work together?

As a beginner I thought I could just literally do this:

AND([contractortype]=“Maintenance T”, [quotetype]=“Manual Quote”)
ISNOTBLANK ([tradeuser])

Be grateful for any advice

Steve

I’m not clear exactly what you want. It sounds like:

OR(
  AND(
    [contractortype]=“Maintenance T”,
    [quotetype]=“Manual Quote”
  ),
  ISNOTBLANK([tradeuser])
)

RESPONSE_Mainte

Steve

That worked perfectly, exactly what I wanted. I’ve spent hours trying to make that work, now I will try and learn the logic in that expression.

Thanks so much, fantastic support.